Automate data entry between two worksheets
I have two worksheets with identical data on them but sorted by different columns. I would like to be able to enter new data in only one of the sheets and have the second sheet populate automatically.
Example:
Sheet 1 - firstname, lastname, sticker # - order by firstname
Sheet 2 - firstname, lastname, sticker # - order by sticker #
When I fill in or delete data on Sheet 1, I would like Sheet 2 to populate or delete the data automatically.
Can you please tell me how to do this?
Thanks
Mikki.
Suggestion from bionicle
You can use the script below.
The first part of the script copies all the data from "Sheet1" and paste it in "Sheet2" then do the sorting.
Sub copy_sort()
Sheets("Sheet1").Select
Cells.Select
Selection.Copy
Sheets("Sheet2").Select
Cells.Select
ActiveSheet.Paste
Application.CutCopyMode = False
With ActiveSheet.Sort
.SortFields.Clear
'the key you want to use is the column to sort on. I used column 3(sticker)
.SortFields.Add Key:=Selection.Columns(3), Order:=xlDescending
.SetRange Selection
.Apply
End With
End Sub
Best regards,
--------------------------------------------------
Your code
Thank you very much. I'll try this out when I get back to work tomorrow.
Mikki.