Avatar of Rayne
Rayne
Flag for United States of America asked on

Magic VBA Needed

Hello All,


There are two items listed in a table. Once happens to be the new name of the other :(
In repalcelsit – you see the oldname is item11, and the new name for that, is item22
In mytABLE sheet you see there is a table with prod column that listed the items, a month stamp of each items, a dollar number (AMT) and an adjustedAMT.
Each item will always have 12 rows to correspond to 12 month data.
 Requirement: Calculate the adjustedAMT for newName of items.
Item22 is the new name of the item11. So each row of item22 be will :=
whatever it was before for a specific month  + item11 numbers of the same month
For example:
For month P12, the adjustedAMT for item22 will be  99+1 = 100
For month P1 [AdjustedAMT] for item22 = 0 +45  = 45
lifeSaverQuestion.xlsx
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Rayne

8/22/2022 - Mon
Rayne

ASKER
Would love formulas in the VBA, since I am dealing with 20000 to 40000 rows and the fastest way preffered.
ASKER CERTIFIED SOLUTION
Eoin Ryan

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Rayne

ASKER
Hello EoDawg,

Nice!!, I had to take some time to understand the logic of your solution. Thank you. Will ask more question if any..
Your help has saved me hundreds of hours of internet surfing.
fblack61