Advice on bringing data together please

**Couchy** · 03-14-2012, 04:51 AM

Alright,

I've been given a task of re-doing a forecast, it's currently set up by customer work sheets, each customer will have a part number, material, customer, weight, price and so on, but all the information is pulled from different spreadsheets, which is a bit messy. I want to create a spreadsheet that contains all of the parts by number and have all the information used by the business, but then just pull the bits i need from this new master workbook, so updates on materials and prices will be done in the one and fed to the other.

How should i go about this?

Thanks

**veejar** · 03-14-2012, 05:24 AM

Hi,

My advice is that first you need to condense the data in different sheets into one
So create a master sheet which will have common logic applicable for all sheets

In case I am too confusing please upload a sample workbook then I can help you out

**Couchy** · 03-14-2012, 05:46 AM

What example do you need to see, I'm a little confused what you actually want me to upload? The workbook with all the parts, the forecast, or the other work books where the updates come from?

Thanks

PARTNUMBERTEST.xlsx

**Couchy** · 03-14-2012, 06:31 AM

Originally Posted by veejar

Hi,

My advice is that first you need to condense the data in different sheets into one
So create a master sheet which will have common logic applicable for all sheets

In case I am too confusing please upload a sample workbook then I can help you out

I think this is what you meant