I have a workbook with 3 worksheets. Sheet1 has 50 columns and multiple rows. Sheet2 & 3 are blank. I want the data in columns A, D, G & H to relect on sheet2. I also want data in columns B, C, E & F to reflect in sheet3. The goal is to have all data in sheet1 and any changes or additional rows added to sheet1 will automatically be added to sheet2 or sheet3. Is there a simple way to do this?![]()
Bookmarks