Info On Excel - Education

Info On Excel - Education - Nairaland

Nairaland Forum › Nairaland General › Education › Info On Excel (594 Views)

Info On Excel by Rizin(op): 4:21pm On May 03, 2016

please can someone help me out. I have Excel sheet from headquarters with 10 columns ( heading: car no, date of service, km, part no, fuel level, etc) with up to 3000 rows. I do receive this report with the same no of columns from different regions. I need to collate these reports into the main sheet. is there a way I can add the columns from the regional sheet to the main sheet. I know vlookup but it only adds one column at a time. Thank you.

Re: Info On Excel by trendygirl: 8:26pm On Dec 10, 2016

Rizin:
please can someone help me out.
I have Excel sheet from headquarters with 10
columns ( heading: car no, date of service, km,
part no, fuel level, etc) with up to 3000 rows. I
do receive this report with the same no of
columns from different regions. I need to collate
these reports into the main sheet. is there a way
I can add the columns from the regional sheet to
the main sheet. I know vlookup but it only adds
one column at a time.
Thank you.

Hello please can you pm me

1 Reply

Help: How Do I Score A Yes Or No Questionnaire On Excel • UNIJOS Promise To Reward Any Student With Info On The Cause Of The Fire Outbreak • Ajah Excel-Anayo Runs For World Leadership Position (photos) • 2 • 3 • 4

Erc Calls For Reversal Of Admission Screening Exercise Fee In Lasu • Lausites Please Reply • How Can I Transfer Data From Bb Plan To Android Plan