Someone helped me a long time with these files and now something seems to not be working and I can't figure it out for the life of me.
File: Q4 - Rep.xlsx - This contains data for Q4 for our Sales Reps. Column AA contains the Sales Rep name, which we want to use in the next file.
File: Rep - Quarter 4.xlsm - This contains a tab for each Sales Rep. The Sales Rep name is entered into cell A1. Starting with A5, it is supposed to bring in each row from file Q4 - Rep.xlsx and then the information in the header.
If you look at Blake Brunk as an example, it is pulling in everything through the City of Nampa, but it is not pulling in Gem County (row 1283) or Mission Aviation Fellowship (row 1309). I'm not sure why it's not doing that.
Also, what is the number in column A? I thought it was the row line from the file, but that doesn't seem to match up with anything, as Canyon County Elections is on row 777 in the file, not row 38.
Q4 - Rep.xlsx
Rep - Quarter 4.xlsm
Thank you in advance for the help. If I can get Blake Brunk's working, I believe I should be able to copy it over to the other tabs to make them work.
File: Q4 - Rep.xlsx - This contains data for Q4 for our Sales Reps. Column AA contains the Sales Rep name, which we want to use in the next file.
File: Rep - Quarter 4.xlsm - This contains a tab for each Sales Rep. The Sales Rep name is entered into cell A1. Starting with A5, it is supposed to bring in each row from file Q4 - Rep.xlsx and then the information in the header.
If you look at Blake Brunk as an example, it is pulling in everything through the City of Nampa, but it is not pulling in Gem County (row 1283) or Mission Aviation Fellowship (row 1309). I'm not sure why it's not doing that.
Also, what is the number in column A? I thought it was the row line from the file, but that doesn't seem to match up with anything, as Canyon County Elections is on row 777 in the file, not row 38.
Q4 - Rep.xlsx
Rep - Quarter 4.xlsm
Thank you in advance for the help. If I can get Blake Brunk's working, I believe I should be able to copy it over to the other tabs to make them work.