VBA Noob -

[Ladi_Lucfr]

Hi Everyone!

I have a question. I know nothing about VBA so I wanted to know if what I want to do is even possible. I am trying to make this in excel but I think Access might be the way to go. I just like excel more.

I have a worksheet in which i key in my employees hours worked and any fees incurred for that pay cycle. It can be one row per employee or several rows depending on hours worked to other units that need to get cross charged. I have headers in place but what i need is for this data to be copied on to a database and it needs to read down rather than accros...

the first worksheet looks like this
field1........field3......
eeid, name, reg hrs, ot, fees, total

i need the second database to copy it like this
eeid name field 2 header, reg hrs amount
eeid name field 3, ot hrs amount
eeid name field 5, fees amount

this needs to be for one employee until there is nothing else to copy and then it needs to move the next employee and do the same. ignoring blank columns...

yes?, no? maybe? too confusing?

 

[pbornemeier]

Welcome to the board!
Yes it can be done.
But you have not provided enough information to do it.