Propogating/Sorting data between Worksheets
 

I'm trying to help someone out and I think I'm very close but I'm just having
trouble figuring it out.

-User has a spreadsheet with 12 worksheets (one for every month).
-Each worksheet has the vendor list in column A. The next 12 columns are for
6 branches for 2009 and 2010 expenditures for each vendor. Then there are 2
columns for totals for each year.

What the user wants, is to be able to enter a new vendor in the first
worksheet (January) and have the vendor name propogate to all the other
worksheets (Feb to Dec).
She then wants to be able to sort the January data (vendors and
expenditures) so the vendors are in alphbetical order.
This vendor sort must then replicate to the other worksheets.

I've been able to copy and paste links (using paste special, paste link) so
that the new vendor, when added to January, does propogate to the other
worksheets. When I sort the January worksheet including vendors and
expenditure data, the data in, say February, get's all messed up. The vendor
list in February sorts as expected, but the data stays where it was initially
input. It does not move with the vendors.

What do I need to do to get the data in the other worksheets to move with
the new sorted vendor list? Or am I setting this whole think up wrong from
the start?

I'm begining to think I might need to use either hyperlinks or some
@functions but I've not done those before.

Any help would be much appreciated.

Excel 2003 SP3
Windows XP

Propogating/Sorting data between Worksheets
 

Try this sequence, will it work for your client?

Select all 12 worksheet tabs, add the vendor to the january sheet. Now sort
on the column, then deselect the group of worksheets by clciking on any one
worksheet tab.

HTH

"Original_Shifty" wrote:

I'm trying to help someone out and I think I'm very close but I'm just having
trouble figuring it out.

-User has a spreadsheet with 12 worksheets (one for every month).
-Each worksheet has the vendor list in column A. The next 12 columns are for
6 branches for 2009 and 2010 expenditures for each vendor. Then there are 2
columns for totals for each year.

What the user wants, is to be able to enter a new vendor in the first
worksheet (January) and have the vendor name propogate to all the other
worksheets (Feb to Dec).
She then wants to be able to sort the January data (vendors and
expenditures) so the vendors are in alphbetical order.
This vendor sort must then replicate to the other worksheets.

I've been able to copy and paste links (using paste special, paste link) so
that the new vendor, when added to January, does propogate to the other
worksheets. When I sort the January worksheet including vendors and
expenditure data, the data in, say February, get's all messed up. The vendor
list in February sorts as expected, but the data stays where it was initially
input. It does not move with the vendors.

What do I need to do to get the data in the other worksheets to move with
the new sorted vendor list? Or am I setting this whole think up wrong from
the start?

I'm begining to think I might need to use either hyperlinks or some
@functions but I've not done those before.

Any help would be much appreciated.

Excel 2003 SP3
Windows XP

Propogating/Sorting data between Worksheets
 

Thanks for the reply JR.

The Sort option is greyed out while all worsheets are selected. I'll try
messing around with different scenarios but if there are more ideas, I'd love
to hear them.

Thanks,

"JR Hester" wrote:

Try this sequence, will it work for your client?

Select all 12 worksheet tabs, add the vendor to the january sheet. Now sort
on the column, then deselect the group of worksheets by clciking on any one
worksheet tab.

HTH

"Original_Shifty" wrote:

I'm trying to help someone out and I think I'm very close but I'm just having
trouble figuring it out.

-User has a spreadsheet with 12 worksheets (one for every month).
-Each worksheet has the vendor list in column A. The next 12 columns are for
6 branches for 2009 and 2010 expenditures for each vendor. Then there are 2
columns for totals for each year.

What the user wants, is to be able to enter a new vendor in the first
worksheet (January) and have the vendor name propogate to all the other
worksheets (Feb to Dec).
She then wants to be able to sort the January data (vendors and
expenditures) so the vendors are in alphbetical order.
This vendor sort must then replicate to the other worksheets.

I've been able to copy and paste links (using paste special, paste link) so
that the new vendor, when added to January, does propogate to the other
worksheets. When I sort the January worksheet including vendors and
expenditure data, the data in, say February, get's all messed up. The vendor
list in February sorts as expected, but the data stays where it was initially
input. It does not move with the vendors.

What do I need to do to get the data in the other worksheets to move with
the new sorted vendor list? Or am I setting this whole think up wrong from
the start?

I'm begining to think I might need to use either hyperlinks or some
@functions but I've not done those before.

Any help would be much appreciated.

Excel 2003 SP3
Windows XP