I'm looking to take several weekly sales sheets and consolidate them into one large master sheet, the items each week will vary in description, price and quantity. the master sheet would also have to group likewise terms together to make is simple to see how much of each item i have sold. i will attach the original document with the weekly sales sheets i wish to group and consolidate. If anyone can help thanks in advance
you can make all the sheet into a pivot table and that will consolidate for you
minor change - needs a heading in column F1
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks