Hi
I've looked at other threads and tried out the solutions in those, but can't find anything that works for my needs. I have a template workbook with several sheets, four of which I need to merge, or consolidate, into one summary/master sheet, however there are several other sheets that won't need to be summarised. The sheets to be summarised contain largely the same columns, expect for a couple towards the end, but may contain any number of rows, and the header detail only needs to be pulled forward once, except where the columns are different of course. The sheets contain a lot of data validation, and I am not sure if this is causing the problem. This might seem like a simple copy and paste job, but this is a template and I will eventually have over 100 workbooks to perform this in and I need to try and automate it as much as possible. I need the values pulled forward rather than the formulae, as I have found that the formulae cause problems with the conversion of US$ to GB£.
The data in the summary or master sheet will then be pulled forward into another workbook, summarising the position by sector.
I attach a sample file to show you roughly what I mean, and hope that someone can help. If you need further explanation please let me know.
Thanks in advance.
Bookmarks