refreshing data

[j4m1n]

We have a list of unpaid invoices that are retrieved a few times a week. The raw data is pasted on one sheet (invoice data) and data from a select few columns are copied to another sheet with a very simple ='invoice data'A1 formula etc. That data is then manipulated but there is no absolute link to the specific invoice data, the formula is just to the row the invoice data is currently in. Problem is when new raw data is pasted the row position of the invoices will change as old ones go and new are added but the adjustments relative to a specific invoice (expected days payment is delayed, likely paid value etc) will now align with a different invoice number. Any ideas how can I overcome this automatically but still be able to retain simply typing 45 (as in the days payment delayed) in a specific column?

 

[Peter_SSs]

Duplicate to: Link formulas to specific cell values in a row?

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.


BTW, I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)