pledge8236
New Member
- Joined
- Sep 13, 2024
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello,
Firstly, thank you for those taking the time to read my post. I have been using excel for many years however; due to a recent corruption in a Microsoft Access Database. The decision has been made to move over to Excel for the task we need it for. With that, I have now stumbled across a couple of challenges, which I am hoping to gain assistance for.
1. I am wanting to move a row of data from the Working Spread Sheet to another. For this, Column T is my collections data of the task. I want the row to then automtically move to a Completed Excel document the day after that which is shown in Column T. Sadly, I know little to nothing about Macros so am finding this very tricky.
2. I am wanting to set the order so that the old is at the top of the sheet however; has I have formulas in place, the ones that have no data entry and are showing as #### are taking themselves to the top which is not what I want. I want these ideally to be at the bottom at all times and then when data is added, the sheet up dates it self into the correct order.
If I haven't explained myself very well, then I am sorry but am happy to provide screen shots etc. if required.
Many thanks
CJ
Firstly, thank you for those taking the time to read my post. I have been using excel for many years however; due to a recent corruption in a Microsoft Access Database. The decision has been made to move over to Excel for the task we need it for. With that, I have now stumbled across a couple of challenges, which I am hoping to gain assistance for.
1. I am wanting to move a row of data from the Working Spread Sheet to another. For this, Column T is my collections data of the task. I want the row to then automtically move to a Completed Excel document the day after that which is shown in Column T. Sadly, I know little to nothing about Macros so am finding this very tricky.
2. I am wanting to set the order so that the old is at the top of the sheet however; has I have formulas in place, the ones that have no data entry and are showing as #### are taking themselves to the top which is not what I want. I want these ideally to be at the bottom at all times and then when data is added, the sheet up dates it self into the correct order.
If I haven't explained myself very well, then I am sorry but am happy to provide screen shots etc. if required.
Many thanks
CJ
