Automating Data Copy in Excel Workbook

[Nikolova84]

Greetings,

I'm looking for a solution that can help me streamline the process of transferring newly entered data in an Excel workbook. My workbook contains comprehensive information, and with each session, I'll be introducing fresh data. My goal is to have this recently added data automatically copied into Column A of a designated sheet labeled 'COPIED DATA'.

To summarize my inquiry:

• Detect any changes or new data entries made within the workbook.
• Automatically capture this new data.
• Transfer the newly entered data to Column A of the "COPIED DATA" sheet

Thank you in advance for all your assistance!

 

[My Aswer Is This]

You said:

• Detect any changes or new data entries made within the workbook.

So does this mean any place in the worksheet?
So if the value in Range("G1") changes or Range "G578" or Range ("P500")
you want this data put in column A

 

[Nikolova84]

You said:

• Detect any changes or new data entries made within the workbook.

So does this mean any place in the worksheet?
So if the value in Range("G1") changes or Range "G578" or Range ("P500")
you want this data put in column A

Hi, yes, that is exactly what i want. To be more specific, i will enter data in the entire workbook and i want this newly entered data to be copied and pasted into the worksheet named "COPIED DATA".

 

[My Aswer Is This]

You said:
will enter data in the entire workbook and i want this newly entered data to be copied and pasted into the worksheet named "COPIED DATA".

So if you have 25 sheets of Data in your workbook.
You want all this data copied and pasted into a sheet named. Copied Data
is that what you want?

 

[Nikolova84]

You said:

• Detect any changes or new data entries made within the workbook.

So does this mean any place in the worksheet?
So if the value in Range("G1") changes or Range "G578" or Range ("P500")
you want this data put in column A

Hi, yes, that is exactly what i want. To be more specific, i will enter data in the entire workbook and i want this newly entered data to be copied and pasted into the worksheet named "COPIED DATA".

You said:
will enter data in the entire workbook and i want this newly entered data to be copied and pasted into the worksheet named "COPIED DATA".

So if you have 25 sheets of Data in your workbook.
You want all this data copied and pasted into a sheet named. Copied Data
is that what you want?

Assuming I have 25 sheets in my workbook, I would like any changes I make to cell G18 in Sheet 10 and cell D15 in Sheet 18, to be automatically copied to column A in a sheet named "COPIED DATA"

 

[Nikolova84]

Hi, yes, that is exactly what i want. To be more specific, i will enter data in the entire workbook and i want this newly entered data to be copied and pasted into the worksheet named "COPIED DATA".

Assuming I have 25 sheets in my workbook, I would like any changes I make to cell G18 in Sheet 10 and cell D15 in Sheet 18, to be automatically copied to column A in a sheet named "COPIED DATA"

That is just an example.

 

[My Aswer Is This]

That is just an example.

OK thanks. But I do not see how all the Data in let's say 25 sheets can be copied into one sheet.
But maybe someone else here on the forum will have an answer.