Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using formulas in macros
I am using a macro to carry out a repeated task which includes copying a
selection of data into a separate worksheet . I then want to create a formula with the copied data to create further info in another column. However, how can I tell excel to copy the formula into all the rows which hold the records, but only for those rows that do hold records. The number of records copied into the worksheet can vary each time and I only want the formula replicated in the rows of copied data. Hope this makes sense. Can this be done and how do I do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Evaluate Dynamic DDE Formulas | Excel Worksheet Functions | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
Macros, How do I know what they do if I didn't create them. | Excel Discussion (Misc queries) | |||
Help with populating cells using formulas or macros | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |