Selecting and Copying Columns Based on Combobox Selection V2

Hello again Excelforum!

A couple of months ago, I asked for help with an issue I was having with some ancient spreadsheets converted over to excel. The solution I received worked for the most part, but the issue of inconsistent formatting kept coming up, and I had no idea how the code actually worked. Last time my data was very inconsistent, so it was super difficult to select things properly without some blank space ruining everything.

Now I've redone the entire data sheet and everything should be uniform. We have a location name and a block of info about their purchases surrounding them. I tried reusing the solution to my old problem, but I couldn't really grasp what the code did in the slightest. Would someone be able to help me out?

Essentially I want to:

1. Take a location name from the combobox (Pulling from the list directly below it)
2. Pull all the relevant info from the shipping register into the correct columns on the packing list (Everything that has a colored background)
3. Have the code be easy enough to tweak in case we get new locations or the formatting changes

Hopefully this all makes sense. Thank you very much!

Originally Posted by protonLeah

The line:

Set RngBtm = .Range("A:A").Find("TOTALS", RngTop)

locates the first occurrence of "TOTALS" below the "test location" then, the line [INDENT]RngBtm = RngBtm.Row - 1 [/INDENT]subtracted one from the found row to move up one row, so just delete the - 1 to keep the totals row.

I don't need the entire line. I only want the one cell from a column that doesn't otherwise get pulled from the page. (Column G)
While tinkering around with it, I did manage to make a new variable to put into that cell, but I messed something up.

I can't remember how I wrote it exactly, but I ended up adding 6 in an attempt to get over to the G column, but the variable ended up being the "TOTALS" Row# + 6. So it always showed as 24 when selecting the first location for example. I'm probably missing something super obvious lol.

Works perfectly. Thank you so much!

Thank you again. I really appreciate you going out of your way to comment the code for me.