Macro that Copy and Paste Values

[Nuccio92]

I have attached an example excel workbook of what I am attempting to do. I am trying to pull information from worksheet "Data By Stubhub Order" into worksheet "Data by Seat".

I need to pull from "Data by Stubhub Order" EI2, EQ2, EY2, A2, B2, C2, D2, E2, F2, G2, H2, I2, J2, K2, L2, M2, N2, O2, P2, AC2, BN2, BO2, BP2, BQ2, BR2, DE2, DF2, DG2, DH2, DI2, DJ2, CG2, CO2, AND CW2 into "Data by Seat" A2 - AH2 respectively.

Then I need to pull from "Data By Stubhub Order" EJ2, ER2, EZ2, A2, B2, C2, D2, E2, F2, G2, H2, I2, J2, K2, L2, M2, N2, O2, Q2, AC2, BN2, BO2, BP2, BQ2, BR2, DE2, DF2, DG2, DH2, DI2, DJ2, CH2, CP2, and CX2 into "Data by Seat A3-AH3 respectively.

I need to do that for every seat in that row. So there is a possible of eight seats in each row, and the bold cells are the only ones that change until you move down to the next row. Obviously if the first sell is blank I don't need to pull all the information.

For example, in the sample I attached the first row I just need to go up to the fifth seat, the second row just the first seat, but in the third row I need eight seats. If something doesn't exactly make sense or not really possible using a macro please let me know. I tried to explain it the best way I could.

[Doc.AElstein]

I have attached an example excel workbook of what I am attempting to do. I am trying to pull information from worksheet "Data By Stubhub Order" into worksheet "Data by Seat". ......

For example, in the sample I attached the first row I just need to go up to the fifth seat, the second row just the first seat, but in the third row I need eight seats. If something doesn't exactly make sense or not really possible using a macro please let me know. I tried to explain it the best way I could.

Hi,
... I strongly expect that it is possible with a macro, most sort of sorting / reorganizing of things are.
. The requirement just seems like a lot of work going through, and selecting all those columns etc....
. ( we are here to help, not do lots of free work for you!! )
.
. It would improve your chances of getting help if you produced both before and after sheets. In your case the before sheet is , I guess what you have supplied as the empty “Data By Seat” sheet. You need to give an after sheet, which would be exactly as “Data By Seat” would look like after running of the macro.. so based on your verbal description.
.
. It would further improve your chances if you could reduce the number of columns in the sample file you upload. I realise you need all those columns in the Praxis, but it puts off anyone trying to look through and see what you want. There is probably a certain logic to how the columns are organized, you would know that, but anyone seeing the project for the first time may find that difficult to grasp.
. If your reduced size sample data is fairly representative of the sort of data and representative of the order of data you have, then any code we do for you would most likely work for you then with the full data with no, or only minor modifications. But it is much easier to develop, and importantly, for you to be able to understand and learn from, a code with smaller amount of data.
.
. I would certainly be prepared to have a go for you later if you present the info I asked for.
.
Alan