Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Database
I work with 5 Excel sheets but opened at the same times
The information on each sheet is as follows an example Sheet1 A1 ULD number as PMC12121KZ B1 Weight as 1200Kg C1 Height as 160cm enz and so several rows under each other All the information on sheet 1 MUST be unique so if the same information will be inputted on sheet number 2 as A1 PMC12121KZ a warning must be given and a choice I must have to import on sheet number 2 with all relevant information as column B,C,D,E enz or leave on original sheet How do I start this? Stefan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Database
This page should give you a start:
http://www.cpearson.com/excel/duplicat.htm Chip Pearson's page on duplicates and uniques. -- Regards, Tom Ogilvy "news.quicknet.nl" wrote in message . nl... I work with 5 Excel sheets but opened at the same times The information on each sheet is as follows an example Sheet1 A1 ULD number as PMC12121KZ B1 Weight as 1200Kg C1 Height as 160cm enz and so several rows under each other All the information on sheet 1 MUST be unique so if the same information will be inputted on sheet number 2 as A1 PMC12121KZ a warning must be given and a choice I must have to import on sheet number 2 with all relevant information as column B,C,D,E enz or leave on original sheet How do I start this? Stefan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
Convert Excel database to dBASE database? | Excel Discussion (Misc queries) | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
How to make reference to database and if true copy from database? | Excel Discussion (Misc queries) | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) |