Hi all,
I have a bit of a curly problem that I'm hoping someone can help me work though!
Every day, I am required to manipulate a couple of existing spreadsheets in able to consolidate data in to a certain format as so I can then copy/paste that information into SAP.
I can do this with lots of manual steps, however of course would like to automate it, but the variables have made it a confusing problem.
I have one spreadsheet called 'issues. This contains multiple columns which are populated as goods are issued from our store.
I have another spreadsheet that is created daily by downloading information from SAP. The name of this spreadsheet changes everyday with the download based on date.
First problem: How to isolate the required five columns and varying amount of rows of data from the 'issues' sheet that are between yesterdays date and todays date AND from the 2nd last row that has been highlighted in Yellow colour to the last row that is highlighted in the Yellow color (I highlight the row at the end of the shift to differentiate between shifts). Then select and copy this data to another spreadsheet
Second problem: In the downloaded spreadsheet from SAP, go to the first empty row (as each day the amount of data varies), then go to column number four and paste the data from Problem 1 (issues sheet)
Hoping someone can help!
I have a bit of a curly problem that I'm hoping someone can help me work though!
Every day, I am required to manipulate a couple of existing spreadsheets in able to consolidate data in to a certain format as so I can then copy/paste that information into SAP.
I can do this with lots of manual steps, however of course would like to automate it, but the variables have made it a confusing problem.
I have one spreadsheet called 'issues. This contains multiple columns which are populated as goods are issued from our store.
I have another spreadsheet that is created daily by downloading information from SAP. The name of this spreadsheet changes everyday with the download based on date.
First problem: How to isolate the required five columns and varying amount of rows of data from the 'issues' sheet that are between yesterdays date and todays date AND from the 2nd last row that has been highlighted in Yellow colour to the last row that is highlighted in the Yellow color (I highlight the row at the end of the shift to differentiate between shifts). Then select and copy this data to another spreadsheet
Second problem: In the downloaded spreadsheet from SAP, go to the first empty row (as each day the amount of data varies), then go to column number four and paste the data from Problem 1 (issues sheet)
Hoping someone can help!
