I am reposting an old post in which I tried to use but does not work
am I doing something wrong.
below is the original post:
Here is a Vba solution:
If you will be entering all your values in column "A" for example use this:
Put a list of your shortened values like...
I need to put value of 2 cells saying cell 'A1" and 'A2' into window's clipboard to use for other purpose
Dim obj as DataObject
When i run code (f5), then opened window's clipboard, it only saved the...
Hi - I have code that pulls data from one sheet and puts it into another. It matches certain values to determine which row to put the data, however sometimes the values won't match exactly and it errors out. Is there a way to put code in that says on error ask user to select row? thanks!
Well hello everyone...
I have posted this before, but since i got no replies or help, i thought i would repost it and ask it a bit differently or something.
So i have an sheet where i want to keep track of my coinflips.. But to make life easy i want to just write down simple things and then...
Can someone help me I have 2 sheets (Sheet 1, Sheet 2) On Sheet 1 I have a list of numbers in Column A (A8:A47) that are also on sheet 2 column A (A2:A93), where they match up I would like to return the value from Sheet 2 which is in column F and put it in Sheet 1 Column F!
Whats the best...
Hi all, Please Help Me to Put this two Worksheet_Change To one Sheet:
- First one:
Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next
If Not Intersect(Target, Range("R6:R1000000")) Is Nothing Then
Hyperlinks.Add anchor:=Target, Address:=Target.Value...
I have an excel worksheet which column "K" is where i put a value in cells K19 down to K200.
every cell in K19 through K200 is summing up the total values in its individual row..meaning the formula in cell K19 is SUM=(O19:NQ19)
I put a "conditional format" in K19 that basically states: if the...
I created a Split form. Used the wizard. It put my fields in the detail section - which I can see all of them and edit them when in Design view. But when I go to Form view there I don't see my fields. I see them in the datasheet section on the bottom and I see the buttons I put in the form...
I have a 4 page spread sheet, 1 of the pages is just raw data, another is a page that when I put in certain results, gives me an outcome, I'm looking to then have a 3rd sheet that will put the data from the first sheet into a form I can print.
I can't seem to use any formula's as there is a lot...
Hi, just trying to create an IF formula, I want to say ' if R3 = M, V3 is 2.5, R3 = Q, V3 is 7.5, R3=S, V3 is 15 and R3 = A, V3 is 30
How do I put this in an IF formula
=IF(R3=M, V3, "2.5", R3=Q, V3, "7.5", R3=S, V3, "15", R3=A, V3, "30")
Need excel gurus to help spot what's going on here. I have a named range that has a value for each of 10 periods. I'm using a Large/Countif formula to identify from other IF statement criteria, which period in named range would be captured for the table I have the formula in. My forumla works...
I just put in VBA for 'ThisWorkbook:
Private Sub Workbook_Open()
Sheet2.Protect Password:=True, UserinterfaceOnly:=False
After running it, it protected the stuff I want. I want to do some more editing and go to unprotect, and says I didn't put in the correct...
Here is the example
1 CREATE POINT 744STEAM:FA0032.PNT
1 PUT POINT 744STEAM:FA0032.PNT TYPE FLOAT
DESC = "4 RECOVERY MCR"
AUDITUPD = NO
COLLECTOR = srhc03
1 CREATE POINT 735WLCLF01:FY0046B.RO01
1 PUT POINT...
I have a calculated field that averages a range of data based on certain conditions. I need a record of this dynamic value to be captured once a day or week, doesn't really matter, when the spreadsheet is opened.
My dynamic calulated cell is O4 and the place I want to put is in a table...
I try to find a way to rearrange a structure chart
Here the current image I get
Here what I would like
Sheet 1, In the range A2...
I am trying to put a number value converted from a text value (Me.empl_no2.Value) into a cell with the format of "00000" with this line of code ...
.Cells(lr_orp, 22) = Format(CLng(Me.empl_no2.Value), "00000")
All I am getting in the cell is '0', not '00000'.
Where have I gone wrong.
Need help on creating a macro for this scenario, I hope this to automatically run as I change value.
If I enter 5 on C2 the macro should put "X" on D2:H2
If I enter 3 on H3 the macro should put "X" on I3:K3
This i currently what I have but it is hanging for some reason.