I'm using =Sheet1!A1 and auto filling it down on Sheet2 in the A1 cell but Sheet2 will not auto update if I insert a new row in Sheet1. Any ideas on how to fix that? Thanks guys/gals!
I'm using =Sheet1!A1 and auto filling it down on Sheet2 in the A1 cell but Sheet2 will not auto update if I insert a new row in Sheet1. Any ideas on how to fix that? Thanks guys/gals!
I found this on here
Option Explicit
Sub Worksheet_Activate()
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select
End Sub
Sub Worksheet_Deactivate()
ActiveSheet.Select
End Sub
Instructed to insert it in the "view code" prompt when you right click on the sheet tab at the bottom.
I works, I just enter in my sheets I want to be updated at the same time the main sheet is updated into the array in the formula (to include the main sheet as well). Though I do not need my sheet2 recieving updates from sheet1 in any other column but A. Is there a way to specify in the array part of the code/formula to say only update sheet2 when column a is updated in sheet1?
Try this on sheet2 column A
Fill downPlease Login or Register to view this content.
Tom S.↙ If you find my reply helpful click on the * down there on the left. Yeah that's it, right there, down on the leftIf your question is resolved, mark it SOLVED using the thread tools.
That's what I'm talking about. Very Cool. Thanks man!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks