hello
i need help to get code to transfer data from dynamic range to specific ranges i have data from a2 : e when i search in range i2 based on column b then get data to range from g5: j5 (note: it supposes when transfer data should sum column d,a into h5,i5 ) actually i get formula bu it doesn't work well
=SUMIF(B2:B1000;I2;INDEX(D2:D1000;;MATCH(G5;C2:E2;0))) so i ask code because quick and less
F1 = balance
f2 =D2-E2 and drag down
After that a pivot table.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
thanks oeldere for your assistance i know about pivot table but i prefer by code if is not possible by formula is ok
H9 =VLookup(J2,$B$2:$C$7,2,0)
I9 =SUMIF($C$2:$C$7,$H9,D2:D7)
J9 =SUMIF($C$2:$C$7,$H9,E2:E7)
K9 = I9-J9
excuse me your ranges not as what in my file i hope apply my file i don't understand how works
See the attached file.
i recommend my apology about respond delaying , your formula works perfectly thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks