12/7/7

PROJECT: Workorder Database

I'm trying to write some code for a simple database and am needing some of your VALUABLE help. I know very little about VBA and will be learning this as I go, please be patient.

I'd really like to do this in 'baby steps'. Thanks

I've formatted a spreadsheet for the data to be collected, it looks like a form.
Just some cells with data, i.e. name, address... (actually several sheets of data)

I want to take the data from the form and have a button append it to the next empty row of a different sheet.

I think I'll be using some type of automated copy/paste from there.

Please remember 'baby steps'.

If someone already has some code that would be fine, if not then...

I had the basics fully working, but have been running into problems as I refine the macro

Here's some code I wrote, it did look a whole lot better, but during the fixes, attempted fixes and additions it got disorganized...

My problem now is step 4a. copy WO# back to Woform.xls sheet Form cell j30.
I can’t get it to re-select the first wkbk, Woform.xls and paste the WO# , (you can see my attempts)
Then I want it to go back to the Wodb.xls to complete the macro.

THANKS in advance, Phil

Please Login or Register  to view this content.