find name and copy amounts between 2 workbooks

hi,

Starting at A4 of “weeks to month” workbook are a list of names
Find name in column J of “source month” workbook in all of the sheets

If a name is found in a sheet, from the name:

Go to (5 down, 6 left),copy the value, after searching the sheets, put the total amount(amounts from the sheets) to column B of “weeks to month” workbook

Go to (6 down, 6 left), copy the value (negative numbers convert to positive numbers), after searching the sheets, put the total amount(amounts from the sheets) to column E of “weeks to month” workbook

Go to (7 down, 6 left), copy the value, after searching the sheets, put the total amount(amounts from the sheets) to column C of “weeks to month” workbook

Go to (8 down, 6 left) to (10 down, 6 left), copy the values, after searching the sheets, put the total amount(amounts from the sheets) to column D of “weeks to month” workbook

Go to (5 down, 2 left),copy the value, after searching the sheets, put the total amount(amounts from the sheets) to column H of “weeks to month” workbook

Go to (6 down, 2 left),copy the value, after searching the sheets, put the total amount(amounts from the sheets) to column M of “weeks to month” workbook

Go to (7 down, 2 left),copy the value, after searching the sheets, put the total amount(amounts from the sheets) to column K of “weeks to month” workbook

Go to (8 down, 2 left),copy the value, after searching the sheets, put the total amount(amounts from the sheets) to column N of “weeks to month” workbook

Go to (9 down, 2 left),copy the value, after searching the sheets, put the total amount(amounts from the sheets) to column O of “weeks to month” workbook

Go to (10 down, 2 left),copy the value, after searching the sheets, put the total amount(amounts from the sheets) to column P of “weeks to month” workbook

Go to (12 down, 4 left) to (16 down, 4 left)
also Go to (12 down, 8 left) to (16 down, 8 left)
for every cell check value if “CA”
if value is "CA" store the amount (if negative numbers convert to positive numbers) from the "CA" value located 2 cells to the right to (values of CA)
if value is not "CA" store the amount (if negative numbers convert to positive numbers) from the not "CA" value located 2 cells to the right to (values of not CA)
after checking the sheets put the total of (values of CA) to column Q of “weeks to month” workbook
and put the total of (values of not CA) to column R of “weeks to month” workbook

attached workbooks and ive shown the desired result for the firs name "NAME1"

below is the inital code i made
hope someone can check if its correct im confused with using FOR and WITH

Please Login or Register  to view this content.

hi,

thanks for the code

i tried to add a code to copy the total amount for CA and NOTdCA but cant get the correct amount for each

Please Login or Register  to view this content.

works great thanks!

last question how do i modify the code if i want it to retrieve per sheet instead of combination of the 4 sheets

ill just add "1st week", "2nd week", "3rd week", "4th week" next to "Sheet1" of "WEEKS TO MONTH" workbook