Hi,
I'm trying to multiple macros in one file that will insert a formula and show not just the result but the formula when double clicking on the cells.
Once I have the formulas I want the macro to copy the formulas and paste it onto other lines (erery 10 lines)
I have added the file to explain better.
The formulas should appear between T6 : CQ(last row)
In my file I have entered the formulas I want in the first set of cells and highlighted each formula in a different color.
For example:
* I want cell T12 to show =T6-T7 then I want to copy this formula in cell T22 as = T16-T17 and so on until the last row. (My example only has a few row but I will add many more lines later on)
* I want cell U12 to show: =U6-U7+SUM(U8:U10). Then I want to copy this formula to each cell to the right (sort of like dragging a formula to the right), and then I want each row below to show the same combination ( The first cell T12 as =T6-T7 and all other cells as =U6-U7+SUM(U8:U10). (row 22, row32, row42 and so on)
Finally I want to enter a formula (the formula already in the first set of numbers - highlighted) in the first cell of each other row (Ex: T13, T14, T15 and U6) and then copy that formula across the row. Then copy in each 10 lines down until the end.
It's hard to read but when you open the file the question is much easier to follow.
Thank you so much for the help!
Bookmarks