pivotsmoak
New Member
- Joined
- Dec 16, 2023
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
As an avid and devoted follower and subscriber to your YouTube channel, I've always admired the insights you share. Today, I'm reaching out for the first time with a challenge. I believe your expertise could help me navigate.
Your tutorials have significantly elevated my skills as an average Excel and VBA user, particularly in the realm of analyzing and crafting dashboards for my team. Your guidance has been invaluable, and I now turn to you with a specific issue. I am analyzing and creating dashboards for my team, and your videos have been instrumental in helping me build more robust, dynamic, and user-friendly dashboards.
I am writing to seek your expertise on a specific problem I’m encountering. My data model involves a file with over 10,000 rows and 28 columns, and I import this sizable data set every week for my team to review and make necessary comments and modifications. The columns/headers are constant. Given the limited number of licenses to access the data on the server, I download the data file weekly so that the team can keep current with each of the tasks.
The enclosed file is a representation of my data model with fewer columns and rows. The enclosed table tries to simulate the problem I have.
The challenge arises when new data is imported, as it tends to overwrite the existing data, excluding team comments that are located outside the table range. This results in misaligned comments when additions or removals occur in the master file. Also, not knowing if the updates from the previous week have been updated on the server.
To address this issue, I am seeking a method that accomplishes the following:
Preserves user comments and aligns them with the correct line item when new data is imported.
Highlights any modifications made by users to the previous file in any of the data fields that have not been updated on the server.
I am hopeful that you can provide guidance or suggestions on how to achieve these objectives. Your expertise has been invaluable to me thus far, and I eagerly anticipate your insights on this matter.
Thank you for considering my request, and I look forward to hearing from you soon. Please let me know if you have any questions.
Best Regards,
pivotsmoak
Your tutorials have significantly elevated my skills as an average Excel and VBA user, particularly in the realm of analyzing and crafting dashboards for my team. Your guidance has been invaluable, and I now turn to you with a specific issue. I am analyzing and creating dashboards for my team, and your videos have been instrumental in helping me build more robust, dynamic, and user-friendly dashboards.
I am writing to seek your expertise on a specific problem I’m encountering. My data model involves a file with over 10,000 rows and 28 columns, and I import this sizable data set every week for my team to review and make necessary comments and modifications. The columns/headers are constant. Given the limited number of licenses to access the data on the server, I download the data file weekly so that the team can keep current with each of the tasks.
The enclosed file is a representation of my data model with fewer columns and rows. The enclosed table tries to simulate the problem I have.
The challenge arises when new data is imported, as it tends to overwrite the existing data, excluding team comments that are located outside the table range. This results in misaligned comments when additions or removals occur in the master file. Also, not knowing if the updates from the previous week have been updated on the server.
To address this issue, I am seeking a method that accomplishes the following:
Preserves user comments and aligns them with the correct line item when new data is imported.
Highlights any modifications made by users to the previous file in any of the data fields that have not been updated on the server.
I am hopeful that you can provide guidance or suggestions on how to achieve these objectives. Your expertise has been invaluable to me thus far, and I eagerly anticipate your insights on this matter.
Thank you for considering my request, and I look forward to hearing from you soon. Please let me know if you have any questions.
| House ID: | EstPrStrt | Act. PrSrt | Est. Cost | Act. Cost | Contractor | Status | Comments | Hcomments | |
| H123 | 2/10/2023 | 2/20/2023 | $225 | $275 | Jim | Completed | great job - replaced front porch | replaced front porch - great job, professional, took longer than we excepted | |
| H128 | 2/28/2023 | 3/10/2023 | $280 | $355 | Joe | Completed | very professional - install ceil fan & mount tv on back porch | install ceil fan & mount tv on back porch - very professional | |
| H220 | 3/1/2023 | 3/11/2023 | $500 | $450 | Jim | Completed | great job -installed new window | installed new window | |
| H230 | 3/15/2023 | 3/25/2023 | $325 | $425 | Bill | Completed | very professional - replace kitchen sick & faucet | replace kitchen sink & faucet - very professional | |
| H330 | 3/21/2023 | 3/31/2023 | $1,000 | $1,120 | Bill | Completed | good job and finish ahead of schedule - installed new flooring | installed new flooring - good job and finish ahead of schedule - little expensive | |
| H125 | 2/10/2023 | 2/20/2023 | $225 | $275 | Jim | In-progress | great job - replaced front porch | ||
| H127 | 2/28/2023 | 3/10/2023 | $280 | $355 | Jay | Completed | very professional - install ceil fan & mount tv on back porch | ||
| H223 | 3/1/2023 | 3/11/2023 | $700 | $650 | Jim | Completed | great job -installed new window | installed new window | |
| H231 | 3/15/2023 | 3/25/2023 | $350 | $450 | Bill | Completed | very professional - replace kitchen sick & faucet | replace kitchen sink & faucet - very professional | |
| H333 | 3/21/2023 | 3/31/2023 | $1,010 | $1,130 | Bill | In-progress | good job and finish ahead of schedule - installed new flooring | installed new flooring - good job and finish behind of schedule - little expensive | |
| H129 | 2/10/2023 | 2/20/2023 | $325 | $375 | Jay | Completed | great job - replaced front porch | ||
| H229 | 2/28/2023 | 3/10/2023 | $290 | $365 | Joe | Completed | very professional - install ceil fan & mount tv on back porch | ||
| H227 | 3/1/2023 | 3/11/2023 | $500 | $450 | Jim | Completed | great job -installed new window | ||
| H235 | 3/15/2023 | 3/25/2023 | $325 | $425 | Bill | Completed | very professional - replace kitchen sick & faucet | ||
| H332 | 3/21/2023 | 3/31/2023 | $1,100 | $1,220 | Jay | Completed | good job and finish ahead of schedule - installed new flooring | installed new flooring - good job and finish ahead of schedule - little expensive | |
Best Regards,
pivotsmoak
