Question: How can i automatically copy data to same position in another sheet?
Example:
-I have sheet 1 and sheet 2.
-User fills on in names on sheet 1 in Cell A3 till A5. Excel should (automatically and without pressing a button) copy and paste those names to Sheet 2 in Cell A3 till A5.
Note: The range of cells can dynamically change (can be longer or shorter).
How would someone solve this? With a formula or VBA code?
Thanks.
Bookmarks