Pulling out repeated data in huge spreadsheet
If the desired information for each entry is all on a single row, simply
select the entire sheet, do Data, Sort. That way you can put the rows in
one contiguous section, then Select Copy Paste.
cklevine wrote:
There are over two K of these entries- I'd be doing until Christmas
CK
"Bob I" wrote:
Any reason you can't select, copy and paste?
cklevine wrote:
Hi, I have a huge spread sheet with the deposits and I need to pull them out
and copy them into another sheet to add them up. the text "payment received"
then the amount, is there anyway I select all of these entries (a years
worth) and copy them into another worksheet? I'm using Office 2003-
thanks a lot
cklevine
|