SQLSearcher
asked on
Excel Marco to change data to line row with date
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.
Regards
SQLSearcher
Worker-Hours.xls
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.
Regards
SQLSearcher
Worker-Hours.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I was able to write macro for the code given to me by als315. Thank you for your help.
Regards
SQLSearcher