hello
I have two files REPORT1, INV1 and the result in file REPORT in sheets(stock,data,report) sheets stock should brings all of data from file INV1
and sheet data should bring specific data for headers( GOODS,TYPE ,PR) and the last column contain values but the last column every time changes in location and the sheet report should create all of data based on sheets (stock, report)
note : I would create all of data in all of sheets in file Report automatically when open file without open rest of files or press button
by the way all my files in the same folder
for more explanation i put some comments for each sheet
Bookmarks