LinkBack URL
About LinkBacks
Hallo All
I am hoping that someone can help me... I have a spreadsheet report that I run each month to give monthly figures for costs/savings etc but I have been told I now need to include YTD totals both overall and by month in the charts that run off it
So far I have a macro that will copy and paste data to give total figures for YTD, but I also need to get the figures into a place for a running total for each month
What I am looking to do is to copy and paste special values only from each sheet in my workbook to the next relevant empty cell in a YTD tab
So in the YTD I want to copy cells N53, Z53, Y53, AA53 and AB53 from each tab to the relevant table - I have 16 tabs that need to feed into the YTD
I have attached a mockup - I have changed the actual headings in each small table are in the YTD tab to show which cells need to pasted where and have dummy data in the Europe tab (I haven't included the other 15 tabs to reduce size!)
Could anyone help me with a chunk of code that would copy, look for the next empty cell in row B (etc) and paste-special-values. I have had a search round and found some code that mightbe ok, but am unsure of how to use it propery (still a bit new to VBA) and also because the tables run from A1:F16, I1:N16 I am not at all sure how to cope with this as if the data from Europe for example looks for column B, how do I get UK to look in column B but further down?
Or would it make life simpler for me to put all 16 countries along one set of rows? As this is not a tab I will update the look (and annoyance of scrolling alot) is not relevant in this case as I am hoping to auot populate it and it is only 'looked at' by the charts not a person!
Hope I have explained this all ok!
Many thanks in advance
Rae
Register To Reply
Bookmarks