Hello Experts Exchange
I have a Spreadsheet that has days of the week and a week number.
I would like a macro to write the data from the table into data I can import into SQL Server.
I have added a spreadsheet with how the data is on sheet1, and on sheet2 is how I would like the data to be changed to.
The date field should be worked out by taking the month date from cell E1, then get the week number, then get the day of the week.
Thank you for reading.