ExcelBanter - How to save only row changes to a new sheet

Personally, I find anything too automatic troublesome.

If I make a change to a row and the data gets copied to a different worksheet,
then realize that I made a mistake and change the value back, the row would get
copied over again.

I think I'd do things differently.
(This is just a suggestion. You can ignore it if you want.)

I'd put a date/time stamp in a dedicated column of the input sheet. Then I'd
apply data|Filter|autofilter.

If I needed to see the rows that changed, I could filter to show just the
changes from today (or yesterday or last week).

If I needed to copy this to a different worksheet, I'd do all my data entry,
then apply data|filter and just copy those visible rows to that other sheet (But
I wouldn't separate my data!).

If you want to try this, you may want to look at J.E. McGimpsey's routine:
http://www.mcgimpsey.com/excel/timestamp.html

And if you need code to do the copy|paste, you can record a macro when you do it
manually and then tweak that recorded code.

===
Again, I'd do my best to keep the data in one location. It'll be a pain to have
it in multiple spots.

J Sears wrote:

Hi, I'm working with a large worksheet(40 000+ rows). I would like to allow
the user to make data changes to cells and then only save those changed rows
to a new spreadsheet. I know Tracking will keep track of the changed cells,
but I want to actually copy the entire row to a new sheet.
--
Tks,
J Sears

--

Dave Peterson