| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding new data to sheet2 from sheet1
Hi i have 2 sheets in my workbook 1 called main and 1 called DVD, on the main
i have a simple enter the number of dvd and it displays the dvd info from DVD, row B,c,d when it finds that number. Here is my question i want to be able to if possible basically search for the number if no infomation is there below i can add the new info eg Dvd Name type Price DVD Number 99 Lost Series 2 TV series £29.99 Dvd Name Type Price if there is no info on a number i want to be able to enter this info below and then get it to add the info. I have no experience with Visual Basic, and been told i need to use Visual Basic. Ty for any info |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to sheet1 data goes to sheet2 automaticaly ? | Excel Worksheet Functions | |||
| copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
| A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updated | Excel Programming | |||
| How To Retrieve Data from Sheet2 into Sheet1 | Excel Worksheet Functions | |||
| Transfer data from sheet1 to sheet2 | Excel Programming | |||
Threaded Mode
