Hello so here is problem
I have a masterworkbook(marcgoproject4.xlsm) it has five(5) sheets all has headers
sheets name :
sheet1=ADDITEM
sheet2=ITEMLIST
sheet3=RECEIVED
sheet4=SHIPPED
sheet5=STOCK
now the problem is i also have a babyworkbook(in.xlsx) that gets updated regularly only has one(1), sheet1 it also has a header
so the problem is i want to automatically update the master workbook sheet3("received") when ever i update or do something with my babyworkbook.
or for example i changed something in my babyworkbook then saved it. then when i open my masterworkbook i have a button that i can click so my (received)sheet will be updated.
PLEASE HELP.
BEST REGARDS (Y)
-MarcGo
I have a masterworkbook(marcgoproject4.xlsm) it has five(5) sheets all has headers
sheets name :
sheet1=ADDITEM
sheet2=ITEMLIST
sheet3=RECEIVED
sheet4=SHIPPED
sheet5=STOCK
now the problem is i also have a babyworkbook(in.xlsx) that gets updated regularly only has one(1), sheet1 it also has a header
so the problem is i want to automatically update the master workbook sheet3("received") when ever i update or do something with my babyworkbook.
or for example i changed something in my babyworkbook then saved it. then when i open my masterworkbook i have a button that i can click so my (received)sheet will be updated.
PLEASE HELP.
BEST REGARDS (Y)
-MarcGo