VBA or Function - have a select range of columns in a row following a reference cell?

[tzcoding]

Is there a way in excel to have a select range of columns in a row following a reference cell?

Situation: I have a set range that is part of a data pull and populates information off a reference ID# that I pull in from a data set. The downside is that I have some manual cells that I use for user input that i also need to follow that reference ID#.

Example: I have the reference ID# in column "A: A" and column "B: E" all autofill the rows as long as the reference ID# in the data pull match column "A: A." However, columns "F: J" are all user input and will not follow the reference ID# in Column "A: A. "Witch causes conflict when validating information. I need the rows in column "F: J" to follow the rest of the rows that are auto-filling to columns "A: A" reference ID#.

 

[Joe4]

I think it would be helpful if you could show us an example of that you are trying to do.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[tzcoding]

Here is a better visual example that might help explain what I am trying to do.

Columns A:D are populated by a Teradata pull, Columns H: I are user input, and finally, Columns F: G check if the two match. Usually, Column F would be hidden in this situation. I added text to the image, but the issue is that as the Teradata refreshes and more information are loaded in columns A:D, then columns H: I stop matching. This is because the Teradata pushes the info down in the hierarchy, so the new information is at the top of the row.

My help need is that I need the information if H: I to follow the Teradata information so that the user inputs match appropriately to the correct reference ID#

 

[Joe4]

It seems like a design flaw to me.
You should really not be matching on row number, especially since the data will not always line up, as you have shown.
Rather, you should be matching between the two lists based on the ID#, using formula like VLOOKUP, XLOOKUP, or INDEX/MATCH.

Quite frankly, what you have is a "relational database", and would work much better in a relational database program, like Microsoft Access or SQL.
Then you would just "join" your two tables on your ID field, and it is easy to bring it all together in a simple query.
You can also do those kind of database operations in Excel if you use Power Query. So you may want to consider looking into that too.