Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-populating file based on conditions
I am looking for a way to link fields from a master list of entries to a
monthly file, which will automatically populate based on specific conditions. To give a better picture below are some of the columns & rows I am using Ref No. Date of Letter Date Actioned Customer BSB Letter Purpose Amount 138 20-Nov-2007 22-Nov-2007 Bob Jones P/L 5-158 Amend 1000 I want to be able to populate the monthly file but only if the entries are from the current month and have a letter purpose of amend. As the Master List contains thousands of entries, I want it to be able to populate the monthly file with all the entries from the current month on each row seperately. I am assuming VLOOKUP is the way to go, but is there some kind of Macro/VBasic function I will need as well? Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto populating a cell based on another cell for an invoice | Excel Discussion (Misc queries) | |||
Help with auto populating cells. | Excel Worksheet Functions | |||
Auto populating date field | Excel Discussion (Misc queries) | |||
Conditions & Populating | Excel Worksheet Functions | |||
Auto populating fields | Excel Worksheet Functions |