ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Merging multiple WS with diff values into one master (https://www.excelbanter.com/excel-discussion-misc-queries/86434-merging-multiple-ws-diff-values-into-one-master.html)

Chris

Merging multiple WS with diff values into one master
 
I am trying to merge data from 3 different worksheets into one master sheet
For example:

WS #1- Store A, address, city. 20 oz sales January, 20 oz sales Feb.,etc.
WS-#2- StoreA, address, city, 24 oz sales January, 24 oz sales Feb., etc
WS#3- Store A, address, city 32 oz sales January, 32 oz sales Feb, etc.

The goal I have in mind is a worksheet that says:

Row 1- Store A, address, city,20 oz sales January, 20 oz sales Feb.,etc. 24
oz sales January, 24 oz sales Feb., etc,32 oz sales January, 32 oz sales
Feb, etc.

I would then repeat this same for all additional stores.

I may have one of two possible scenarios that I might have to work with that
I wanted to throw out there.

#1 I have been told that the data I am working with, that there will be the
same exact stores and that all I would have to do is sort the stores by
whatever factor (name or address) and proceed to merge the worksheets.

#2 If scenario 1 is incorrect and there are some stores missing, how will
this work? For example some stores may have only purchased 1 size item (ie
20 oz) but not the other sizes. Meaning on row 10 of worksheet A (20 oz
size) the store is "John's #1" but on worksheet B (24 oz size) the store on
row 10 is John's #2 because John's #1 store didn't buy any 24 oz size. How
would I then get the data from each sheet for each store to "line up" or
match on the on the same row on the master sheet?

I am sorry for the wordiness of this question but sincerely appreciate any
and all help.


All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com