I need to be able to link rows together so that additional or changing information will not push cells away from their base. For example, right now I have data in A1:F3500. Formulas perform Vlookups and Offsets to pull data from other workbooks in columns A,B & D while columns C & F are manual inputs (column E is a lengthy IF formula based on the data that appears in A,B & D). The problem is that when the source data changes (which occurs every morning) information in columns A,B,& D changes and moves while the manual inputs (columns C & F), corresponding to the data, remains in place and does not follow the data in columns A,B & D. A sort returns the data to its proper place only if there has not been any new data added to the source data. I need to create some sort of relationship between A1,B1,C1,D1,E1,F1 without typing in any formulas in C1 or F1. How?
Any help would be extremely helpful.
Why not import the data to some other place. Then you can control how the imported data is placed next to your manual data.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
I don't see how importing the data would generate the results I am looking for. Can you please elaborate?
Also, in regards to cross posting, I apologize. I did not realize I was committing an offense.
Your problem is that every morning the data changes.
Rather than put this changed data next to your manual inputs (which throws things off)
Put the changed data somewhere else and compare yesterday's (including manual inputs) to today's before deciding how to order this morning's new data.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
So you are saying that I will need to look through all of the data and find the changes made in order to match up the the sheets to each other from the previous day?
Is there a way to automatically include the value in A1 in cell C1 creating a reference and then allow for typing in C1, so that in C1 the value of A1 and any typed in text will appear in C1 without having to manually type in the A1 value in C1? If this is possible then I can do a vlookup to find the A column values in the C column and the cells will stay together right?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks