Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a handful of montly invoices, where the line items increase / decrease
the amount of rows I may have from month to month. The client wants us to have Invoice Number and the Date at the bottom of the page. I have it setup that G48 has Invoice Number and H48 has a date formula, justified so it shows "Invoice # - Date" We want our logo image below that, so I have that setup as a footer. Excel is finicky with image footers, so having the Invoice # & Date in the footer does not play nice with the logo. I'm just trying to think of a macro that I could run either manually or on save / exit that would move those 2 cells to the last row of the worksheet. We use A4 paper. I hope this enough information & thanks for the assistance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If row 2 contains nothing then move onto next macro....... | Excel Programming | |||
Macro to move row from one worksheet to another | Excel Discussion (Misc queries) | |||
Move data from tab to tab using a macro | Excel Programming | |||
Macro to Move cells | Excel Programming | |||
Macro to Move cells | Excel Programming |