Macro to lists all values in a range, and add value of another cell in adjacent cell

[dreddster]

Hey guys,

I have a table that has names in column A131:A172
In B131:F172 - different values, including empty cells.
I need a macro that lists each value found in B131:F172, and copy them in cells starting from cell B174, as well as list the respective name in cells starting from cell A174. (values can repeat, no need to be unique)

For example A131 is John. D131 is 5. The macro will put in A174 John and in B174 will put 5.
Then F131 if it is again 5, to list A175 John, B175 to list 5.
Then to collect the values from Row 132, 133, etc.

Is this possible?

Thank you in advance!

[JOHN H. DAVIS]

Not sure I understand. If this doesn't help, please provide a before and after sample.

Please Login or Register  to view this content.

[dreddster]

Hello John!

I have attached a sample file, and have listed the first few results how they should appear
Ef_example6.xlsx

Macro should go from row 131, column B and whenever it sees a cell that has some text inside, to copy it below and list the name that is in column A.
I just need a list the values of all tests and the respective name that took it.

Also I will run the macro from a different sheet so if possible to refer the macro to run on sheet called Test

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[dreddster]

John, it is perfect! Just one more thing. Because I am running it from another worksheet, how do I tell the macro to do that on sheet "Test"?

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

[dreddster]

That's strange. I updated it, but it is not working when I run the macro from another worksheet. Otherwise it works fine.

[JOHN H. DAVIS]

It works for me. What do you mean by run the macro from another worksheet? Do you want a worksheet event code? Do you want it operate on the active sheet? Please explain.

[dreddster]

The file has 2 worksheets. One is with the Results, the second one is Data, and will be hidden. On Data will be the actual macro work
I will put a button on the Results worksheet and assign the macro to it.

When I open the Results worksheet and run the macro - the screen just blinks once and nothing has been done.
When I select the Data worksheet, and run the macro, it works fine.

Let me test it a little further.

[dreddster]

I did retype all sheet names again, and in the macros.
All is good now! I must have typed a cyrillic character in the sheet name.

Thank you so much for your help!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.