Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy formula relative to left cell?
All -
I have a fomula in cell B2 that uses data in cell A2. I want to copy the formula down but stop when the relative cell in column a is blank or empty. TIA -Jay |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy formula relative to left cell?
Hi Jay,
If every cell in column A is filled in then you can double click on the fill handle, which you will find on the lower right side of the cell say when you have cell B2 selected. http://www.mvps.org/dmcritchie/excel/fillhand.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "JayL" wrote in message ... All - I have a fomula in cell B2 that uses data in cell A2. I want to copy the formula down but stop when the relative cell in column a is blank or empty. TIA -Jay |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy formula relative to left cell?
Thanks - I understand the use of the fill handle. Looking for an automated
macro method. "David McRitchie" wrote in message ... Hi Jay, If every cell in column A is filled in then you can double click on the fill handle, which you will find on the lower right side of the cell say when you have cell B2 selected. http://www.mvps.org/dmcritchie/excel/fillhand.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "JayL" wrote in message ... All - I have a fomula in cell B2 that uses data in cell A2. I want to copy the formula down but stop when the relative cell in column a is blank or empty. TIA -Jay |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy formula relative to left cell?
Dim rng as Range
set rng = Range(cells(2,1),cells(2,1).End(xldown)) rng.offset(0,1).Formula = Cells(2,2).Formula -- regards, Tom Ogilvy "JayL" wrote in message ... Thanks - I understand the use of the fill handle. Looking for an automated macro method. "David McRitchie" wrote in message ... Hi Jay, If every cell in column A is filled in then you can double click on the fill handle, which you will find on the lower right side of the cell say when you have cell B2 selected. http://www.mvps.org/dmcritchie/excel/fillhand.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "JayL" wrote in message ... All - I have a fomula in cell B2 that uses data in cell A2. I want to copy the formula down but stop when the relative cell in column a is blank or empty. TIA -Jay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a relative cell reference that will copy the format? | Excel Discussion (Misc queries) | |||
Copy and Paste of Relative Cell References | Excel Worksheet Functions | |||
Copy a relative reference formula from one sheet to another. | Excel Discussion (Misc queries) | |||
How do I copy a formula with relative ref. keeping the same ref.? | Excel Discussion (Misc queries) | |||
Excel VB-Copy formula down until adjacent cell (left) is blank? | Excel Discussion (Misc queries) |