Hi,
I receive multiple excel documents daily for customer sales management and am trying to automate the cleanup and put it in a format that is useful. My shipping report has the same leading rows everyday but as I ship product the trailing rows grow. What is the best way to clean this up in Access 2016? I get up to 6 different spreadsheets and cleaning them up manually takes too much time. What is the best practice here? Import it and then clean it or vice versa. I am a beginner and appreciate any guidance.
Thanks for your help in advance.
Cheers,
Razzbarry
I receive multiple excel documents daily for customer sales management and am trying to automate the cleanup and put it in a format that is useful. My shipping report has the same leading rows everyday but as I ship product the trailing rows grow. What is the best way to clean this up in Access 2016? I get up to 6 different spreadsheets and cleaning them up manually takes too much time. What is the best practice here? Import it and then clean it or vice versa. I am a beginner and appreciate any guidance.
Thanks for your help in advance.
Cheers,
Razzbarry