Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi everyone,
I am building a spreadsheet for a friend that will contain date of sale, First name, Last name, address, original $ amount, % of that $ amount, How many days financed, and balance due. This spreadsheet consist of 31 sheets representing each day of the month and a final sheet that takes the total from the previous 31 sheets. I need to create a sheet that will take each individual name with a balance from the previous 31 sheets and pull all the information from that row on the specific sheet on a Balance owed sheet. I have to do this for every month in the year. I have tried v lookup but that defeats the purpose of going thru each individual item seeing if there is a balance. I need something that will look it up and pull all the information from the line item. I need this to look through 12 different workbooks. Some Please HELP!!!! -- Thanks in advance for the help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Working spreadsheet highlighting function for Excel 2007 | Excel Worksheet Functions | |||
Cannot save excel files to a folder on a network | Excel Discussion (Misc queries) | |||
Excel Spreadsheet Not Saved Dialog Error | Excel Discussion (Misc queries) | |||
Can Excel 97 read Excel 2003 simple spreadsheet? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |