Here is what I want to do (but am unable since I am new to Excel):

I have created a spreadsheet that shows account names and information
(IE: Fiscal Qtr) In this spreadsheet I have created four additional
workbook tabs labeled Qtr 1-4. I would need to know how to have the
original spread sheet (lets call it the master) dump certain accounts
and related info into their appropriate Qtr Tab. Can anyone Help?


--
smorton
------------------------------------------------------------------------
smorton's Profile: http://www.excelforum.com/member.php...o&userid=19758
View this thread: http://www.excelforum.com/showthread...hreadid=345944

First, you need to understand that Excel can't "dump" information from
one sheet to another. However, it *can* read information from one
location in another.

Therefore, if, for example, on your Fiscal Qtr sheet you have
information in cell C12 that you want to see in cell D20 of your Qtr 1
sheet, you would put this formula in cell D20 of Qtr 1:

='Fiscal Qtr'!C12

Follow this format for the remaining cells on your various sheets.
Then, as you enter or edit data on the master, the corresponding cells
on the designated sheet will automatically update.

HTH


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=345944

I guess if I go into the qtr's worksheets I can just use the "=" sign in
the cell and then click back on the master list sheet and click the cell
I want to link then hit enter and go back to the qtr field and use the
autofill feature. Now if I change the data on the master list it
changes it for that worksheet :)

I ended up asking one of our trainers at work :)


--
smorton
------------------------------------------------------------------------
smorton's Profile: http://www.excelforum.com/member.php...o&userid=19758
View this thread: http://www.excelforum.com/showthread...hreadid=345944

Yep, pretty much what I said. Glad you found the answer to your
question.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=345944

Thanks for the help Bruce!

You got me on the right track and even made me realize that maybe what
I want to do with this database might be better served in
Access......But thats another forum:) LOL

Seriously though....thanks.


--
smorton
------------------------------------------------------------------------
smorton's Profile: http://www.excelforum.com/member.php...o&userid=19758
View this thread: http://www.excelforum.com/showthread...hreadid=345944