Editing data on multiple worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a workbook, that contains all of the same customes and data. I want
to know if there is a way that when I edit data on the first worksheet, the
data will edit also, even though they are in different cells. Any
suggestions??
 
Don't do it.

Keep your data that you update in one worksheet. Then try to use data|sort or
data|filter|autofilter to see what you want.

But if you have to make separate worksheets (to share with customers???), you
can split the data (as a report--not for updating) into different worksheets.

You may want to look at the way Ron de Bruin and Debra Dalgleish approached it:

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Only if the cells are linked back to the first worksheet.

See help on "linking".


Gord Dibben MS Excel MVP
 
Back
Top