Data?

Tim_Parkinson393 

To achieve your goal of transferring data, including part numbers and their prices, from one sheet to another in Excel for the web, you can use various techniques.

Here is a step-by-step approach using formulas:

1. Source Sheet: Let us assume your source data is in Sheet1. Column A contains part numbers, and Column B contains their respective prices.
2. Target Sheet: Create a new sheet; let us call it Sheet2, where you want to display the part numbers and prices.
3. Copying Data: In the first column of Sheet2 (where you want to display the part numbers), you can simply reference the cells from Sheet1 using a formula. In the second column (where you want to display the prices), you will use a similar formula.
• In Sheet2, cell A2 (for the part number):

=Sheet1!A2

• In Sheet2, cell B2 (for the price):

=Sheet1!B2

1. Copy these formulas down for as many rows as needed.
2. Now, as you enter part numbers in Column A of Sheet1, the corresponding prices from Column B will automatically appear in Column B of Sheet2.
3. Data Validation (Optional): To make data entry easier, you can use data validation to create a dropdown list of part numbers on Sheet1. This will help ensure that you select a valid part number and reduce errors.
• Select the cells in Sheet1 where you will be entering part numbers.
• Go to the "Data" tab > "Data Tools" group > "Data Validation."
• In the "Allow" dropdown, select "List."
• In the "Source" field, specify the range of part numbers in Sheet1 (e.g., Sheet1!A2:A100).
• Click "OK."

Now, when you start typing a part number in Sheet1, a dropdown will appear with valid part numbers from the source sheet. Once you select a part number, the corresponding price will automatically appear next to it, referencing the formulas you set up in Sheet2. Remember to adjust cell references and ranges based on your actual data layout.

Please note that the approach in Excel for the web might not provide the same level of automation and dynamic updates as formulas in the desktop version. If you are looking for more advanced functionality, you might need to explore the capabilities of Excel add-ins using Office Script, if supported by the Excel for the web platform. The text and steps were created with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.