Inserting rows to consolidate column data

[Obsessed]

Hello Everyone,

This is my first post, so take it easy on me. I'm very new to VBA (I have the VBA for dummies book)

The sheet I'm working with has confidential information, but for examples sake, I'll say I have peoples names and info in A:D (these people give money), and I have 20 columns of data past that that contain names of people across the top (who receive money), and the cells contain a monetary amount exchanged between the people in the columns, and the people in the rows. Instead of having it in table form, I need to have it line by line that says Person A gives Person B "x" amount. I'd like to have something like Givers name and info in Columns A:D, Receiver in E, and amount in F.

This sheet will be very large when it's done (15k rows of givers), so that will have to be kept in mind.

I have attached an example worksheet to give a better understanding as it's hard to explain.

Thanks so much!

[AlphaFrog]

This assumes your data starts in Row 1

Please Login or Register  to view this content.

[AB33]

Just piped by Alpha. The same result.

[xladept]

This, my offering, finds the first row as long as you have "Name" as the Header in Column A:

Please Login or Register  to view this content.

Since it's your first post:

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Press ALT + F11 to open the Visual Basic Editor.

Open a macro-enabled Workbook or save your Workbook As Macro-Enabled

Select “Module” from the Insert menu

Type "Option Explicit" then paste the code under it

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name

[JBeaucaire]

@Obsessed - If that takes care of your question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks.

[Obsessed]

Wow everyone! Thanks so much for all of the help! These all work perfectly! I'll hold on to all of them as I'm sure I'll need to tweak it in the future to adapt to other issues I may face.

Thanks again!