Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing a vlookup formula using a macro
I wrote a vlookup formula to look for a value in cell reference of sheet two.
i copy pasted the formul horizontally. later when it was giving n/a i realized when i copy pasted the vlookup it changed the cell reference from A to B and the C. Is there a way to fix it without going through each cell and changing it back to A. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing a vlookup formula using a macro
"Arain" wrote in message
... I wrote a vlookup formula to look for a value in cell reference of sheet two. i copy pasted the formul horizontally. later when it was giving n/a i realized when i copy pasted the vlookup it changed the cell reference from A to B and the C. Is there a way to fix it without going through each cell and changing it back to A. Thanks No need for a macro. Go back to the original cell and change the reference to absolute (A1 becomes $A$1, or whatever). Then copy/paste this as before, and the reference will not change to B, C etc. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing a vlookup formula using a macro
If I understand your question correctly, go back to the first cell where you
pasted the formula, put a $ sign in front of the A and then copy/paste (easier to put cursor on the small black square in bottom right of cell border, cursor will turn to a black + sign, and drag) into the other cells again. Rick "Arain" wrote in message ... I wrote a vlookup formula to look for a value in cell reference of sheet two. i copy pasted the formul horizontally. later when it was giving n/a i realized when i copy pasted the vlookup it changed the cell reference from A to B and the C. Is there a way to fix it without going through each cell and changing it back to A. Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing a vlookup formula using a macro
You could go back to the original formula, make the A an absolute reference
(put a $ in front of it) and copy it down again. "Arain" wrote in message ... I wrote a vlookup formula to look for a value in cell reference of sheet two. i copy pasted the formul horizontally. later when it was giving n/a i realized when i copy pasted the vlookup it changed the cell reference from A to B and the C. Is there a way to fix it without going through each cell and changing it back to A. Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing a vlookup formula using a macro
i have another issue i just came across. the sheet its taking the data also
change i mean the first column looks in sheet name May second column looks in sheet name June. when i copy paste it copies may all over the place. is there a way to change it in the formula. its sounds painful to go in and change the sheet name from may to june for 10000 lines. can someone please help "Stephen" wrote: "Arain" wrote in message ... I wrote a vlookup formula to look for a value in cell reference of sheet two. i copy pasted the formul horizontally. later when it was giving n/a i realized when i copy pasted the vlookup it changed the cell reference from A to B and the C. Is there a way to fix it without going through each cell and changing it back to A. Thanks No need for a macro. Go back to the original cell and change the reference to absolute (A1 becomes $A$1, or whatever). Then copy/paste this as before, and the reference will not change to B, C etc. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing a vlookup formula using a macro
i have another issue i just came across. the sheet its taking the data also change i mean the first column looks in sheet name May second column looks in sheet name June. when i copy paste it copies may all over the place. is there a way to change it in the formula. its sounds painful to go in and change the sheet name from may to june for 10000 lines. can someone please help "Rick Rothstein (MVP - VB)" wrote: If I understand your question correctly, go back to the first cell where you pasted the formula, put a $ sign in front of the A and then copy/paste (easier to put cursor on the small black square in bottom right of cell border, cursor will turn to a black + sign, and drag) into the other cells again. Rick "Arain" wrote in message ... I wrote a vlookup formula to look for a value in cell reference of sheet two. i copy pasted the formul horizontally. later when it was giving n/a i realized when i copy pasted the vlookup it changed the cell reference from A to B and the C. Is there a way to fix it without going through each cell and changing it back to A. Thanks |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing a vlookup formula using a macro
Select the second column, then use Edit,Replace to change May to June.
"Arain" wrote in message ... i have another issue i just came across. the sheet its taking the data also change i mean the first column looks in sheet name May second column looks in sheet name June. when i copy paste it copies may all over the place. is there a way to change it in the formula. its sounds painful to go in and change the sheet name from may to june for 10000 lines. can someone please help "Rick Rothstein (MVP - VB)" wrote: If I understand your question correctly, go back to the first cell where you pasted the formula, put a $ sign in front of the A and then copy/paste (easier to put cursor on the small black square in bottom right of cell border, cursor will turn to a black + sign, and drag) into the other cells again. Rick "Arain" wrote in message ... I wrote a vlookup formula to look for a value in cell reference of sheet two. i copy pasted the formul horizontally. later when it was giving n/a i realized when i copy pasted the vlookup it changed the cell reference from A to B and the C. Is there a way to fix it without going through each cell and changing it back to A. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP anchored cell reference changing when macro runs | Excel Discussion (Misc queries) | |||
Automation Macro for updating formula when changing cell value | Excel Discussion (Misc queries) | |||
copying VLOOKUP w/o changing formula | Excel Worksheet Functions | |||
How do I set up a formula with a changing range in an excel macro | Excel Discussion (Misc queries) | |||
Changing a chart scale using a formula/macro | Charts and Charting in Excel |