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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks