Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
coding for connection between two sheets
i need to devlope a format which contains two excel sheets. one sheet having columns named as sr no., products and the details of their distributions and reciepts. second sheet contains the sr no. & products. i want the the product name (unique) to be displayed in the column as i enter the sr no in Sheet 1. *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
coding for connection between two sheets
In Sheet1, assuming serial no is in column A and prod. name in column B;
In Sheet2, assuming your serial no is in A1, enter in B1: =VLOOKUP(A1,Sheet1!A1:B999,2,TRUE) HTH -- AP "tushar joshi" a écrit dans le message de ... i need to devlope a format which contains two excel sheets. one sheet having columns named as sr no., products and the details of their distributions and reciepts. second sheet contains the sr no. & products. i want the the product name (unique) to be displayed in the column as i enter the sr no in Sheet 1. *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
always recheck data connection library for latest connection strin | Excel Discussion (Misc queries) | |||
Color coding the excel sheets | Excel Discussion (Misc queries) | |||
Catalogue of fields' connection whit external fields ( sheets) | Excel Programming | |||
Catalogue of fields' connection whit external fields ( sheets) | Excel Programming | |||
Catalogue of fields' connection whit external fields ( sheets) | Excel Programming |