Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatic Find and Populate
Ok, I have several spreadsheets that represent bills and have tabs that represent the months. So, when I recieve a new bill for the month, I copy last month's bill onto a new tab, and rename it using the billing cycle. Each year, for each account number is contained in its own workbook- ie: account 245-9999 has a workbook for 2002, 2003, 2004, and 2005; within that workbook are tabs for Jan, Feb, Mar, etc. Ok, on a single month's tab, there are anywhere from 10 to 900 individual line items representing circuits. What I want to do is create a separate spreadsheet that lists unique circuit ID's from all of the bills- it would show me ALL circuits ID's accross ALL the accounts. So, I want the spreadsheet (or function, macro, whatever) to go out to the folder for a given year, find all circuit id's from all the accounts from all months and filter out duplicates- then list these ID's together (possibly with the Billing Account number they came from). Anyone have an idea as to how this might be done? I am not familiar with visual basic, but I do work with someone who is or could muddle through it myself- and I am using XP. Thanks. -- Mark Brindamour mtbrindamour[AT]hotmail[dot]com Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200507/1 |
#2
|
|||
|
|||
Nevermind, I found I could name the data I wanted to search through and use
the vlookup function. Mark B wrote: Ok, I have several spreadsheets that represent bills and have tabs that represent the months. So, when I recieve a new bill for the month, I copy last month's bill onto a new tab, and rename it using the billing cycle. Each year, for each account number is contained in its own workbook- ie: account 245-9999 has a workbook for 2002, 2003, 2004, and 2005; within that workbook are tabs for Jan, Feb, Mar, etc. Ok, on a single month's tab, there are anywhere from 10 to 900 individual line items representing circuits. What I want to do is create a separate spreadsheet that lists unique circuit ID's from all of the bills- it would show me ALL circuits ID's accross ALL the accounts. So, I want the spreadsheet (or function, macro, whatever) to go out to the folder for a given year, find all circuit id's from all the accounts from all months and filter out duplicates- then list these ID's together (possibly with the Billing Account number they came from). Anyone have an idea as to how this might be done? I am not familiar with visual basic, but I do work with someone who is or could muddle through it myself- and I am using XP. Thanks. -- Mark Brindamour mtbrindamour[AT]hotmail[dot]com Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OsCommerce - Easy Populate Script - CSV/TXT Conversion Problem. | Excel Discussion (Misc queries) | |||
How do I import external data populate rows instead of columns. | Excel Discussion (Misc queries) | |||
Need Help With A Find Formula | Excel Worksheet Functions | |||
how do populate empty cells with the contents of populated cells . | Excel Discussion (Misc queries) | |||
Find and replace error | Excel Worksheet Functions |