How do you do this on Microsoft Excel (a formula to transfer information to other worksheets)?

Question

Hi,
I was wondering if anyone remembered doing this in Excel:
Having a spreadsheet open where in the first column you are inputing data like BW, HL, etc...and you have other worksheets for each separate data like one for BW, one for HL... So the main one has all the information, but then you want to split the data up into seperate worksheets. I don't know if I'm making any sense but I remember learning about this but totally forgot how to do it. Help!

Answer 1

Sounds like you want a VLOOKUP setup
This has some good info:
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=446
If you need something more detailed and more specific go to mrexcel.com
The nesting of data is useful on Spreadsheets, but some tasks are very office versio specific

Answer 2

okay...what i think you are asking is how to transfer data from one square to another.

you can use the formula with no paranthesis (=a1) or what ever square your using, BUT only if you are doing on the same sheet.

If you are using a new sheet, same workbook...the for instance, you want to transfer info from page 1 to page 2....start on page 2 in the square you want the info in, hit "="
then jump back over to your page one and hit the square of the info you want transfered, then hit enter

Answer 3

Use copy - paste special - paste link.