Hi.
I want to insert some data in a number of cells (e.g. A1, B4, C4 and H8) on a worksheet ('Sheet 1').
I then want to press a button and have some code that:
Looks at column B on 'Sheet 2'
Finds the next empty row
Copies and pastes the information from Sheet 1 into specific cells in that empty row.
Any ideas?
Gavin
Last edited by Gavin Ling; 05-20-2009 at 03:51 AM.
Gavin, in truth I think we would want more info in terms of where you want to paste the resulting values...
There are countless approaches to this type of thing... one (inelegant) approach being:
Please Login or Register to view this content.
Last edited by DonkeyOte; 05-20-2009 at 02:40 AM. Reason: incorrect sheet reference
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
That's great. It seems to work fine.
What I'm doing is typing an invoice in one page and I then want to store the information in list form on the other sheet once you hit the button.
I've expanded it to copy all the cells I need (about 25 of them) and it seems to work perfectly.
Job done - thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks