Automatically copy data to same position in another sheet

**nonor** · 08-28-2019, 06:36 AM

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.

**PaulM100** · 08-28-2019, 06:53 AM

You could just equal the cells if the data gets replaced every single time. No need to bother with VBA. Eg: in Sheet2 A3: ='Sheet1'!A3

Automatically copy data to same position in another sheet

LinkBack

Thread Tools

Rate This Thread

Display

Automatically copy data to same position in another sheet

Re: Automatically copy data to same position in another sheet

Thread Information

Users Browsing this Thread

Similar Threads

Automatically copy row of data from Master Sheet to other sheet based on column criteria

[SOLVED] automatically copy data from different sheets and sequentially copy to another sheet

Copy data from a sheet to another automatically

[SOLVED] Automatically copy a row of data from one sheet to another

[SOLVED] How to Automatically Copy New Data into the next sheet and have it automatically sorted??

copy data from vertical position to horiziontal position

Automatically have data copy from a sheet onto another sheet according to certain criteria

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions