Transferring Data Automatically in same Worksheet EXCEL

Solved/Closed
Report
Posts
2
Registration date
Tuesday June 23, 2015
Status
Member
Last seen
June 24, 2015
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
Hello,

I'm finding a difficulty in transferring data from a number of cells to a table automatically. What I'm trying to accomplish here is that when a number of cells are filled with data the same data that is being inputted is being also filled in another cell, (using the substitute function).

Where I'm finding a difficulty is when erasing the original data from the original table. What I want is that when I remove the original data, the data that has been copied automatically in the other cell's table is transferred and saved automatically in the row below.

How can I attach this document for your reference? Thanks guys!

1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Mark,

You can "attach" your document by going to a free file sharing site like www.speedyshare.com or ge.tt, upload your file and then post back the download link. Always be careful with sensitive information.

Do make sure it's clear where the original data is located as well as the destination.

Best regards,
Trowa