Find matching values, copy/paste values as well as values in ColA

R

ryguy7272

I am trying to think of a way of searching a single sheet, similar to ctrl+f,
and basically finding all matches on the sheet. If two cells match, get the
value from ColumnA and paste it into a new sheet (with the value that was
searched for)!

For instance, I can look at my sheet and see 213.50 and -213.50. I know one
is a credit and one is a debit. The 213.50 is in H23, so I want to
copy/paste the 213.50 and the value in A23 (the name of the firm that issued
the credit), and put both a new sheet. Similarly, -213.50 is in BC 104, so I
want to I want to copy/paste the -213.50 and the value in A104 (the name of
the firm that issued the debit) and put both in the new sheet, just under the
213.50. Or, if I can somehow find all matches (credits and debits) and the
corresponding values in ColumnA, I can simply sort by ColumnB (which will
list all credits and debits).

I tried a few things, including using PivotTables; I’ve hit a wall. Any
ideas on how I may be able to do this? The numbers are spread ot all over
the place! Annoying, to say the least!!

TIA,
Ryan---
 
R

ryguy7272

Can anyone think of a solution? I am still at a loss as to how to do this.
Any help would be most appreciated.

TIA,
Ryan---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

paste values without copy-paste values 1
I'm Paste values stupid 4
Accounting Problem. Complex Copy/Paste and Index/Match too. 1
Paste values only 2
How to copy Range and Paste as Values (from hidden sheet) 2
Auto Copy Data from one worksheet to another 1
HELP: Match values from different sheets and populate a column 3
Copy/Paste values rounding problem. 1

Top