Hi,
I have 2 sheets in my file. Sheet 1 is a price list with vast amounts of data. Sheet 2 references some basic data from columns in Sheet 1 e.g. PRODUCT CODE, RETAIL PRICE and TRADE PRICE.
I need new rows (products) that are added to Sheet 1 to automatically appear in Sheet 2.
Bonus Question: Why would some of my existing data not appear in Sheet 2 when referenced from Sheet 1? Im using =Sheet1!A1 at the moment.
Thanks
Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!
However, nothing on this Forum works quite as well as you might expect. The attachment icon doesn't work!! (Helpful, isn't it!!). Instead, just before you submit your post, click on GO ADVANCED (near the bottom) and then scroll down to Manage Attachments to open the upload window. The relevant instructions are at the top of that screen.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Here's an example.
Is this what you had in mind:
IF(Sheet1!A2="","",Sheet1!A2)
copy down as far as needed. Adjust the ranges for the other columns.
That works pretty well but there are a few problems with it.
1. Sheet 1 updates into sheet 2 when I add new rows at the bottom of the data in sheet 1 - this is good
2. If I add a new row to sheet 1 in the centre of the existing data it doesn't update in sheet 2.
3. If I delete a row of data from sheet 1 it appears in sheet 2 as #REF!. This would need to disappear.
Thanks
OK. Lose Row 2. In principal, blank rows just cause confusion, especially when you later need want to hide them. Widen row 1 to make it look better.
Then use this:
=IF(INDIRECT("Sheet1!A"&ROWS($1:2))="","",INDIRECT("Sheet1!A"&ROWS($1:2)))
substituting E or G for A to return the two prices.
Perfect. Thanks Glenn.
You're very welcome and thanks for the Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks