Auto copying between worksheets (2000)

Topic

New Reply

I have a user who wants to be able to have text added to one worksheet, appear on another worksheet, based on information in one field. Example — the main sheet would hold all information. Each record would be have a column that would contain, north, south, east or west. She would like to have all the “East” information automatically copy to a separate worksheet in the same workbook that would contain only “East” info. Another option would be to enter the information on the separate sheet and have it appear on the mastersheet? Is this possible? There are no caculations, just text that will be updated often. Thanks for any suggestions.

Reply | Quote

Replies

I am not keen on keeping 2 copies of identical data. Keeping both sets updated is a pain. What about just haveing a master list and then using AUTOFILTER to work with the data. An item (EWNS column) could be filtered on and the filtered data printed, viewed, whatever. You could even include SUBTOTALs to get “stats” of the visible data.

Also you could get summaries easily just using a pivot table.

Steve

Reply | Quote

I’m with you on the not keeping 2 copies of data. I suggested using the filters, but she didn’t like that option. I don’t know how to use pivot tables. Can you recomend a good resource for learning how they work? Thanks for your prompt response.

Reply | Quote

Here are some links from Jon Peltier sites on Pivot tables.

Steve

Reply | Quote

Here are some links from Jon Peltier sites on Pivot tables.

Steve

Reply | Quote

I’m with you on the not keeping 2 copies of data. I suggested using the filters, but she didn’t like that option. I don’t know how to use pivot tables. Can you recomend a good resource for learning how they work? Thanks for your prompt response.

Reply | Quote

I am not keen on keeping 2 copies of identical data. Keeping both sets updated is a pain. What about just haveing a master list and then using AUTOFILTER to work with the data. An item (EWNS column) could be filtered on and the filtered data printed, viewed, whatever. You could even include SUBTOTALs to get “stats” of the visible data.

Also you could get summaries easily just using a pivot table.

Steve

Reply | Quote

Thanks–I’ll check it out.

Reply | Quote

Thanks–I’ll check it out.

Reply | Quote