Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 193
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Clear a set of combo boxes after a Submit of data to a new sheet. Jonah Excel Worksheet Functions 0 March 3rd 08 12:05 AM
How can i copy data from a tabbed working sheet to a summary sheet StephenF Excel Discussion (Misc queries) 1 March 15th 07 03:40 PM
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 parag Excel Worksheet Functions 3 June 15th 06 10:29 PM
combo box from data validation with source list in separate sheet Jay Trull Excel Worksheet Functions 6 March 7th 06 01:59 AM
Combo box copy data Steve Excel Discussion (Misc queries) 1 December 22nd 04 12:00 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"