Excel compare and transfer data
Closed
NateDawg
-
Dec 18, 2009 at 04:10 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 18, 2009 at 08:09 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 18, 2009 at 08:09 PM
Related:
- Excel compare and transfer data
- Free fire transfer - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- Excel date format dd.mm.yyyy - Guide
- Beyond compare - Download - File management
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 18, 2009 at 08:09 PM
Dec 18, 2009 at 08:09 PM
I presume in sheet 2 row 1 is haing headings and stock numbers are entred from A2 down
in B2 copy this formula
note dollar sigbs carefully
now copy B2 down and to right up to column AA
I have made provision for 1000 rows , if more change the formula suitably. ($aa$1000)
in B2 copy this formula
=VLOOKUP($A2,Sheet1!$A$2:$AA$1000,COLUMN(B$1),FALSE)
note dollar sigbs carefully
now copy B2 down and to right up to column AA
I have made provision for 1000 rows , if more change the formula suitably. ($aa$1000)
