Previous Topic Next Topic

Data linking

Closed
anu - Mar 18, 2011 at 03:57 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Mar 18, 2011 at 08:08 AM
Hello,

Hi I have some data in my excel like customer details I want whenever I put unique m\c serial no in sheet 2 autotactically other details appear

Data like below in workseet 1

Site area Name Serial Model pline Ins.dt Engg Service
410101 DL01MD abc 78U00W10074414 GPB78 ABMX ?

Start End SSS flg
OWNCCMX 10/9/2007 10/8/2012


i want above data like below .i need when ever i put serial no contect no and contect no rest details take automanully from sheet 1


M\C Serial Customer Name Model Service stauts Contect Person Contact No Area

Engg SSS flg

thanks

usha







1 response

Answer 1 / 1
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Mar 18, 2011 at 08:08 AM
use Vlookup
0

Similar discussions

Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses
AMD data change update new data to DMI
Luis -
dwebb -

1 response