Hi All,
I have a workbook with a worksheet for each day. Each of them has table with the exact same header. Now I'm trying to combine all individual worksheets to one worksheet showing each row of each worksheet. In addition if it would be possible to add the date in the combined worksheet would be awesome
Maybe I'm not wording it right but I researched this forum and the internet but I can't find any help.
Thanks already,
Martin
It looks like you want to have a template, rather than saying that you already have data that you want to combine.
Why do you want to keep this data in a different sheet for each day to start with? I would just use a single sheet and add a column for date. Keeping multiple identical sheets based on time presents design problems and make analysis difficult.
Sorry for the late reply,I thought there was a simple way to combine. Thanks to the forum the workbook is perfectly setup they way I need and I kinda don't want to mess around with it. All I actually need is to search for a restaurant name and if its matching than show each completed time in a row.
For example is search for "Forum Dine In" in restaurants and I have total 4 entries found in all taps
Forum Dine In 12:12pm
Forum Dine In 2:35pm
Forum Dine In 9:20pm
Forum Dine In 10:15am
I Don't know how to lookup to multiple taps so I thought I combine them all to make it easier. Also tried multiple sheet pivot table but couldn't figure it out either.
Thanks,
Martin
I would do this with macros. It might be possible with formulas, but I haven't found a way.
As each sheet has a table on it you can just loop each sheet in the workbook (excluding your summary sheet) and move the databodyrange of each table over.
I tend to do this by dumping the databodyrange into an array and then dumping that array under the last row of the summary table (to append to it).
See attached, should help with the concept.
EDIT: O also, in combining these tables, do we have to consider that all the tables together may surpass 1 million rows (the limit of the 2007+ file types)?
Last edited by Zer0Cool; 02-05-2018 at 01:34 PM.
Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.
"I am here to help, not do it for people" -Me
Hi ZerOCool, thanks for the template. I was trying to figure it out but can't really.
In this case I would need to integrate the create button in each of my sheets and set the 'Range Destination (top left anchor) Public Const strDestRange As String = "H1" to a different destination. I simply tried to change the "H1" do a different sheet and already failed. (Worksheets("Sheet1").range("A1").
Could you please help me with a template where 2 sheets have the button and one destination sheet? That would help me a lot to figure it out.
Thanks,
Martin
Id be happy to help but need your help to do so. Please post a sample file that contains the structure and dummy data on a couple sheets. Do not worry about a destination sheet ill create it. I just need to know what your tables look like and have some data in it for testing.
Also lets talk about how you perceive using this. Is this as simple as just take x sheets and combine them, then your done or are you looking to do something more advanced?
You mention buttons at the top of each sheet, why? Do you want to click the button on a given sheet to move the data over to the consolidated sheet? If so, does the data stay once moved or do we clear it out (leaving the headers)?
Re: Merging Multiple Sheets/ Tables to 1 Sheet
something like that?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks