Data/merge?

[BrandZ1]

I have one document that has 10-12 sheets, each sheet contains data that I need to pull to a "master" sheet and cannot figure out how to do it. I would like it set up to do it automatically when I enter the raw data. This is mostly text or combinations of numbers and text and none of it is math related.


ex. Sheet 1 (named awards) has sku's and pricing, sheet 2-9 same thing sheet 4 has URL's I need on the master.

Can anyone help?

 

[DavidCoop]

Need more information BrandZ1!

What you are asking for is very easy in Excel.

It could be as easy as typing = in a cell on the Master Sheet, then clicking on the cell in the target, and the value comes across.

You can also use LOOKUP functions to find your data, based on what you enter on the master sheet.

So give us some examples, and we can tell you how to do it.

Regards,

David

 

[BrandZ1]

hi David, so the "=" function works fine, however I am pulling data from more then one sheet and I cannot seem to figure out how to get it to continue on in the document without having to re-do the function. Also, I would like it so I could continuously add/remove and the other sheets would update.