Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to add formulas to added worksheet
Hi
I have had some excellent help in gettin a new worksheet to be added pulling data from an Active Worksheet and formatting it into individual statements using a macro. The new worksheet added has 290 names and addresses, with each name and address having a space of 25 lines between the next name and address. What I need to be able to do now is to haver certain Cells to have a formula added into the added worksheet. For example, each cell in column "L" and in row 15 of each statement might have the formula F23/3.054. There are quite a few cells in each statement that need this so I would like to automate it as the worksheet is added. Is this possible. Many thanks Malcolm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
Automatically copy formulas to new rows added. | Excel Discussion (Misc queries) | |||
Macro changes formulas on destination worksheet | Excel Discussion (Misc queries) | |||
Sum formulas do NOT expand when rows added ! | Excel Worksheet Functions | |||
how do I lock formulas, but still allow rows to be added or delet. | Excel Worksheet Functions |