My excel file is having 6 sheets.
Each contains about 300 columns and 1000 rows.
Sheet1 is data sheet where manual inputs are updated and rest 2 to 6 sheets are updated based on vlooklup & match formula linked to sheet1 all of 300 by1000 cells.
Whenever i update sheet 1, say i copy cell a2...