Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
add rows with copy format of previous row
My worksheet contains following data:
a b c d list total cost of balance funds item fund ----------------------------------------------------- r1 item1 2500.00 r2 item2 3000.00 r3 item3 2000.00 r4 TOTAL 50000.00 7500.00 42500.00 As I add another item, selecting cell a3, r4 should shift one row down, with c4 becoming c5 and the formula should become sum(c1:c4) format of row 3 (font, colour etc) should get copied to row4 Please help how to achieve this with macro (either by writting macro or through macro recorder). thanks harsh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and Paste Format in filtered rows | Excel Discussion (Misc queries) | |||
Copy conditional format to rows below | Excel Worksheet Functions | |||
Need A Macro To Copy Previous Tab to New Tab | Excel Discussion (Misc queries) | |||
Macro to copy previous row and insert two blank rows | Excel Discussion (Misc queries) | |||
How to copy rows from Excel without losing the row height format | Excel Discussion (Misc queries) |