Forum Discussion
Update data when new data is entered in a rage of cells
Is there a way to update data on a different sheet (like a dashboard) only when new data is entered in a different sheet - and only display the new data. For example in sheet 2 I have a row of names...
rwagner34 so in the VBA editor you need to open the code page for the specific Sheet. And then in that window select Worksheet from the left drop down and the right will likely auto populate with SelectionChange but otherwise select that:
If you pasted that Sub into workbook or a module or something, yeah it won't understand.
Thank you! I got it to work!