| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Placeing data from sheet1 to sheet2 via a form button
I have created my own custom form that I need placed on sheet2 once the
submit button (form control) is pressed. There are 8 fields that I need to pass. Any ideas? Using Excel 07. Thanks Nick |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Placeing data from sheet1 to sheet2 via a form button
Hi Nick
See the code on this page http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "nickjames21" <u40881@uwe wrote in message news:7e9efcf1e2859@uwe... I have created my own custom form that I need placed on sheet2 once the submit button (form control) is pressed. There are 8 fields that I need to pass. Any ideas? Using Excel 07. Thanks Nick |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Placeing data from sheet1 to sheet2 via a form button
Hello Ron,
Thanks for the help. Sorry I was unable to access my account. Don't really know why but here I am. A couple of things... Thanks for the code. It is working for the most part. However with the Variable code, I am trying to place all of the info on one row. From cloumns A:H. The data on the other sheet is in D3, D5, D7, D9, D11, D13, D15 and D17. I can get it to place all data in the range of D3:D17 but it places all of the data only column A. Do you know of a way to just have it place it across the row instead of in the column? Any ideas or thoughts help! Thanks Nick Ron de Bruin wrote: Hi Nick See the code on this page http://www.rondebruin.nl/copy1.htm I have created my own custom form that I need placed on sheet2 once the submit button (form control) is pressed. There are 8 fields that I need to pass. Any ideas? Using Excel 07. Thanks Nick -- Message posted via http://www.officekb.com |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Placeing data from sheet1 to sheet2 via a form button
There is a example on the page to do this
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "nickjames21 via OfficeKB.com" <u40881@uwe wrote in message news:7ee90330a780c@uwe... Hello Ron, Thanks for the help. Sorry I was unable to access my account. Don't really know why but here I am. A couple of things... Thanks for the code. It is working for the most part. However with the Variable code, I am trying to place all of the info on one row. From cloumns A:H. The data on the other sheet is in D3, D5, D7, D9, D11, D13, D15 and D17. I can get it to place all data in the range of D3:D17 but it places all of the data only column A. Do you know of a way to just have it place it across the row instead of in the column? Any ideas or thoughts help! Thanks Nick Ron de Bruin wrote: Hi Nick See the code on this page http://www.rondebruin.nl/copy1.htm I have created my own custom form that I need placed on sheet2 once the submit button (form control) is pressed. There are 8 fields that I need to pass. Any ideas? Using Excel 07. Thanks Nick -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
| Placeing data from sheet1 to sheet2 via a form button | Excel Programming | |||
| A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updated | Excel Programming | |||
| Retrieving Data from Sheet1 into Sheet2 | Excel Programming | |||
| Write Data from Sheet1 to sheet2 Until | Excel Programming | |||
Hybrid Mode
