ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   copy data from one sheet to another using a combo box (https://www.excelbanter.com/excel-worksheet-functions/260961-copy-data-one-sheet-another-using-combo-box.html)

Tomwireless

copy data from one sheet to another using a combo box
 
I Have 2 sheets, a database of items sheet and a form with a combo box to put
the record I get from the database. I want to pick a record from the database
sheet and add it to my form and have it bring the whole record with it to
the form.both sheets have the same fields.
--
Thank you

Steve Dunn

copy data from one sheet to another using a combo box
 
Investigate the help files for VLOOKUP. I think that's what you need.


"Tomwireless" wrote in message
...
I Have 2 sheets, a database of items sheet and a form with a combo box to
put
the record I get from the database. I want to pick a record from the
database
sheet and add it to my form and have it bring the whole record with it to
the form.both sheets have the same fields.
--
Thank you




All times are GMT +1. The time now is 01:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com