Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste data based on multiple criteria
Hi again!
On worksheet 1 I would like to paste data into K4418 to 10641, L4418:10641 and M4418:10641 by matching up client names, invoice amounts and invoice date to return the paste data. Column B5:4406 contains client names in "First Name Middle Name (if applicable) Last Name" Order Column F5:4406 contains invoice amounts Column G5:4406 contains invoice numbers Column I5:4406 contains invoice dates Column K5:4406 contains Pay to Column L5:4406 contains cheque number column M5:4406 contains description Column B4418:10641 contains client names in "Last Name, First Name Middle Name (if applicable)" Order Column F4418:10641 contains invoice amounts Column G4418:10641 contains invoice numbers Column I4418:10641 contains invoice dates Column K4418:10641 contains BLANK Pay to Column L4418:10641 contains BLANK cheque number column M5:4406 contains BLANK description Would I need to change the order of the client names first in Column B? If so how do i do this? What can function can I use after that? Thanks!! :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return multiple rows of data based on criteria | Excel Worksheet Functions | |||
Taaly all based on multiple criteria | Excel Discussion (Misc queries) | |||
sum based on multiple criteria | Excel Worksheet Functions | |||
Summary Based on Multiple Criteria | Excel Worksheet Functions | |||
Multiple Sum, based on criteria | Excel Worksheet Functions |