Excel 2007 : auto copy information from one worksheet to another

Yes, by using VBA code in the change event of the source worksheet.

If the source worksheet is Sheet1 and the target is sheet2, then perhaps something along these lines:

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

    Dim sCell As String
    
    sCell = Target.Address
    
    Sheet2.Range(sCell) = Target.Value

End Sub

Note: Sheet names used are code names (not worksheet [tab] names)

This code will make the same cell on sheet2 to have the whatever is entered on the same cell in sheet.
The above code must be placed into the worksheet module of Sheet1.

• Right-Click the tab of Sheet1 > View Code
• Copy and paste the above code into the code pane (usually on the right side)
• Close the VB Editor

Is this what you wanted?

Yes, this can, likely, be done - there are a number of methods.

In order to save time and provide you with a precise answer, why not just outline all of the details upfront instead by bits and pieces?

You might upload a sample workbook (sensitive data removed/dummied) that contains a manually created example of the desired outcome, along with a clear explanation of all relevant details about the criteria.

Here is a very basic idea of what I work with.

Here are some of the things that I need:

Ultimately, i want a workbook that

1. on the first sheet, parts are logged once they come to us (basically, just a holding sheet for parts awaiting processing)

2. once a ship date has been put into the remarks column, they are removed from the first sheet and automatically put on another sheet (a master log to look back to and see everything thats been logged and shipped so far in that month)

3. each item that contains "Y" in the 2410 or TSN column is treated the same as other parts as far as once they are shipped, they are removed from the initial log list.
But once they are initially logged, they are automatically copied to another sheet just for these "2410" items as well as remaining on the initial log sheet until a date it put in the remarks column.


Once a date is put in the remarks column,
a. they are removed from the initial log
b. on the 2410 sheet, they are MOVED from the waiting section to another place, perhaps, on the same sheet that shows these 2410 parts that have been shipped and are not awaiting processing
c. they are also automatically copied to the master inventory (the third sheet where all other parts automatically go once they are shipped).

I can see that this may be confusing and I'm hoping that the workbook I have included could clear up some confusion.

Thank you