Hi,
Hope someone can help me out. I have one sheet - a confirmation sheet - on which data are entered. Data can be entered in all light colored cells. Then the values of some of these cells need to be copied to another sheet, the database sheet. The confirmation sheet should then also be cleared without loosing the formulas. (see attachment for clarification..)
Thanks in advance!
B
hi Bertolt, welcome to the forum. i'm just learning VBA & trying to see if i can practise here. see if the attachment is what you need. i only tested it on lijn 3. firstly, you must save the file as xlsm like i did for the macros to be stored. alternatively, you can save it as an xls file. attached the macro to the button you created. pressing the button will copy the data to the database worksheet at the latest row & clear the contents on the confirmation worksheet, other than the ones with formulas
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Excellent! Exactly what I needed. Many thanks, B
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks