Hi All
So I've begun my dabbling into macros and, through much googling, I've learnt how to do a fair bit, but I've now come up with something that I have no idea how to approach. So I'm really hoping someone here can help me. I will try to explain it as best as I can.
We have Sheet A in Workbook 1 that contains a different amount of rows of data each time it is run. I've already run a macro to get it looking how I need it. However, now I need to copy all the rows from Sheet A in Workbook 1, however many there may be at the time that the report is run, and paste into Sheet A of Workbook 2. Now the catch is that Sheet A of Workbook 2 has formulas in it AND it has formatting of its own, so I need to paste into A2 (because A1 has titles) but to match destination formatting. I will then need to do some other stuff to it, such as deleting any row where a cell has value of zero, but can I do all that from the one and same macro? And, if I can, how exactly do I do that?
Hoping someone may be able to help me - as said, I am very new to macros, but I've learnt a fair bit having a play around but I'm stuck on how to do this.
Bookmarks