mrsamjones28
New Member
- Joined
- Jun 12, 2019
- Messages
- 5
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!
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!