If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Macro Inserting a formula
I am trying to create a macro that inserts a formula into three tabs in one
workbook. I have the formula named "formula" in a 4th tab. I need the macro to find the word "Total" in column B of the 3 tabs and insert the formula one line under. The formula and the data in the 3 tabs are in column A-H, the formula is 5 rows and the rows will have to be inserted as the formula is pasted. Each tab and data spacing between the word Total will have a different amount of rows. Any help would be appreciated! |
Thread Tools | |
Display Modes | |
|
|