Hi all!
I fear that I have a basic VBA question / issue:
Sheet 1 is a user form (pretty, easy to use, great!)
Sheet 2 houses all raw data.
When info is typed into Sheet 1, press button and all info transcribes to cells on Sheet 2 and deletes from Sheet 1 so that the user form can be used again. Having trouble with Shift Down so that when new information is added, it's transcribed to the row below raw data on Sheet 2.
The code I have to take data from Sheet 1 to Sheet 2 works, but is overly complicated. I am new at this so I'm not trying to be fancy BUT there must be something better than the code I have now! I also cannot figure out how to shift down on Sheet 2 to allow for additional information to be added. Help!
Here is the code I'm using now with Update being the name of the button:
Anyone have any ideas? Thank you also for your help! Much appreciatedPlease Login or Register to view this content.
Bookmarks