worksheet amalgamation
hello everybody,
im trying to use macros to copy three separate worksheets into one, with
each one added at the click of a button each time the user has finished
entering data. I have tried recording the copying and pasting of each
worksheet into the main one using a macro then assigning it to a button, but
i have drop down and check boxes and when pasted these do not correlate. I
want to know how to transfer them all together without any alignment
problems. Again, any help much appreciated, you will be helping a very
frustrated worker!
Thanks in advance.
|