Please see attached. I tried to copy the formulas and they don't paste and pull the information the way it should. Please see previous post by me for what I am trying to do.
Sample Excel.xlsx
Just copy the account codes from column B of the Account Codes sheet and paste at K3. then copy the L3 formula down.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Didn't work. Plus I don't want all the codes in Column K, unless they are used in Column H. Only want totals in K to show and consolidate respective amount totals of J in L. For example, if I have three "GAS code 6503" expenses of $25.00, I want the Code of "6503" to show in K and $75.00 to show in L.Originally Posted by JBeaucaire
In sheet Account Codes, F1 = "Used".
F2: =IF(ISNUMBER(MATCH(B2&"*", 'Expense Report'!H:H, 0)), N(F1)+1, N(F1))
...and copy that cell down the table.
On sheet Expense Report, put this in K3 and copy down:
=IF(ROW(A1)>MAX('Account Codes'!F:F), "", INDEX('Account Codes'!B:B, MATCH(ROW(A1), 'Account Codes'!F:F, 0)))
Now the codes will not only appear as they are used, they will appear in numeric order, or the order of your original table on the other sheet.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks