Excel worksheet help
Solved/Closed
Shams
-
Jun 26, 2009 at 05:23 PM
venkat1926
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- Excel worksheet help
- Transfer data from one excel worksheet to another automatically - Guide
- Split excel worksheets to individual files - Guide
- How to automatically update one excel worksheet from another sheet ✓ - Forum - Excel
- How to automatically update one excel worksheet from another sheet vba ✓ - Forum - Excel
- Automatically transfer data from one sheet to another ✓ - Forum - Excel
1 reply
venkat1926
Jun 26, 2009 at 08:07 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Jun 26, 2009 at 08:07 PM
I am not sure there are any provision to post a sheet in this forum
let us see
sheet 1 has part no. in column A and data for each part no. in column B to G (row 1 is column headings)
in sheet 2 the cells A2 down have validation list (of part nos. in sheet 1).-here also row 1 has column headings.
in B2 of sheet 2 type this formula (including dollar signs)
=VLOOKUP($A2,Sheet1!$A$1:$G$500,COLUMN(B1),FALSE)
now copy this formula down and to the right .(in the rows where validation list is there)
Initially the entries in the cells except column A of sheet 2 will have #N/A error values. don't bother.
now once you enter any value in for e.g. A2 item from the validation list automatically the other data for this part no. will be available in row 2 of sheet2.
POST FEEDBACK
let us see
sheet 1 has part no. in column A and data for each part no. in column B to G (row 1 is column headings)
in sheet 2 the cells A2 down have validation list (of part nos. in sheet 1).-here also row 1 has column headings.
in B2 of sheet 2 type this formula (including dollar signs)
=VLOOKUP($A2,Sheet1!$A$1:$G$500,COLUMN(B1),FALSE)
now copy this formula down and to the right .(in the rows where validation list is there)
Initially the entries in the cells except column A of sheet 2 will have #N/A error values. don't bother.
now once you enter any value in for e.g. A2 item from the validation list automatically the other data for this part no. will be available in row 2 of sheet2.
POST FEEDBACK