I code/script by sheer force of will not by any actual knowledge...so I apologize for extremely messy/ugly code :)
But, I kind of got this do what I want except for 2 things:
The auto fit isn't working and I need to know how if I delete something off the first sheet (DME LOG) it will delete the coresponding cell on the second sheet (DME Data)
I had originally got the auto fit to work by first filling the cell with xxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxx, running auto fit then populating the cell with my data and running autofit again. That worked if I wasn't using the do/while loop to add mulitple items if needed...
so basically I would like some tips on how to make this work a little better...or if I'm making this harder than it needs to be.
Essentially, staff will see the first sheet and input data, the 2nd sheet will be hidden and mgmt will be able to look at that...ok, I'm rambling now...workbook is attached, let me know if theres anythign else you need!