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!
Bookmarks