Updating, Deleting and inserting rows over two Excel Sheets

  • Thread starter Thread starter mem
  • Start date Start date
M

mem

Hi

I am trying to create a a excel model that will let me Update, Insert and
Update on one excel spreadsheet, some of the information will be then
reflected in another excel sheet (same book) I can do the update by using
'=Sheet1!A1'. but if I delete this gives a #ref error and insert rows is not
reflected.

Thanks for help or suggestions.
 
I wouldn't do this. Too many things can go wrong. If I make a typo and it goes
to the wrong sheet, how do I fix the other sheet. I'd have to use some kind of
event code that does the work. If macros are not running or events are
disabled, then my data wouldn't be copied over.

But after the data has been entered (and verified), I could use a macro to
separate data into different worksheets--but always do my input onto that one
single sheet.

I'd steal some 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

or maybe Ron de Bruin's easyfilter.
http://www.rondebruin.nl/easyfilter.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Back
Top