Transferring From Sheet 1 to Sheet 2 and Sorting

[mrsamjones28]

I am really new to Excel, as in no formal training or classes just Google and my brain

I need help taking data from sheet 1 and transferring it into sheet 2. I also need sheet 2 to change automatically when I update sheet 1.

Once I do this, I then need to be able to sort the dates on sheet 2 without it affecting sheet 1. The problem is that I have tried doing a special paste and using the link but then I can't sort because excel doesn't know that the data carried over is a date. It just see the linked text so I have no option to sort by date just by text.

I am not well versed in VBA but am willing to try if someone can walk me through it. Thanks!

 

[mrsamjones28]

Anyone able to help, please!

 

[sandy666]

what is your excel version?
are you able to use PowerQuery (Get&Transform)?
how dates will be sorted?

 

[mrsamjones28]

what is your excel version?
are you able to use PowerQuery (Get&Transform)?
how dates will be sorted?

I actually figured out how to do the transferring in VBA. I am having trouble now filtering the data and sorting it. I used the following in VBA:

Sub Copy()
Sheets("Data Entry").Range("A5:A654").Copy Sheets("Try1").Range("A5")
Sheets("Data Entry").Range("A5:A654").Copy Sheets("Try1").Range("D5")
Sheets("Data Entry").Range("A5:A654").Copy Sheets("Try1").Range("G5")
Sheets("Data Entry").Range("A5:A654").Copy Sheets("Try1").Range("J5")
Sheets("Data Entry").Range("A5:A654").Copy Sheets("Try1").Range("M5")
Worksheets("Try1").Range("B5:b654").Value = Worksheets("Data Entry").Range("F5:F654").Value
Worksheets("Try1").Range("E5:E654").Value = Worksheets("Data Entry").Range("G5:G654").Value
Worksheets("Try1").Range("H5:H654").Value = Worksheets("Data Entry").Range("H5:H654").Value
Worksheets("Try1").Range("K5:K654").Value = Worksheets("Data Entry").Range("I5:I654").Value
Worksheets("Try1").Range("N5:N654").Value = Worksheets("Data Entry").Range("J5:J654").Value

End Sub

When I try to go to the Try1 data and sort it, doing sorting on one column affects all the columns. I am not sure why.

 

[sandy666]

I don't like vba so.. good luck