What is the best way to add sheets together - (I have a master sheet I created has my graphs and dashboard, I then distributed just the sheet to a number of people to get results ) now I have 10 sheets all identical other than the location in the sheets). How do I add these to my master without messing up my dashboard or charts ? I did try merge/combine didnt go well'.
Hi Mike,
Sorry for the slow reply. We had a power cut due to a severe storm!
It's not clear if your original dashboard source data was the result of a query that you closed and loaded to a table, or just a standard Excel Table. If the original source was a query and the new sheets have the same column names then you can just append them to the original query. If the original query didn't have a column for the location, then you'd need to add that so that it's consistent with the new sheets.
I'm also not sure if these other sheets are in individual files or one file/same file as the dashboard. i.e. are you getting files from a folder or are you getting data from tables in the current workbook.
Perhaps a bit more information will help me guide you.
Mynda
Hi Sorry, to explain - the master sheet is a table format from query, with dashboards. It has country, site within the sheet also. I plan to only send a copy of the sheet, not the dashboard. As the sheet has all the details each site needs to go through. On completion they send it back and hopefully I can just append to my master, given each sheet will have a country, site etc. In summary its exactly the same sheet, with specific country and site.
Based on this I assume I should be able to append ?
Yes, you should be able to get those new sheets and then append them to the original query.
