![]() |
macro? clearing/ transferring info to another sheet
hi! I have a form setup for an ordering system (thanks to
the helpful info I got here), but now I'm stuck again. I'd like for my users to be able to click a button to input (reference?) all the information onto a different sheet (labeled Log, the form sheet is labeled Form!) and then do two things: 1) increment by 1 the Order number (ie: 15+1), but the #15 is from the Log sheet (ie: =Log!A2). Where the log sheet has numbers 15-30 in column A. This can be modified to reference from the form sheet (=Form!M9) is the cell of that number, but I'd like it to automaticly put the correct sequential number in there (but I don;t care how). 2) clear all the fields (drop down menus, too) to 'reset' the form for the next order. So then end result would be to have the user: 1) fill out the form 2) click the button 3) fill out the 'next' form if this is a macro, please help me on the coding, since I'm not a programmer.. Thanks in advance for help and I'll be checking in often in case I need to clear any confusion up about what I need. -sam |
All times are GMT +1. The time now is 07:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com