Link to home
Start Free TrialLog in
Avatar of Rayne
RayneFlag 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
Avatar of Rayne
Flag of United States of America image


Would love formulas in the VBA, since I am dealing with 20000 to 40000 rows and the fastest way preffered.
Avatar of Eoin Ryan
Eoin Ryan
Flag of Ireland image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Rayne


Hello EoDawg,

Nice!!, I had to take some time to understand the logic of your solution. Thank you. Will ask more question if any..