Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding new data to another sheet from the main sheet
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 | |||
Summarizing data on one main sheet | Excel Worksheet Functions | |||
How do I combine data from several sheets into one main sheet? | Excel Worksheet Functions | |||
how to compare a list of data that is same as the main data sheet | New Users to Excel | |||
Selection from list on main sheet from suplemental sheet in same w | New Users to Excel | |||
adding data from one sheet to another sheet as a dropdown list bo. | Excel Discussion (Misc queries) |