Transpose Timesheet Table into Database Format

[matt-gilbert]

I have an Excel table for entering timesheets into which needs to be converted into a database format for uploading into our accounting software.
I have attached a file to show you what I'm after.
Thanks in advance.
Matt

 

[Marc L]

Hi !

• Really need zero hours ?

• Software directly reads Excel workbook ?

And in case of a VBA code, move this thread to right forum !
​

 

[Asheesh]

Here is my go with it.. See the attached..

Change the ranges, cell references and tab names as per your requirement..

 

[matt-gilbert]

Thanks Asheesh. Works well. I have changed source data now but you have given me something I can work with. I might come back to you for some more help once I've further developed conditions etc. Thanks again.

 

[Asheesh]

No issues Matt - Happy to help...