Forum Discussion
Auto move row to different sheet after entering completion date
Hello! I am very new to excel and can’t really do much beyond the basics and having trouble figuring this out. I have a table full of tasks for my team in a sheet named ‘current’ and column d is fo...
If you have multiple sheets with data having same header names and are in the same cell range then you can group the sheets by holding the SHIFT key and click the last sheet . Make sure all these sheets should be in sequently arranged.
Now when you enter data in your first sheet, the values/ any editings all get updated in each sheet in one go.
Hope this helps.
Now when you enter data in your first sheet, the values/ any editings all get updated in each sheet in one go.
Hope this helps.