I have a nice worksheet that captures input data and compares it to
expected data. After it has 5-10 inputs, I'm done with that object I'm
doing work on, and have to start over again with a similar object. I want
to copy
that sheet that I just used to a new sheet with a command button. I could
also get the copy from a sheet that has the formulas and formating but that
never had any data input to it. On the new sheet I want to clear contents
of
the data I put in on the previous sheet. I then need a form box to pop up
to
ensure that my 4 starting parameters for each sheet are are checked and
changed if they need to be. The people who will be filling in the spread
sheets are not interested in running a macro, but might use a command
button, and will probably only check for the starting parameters if they pop
up like a form would do. I can get the copy form and deleteing of data with
a macro, but when I add a command button, it has problems with range while
its running. As for the form opening on a new sheet, my description of the
cell to enter is A4:D4 with the data going into A5:D5. When I try to get it
to open a form with a macro, the form pops up with 4 captions and 4 places
for data, but it starts at A1. I'm racking my brain, but I'm sure I'm just
manipulating it incorrectly. Help!
Brad Withrow