Hi,
It has literally been over 10 years since I actively worked VBA, so I apologize in advance for my ignorance as I try to re-educate myself. Also, let me preface this by saying I don't expect to be handed full code (unless you want, haha), but I am asking for the kindness of any advice and efficient search code based on the multiple validations needed.
Issue: I have a pivot with these headers, and the example below includes four lines of sample data (There is a lot of info on the pivot - about 40k lines and the FID is the only unique identifier... but only after the original data is pivoted):
WS = PIVOT
Column A / Column B / Column C / Column D / Column E
Fid / Obj / 860100 / 861200 / 860300
026001 / 4000 / 0.00 / 0.00 / $500.00
/ 1804 / 0.00 / 0.00 / $1,700.00
621001 / 4000 / $3,500.00 / 0.00 / 0.00
1004 / 0.00 / 0.00 / $2000.00
I have additional WS named after each possible FID column above formatted like this:
WS = 26001
Obj / Amt / BE
4000 / _______ / 860300
1804 / _______ / 860300
4000 / _______ / 860888
WS = 621001
Obj / Amt / BE
4000 / _______ / 860100
1004 / _______ / 860300
1004 / _______ / 867550
I would like, based on the FID in the pivot, activate the corresponding tab named after it, and copy/paste the appropriate amount based on the correlation to the Obj and BE. So WS end up looking like this:
WS = 26001
Obj / Amt / BE
4000 / $500.00 / 860300
1804 / $1700.00 / 860300
4000 / _______ / 860888
WS = 621001
Obj / Amt / BE
4000 / $3500.00 / 860100
1004 / $2000.00 / 860300
1004 / _______ / 867550
Lastly, if the pivot contains Obj that are not on the FID tabs, I would like to generate an exception report including FID, BE, Obj, Amt.
Important piece of info... FID is the parent, BE is the child, and Obj is a unique code number (once pivoted) within each BE.
Does this even sound reasonable? I realize this is multiple validation and its been so long I just don't know where to start. ANY advice would be very much appreciated. I can do this in 2007 or 2016.
Thank you.
Bookmarks