Ok, here is the layout. All are grids are rows 6-20
Cash Invoices
Column A - Invoice numbers
Column B - Price
Check Invoices
Column C - Invoice number
Column D - Price
Credit Card Invoices
Column E - Invoice Number
Column F - Price
Invoice Summary
Column G - Invoice Number
Column H - Price
All columns are not sorted ie a cash invoice #1 and a check invoice #3 and a credit card invoice #2
I want column G to reference the lowest invoice number and sort ascending based on the invoice numbers in column a,c,e and keep the coinciding price attached for column H
meaning the stuff I typed in A C E will auto sort Ascending in Column G and H
1
2
3
please help me with this...
John Robinson
Bookmarks