Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Gods of VB, I call on thy.
Such theatrics,
Spread sheet with 5 tabs. The five tabs a equal to 5 employees. All the tabs will be setup the same. Two list; 1st list) Shows invoice to be applied, 2nd list) Shows what has been applied that are on-account. Each list changes daily, what I would like to do is the following: Have two input tabs, 1) has the invoice data, 2) has the on-account data, both have lists contains the person name. The name may appear several times but the data will change daily. The list of names is based off the following formula: =INDEX('Cash App Schedule'!$B$2:$Q$21,MATCH(B2,'Cash App Schedule'!$A$2:$A$21,0),MATCH(D2,'Cash App Schedule'!$B$1:$Q$1,0)) I would like to populate two list on the tab with the invoice data and on-account data. I tried using Vlookup, but it was limited. It worked for the first tab, first name, but the 2nd tab, 2nd name, it did not work properly. I had to start at the end of the first name and as you can understand, the lists change daily and will not have the same amount of entrees. This is what I do now, for a list with this information, I filter the name and cut and paste them in to the tab. Im not able to use a Pivot table as I know the employees will not know how to use it. Thanks in advance, a loyal follower |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Max or Ron can answer this they are Gods! | Excel Worksheet Functions | |||
I'm not sure what you'd call it, but is it possible to do this? | Excel Discussion (Misc queries) | |||
Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
DLL Call | Excel Programming | |||
call sub | Excel Programming |