Hello, I need help creating a macro. I am receiving a populated excel file from an outside source, but I need the information in the excel sheet to be in a different format. Here are screenshots of first the excel sheet that I am receiving, and then the excel sheet in the format that I need it to be in:
Screen Shot 2016-07-20 at 3.37.44 PM.png
Screen Shot 2016-07-20 at 3.40.21 PM.png
So as you can see it is using the same content, but different format. For instance cell G27, G28 in the original sheet are used to populate cell E11 in the new sheet. The difference is the two cells information needs to be in one cell, with each name separated by a comma in the new sheet.
I used the macro recorder to help me, but it is not creating a general macro. This is what it comes out with:
Sub Macro7()
'
' Macro7 Macro
'
'
Range("D19:E19").Select
ActiveCell.FormulaR1C1 = "Making Me Smile"
Windows("Workbook1").Activate
ActiveSheet.Paste
Windows("FIXER UPPER 304 ENHANCED_final.xlsx").Activate
Range("G19").Select
ActiveCell.FormulaR1C1 = "David John Vanacore"
Windows("Workbook1").Activate
Range("E10").Select
ActiveSheet.Paste
Windows("FIXER UPPER 304 ENHANCED_final.xlsx").Activate
Range("G20").Select
ActiveCell.FormulaR1C1 = "Keith Richard Horn"
Windows("Workbook1").Activate
Range("E10").Select
ActiveCell.FormulaR1C1 = "David John Vanacore, Keith Richard Horn"
Range("E11").Select
Windows("FIXER UPPER 304 ENHANCED_final.xlsx").Activate
Range("K19").Select
ActiveCell.FormulaR1C1 = "Mocha Drive Publishing"
Windows("Workbook1").Activate
Range("F10").Select
ActiveSheet.Paste
End Sub
I need it to be using "Cell Content" instead of specific names so that the macro will be a general macro that can be used on different files with the same formats. What would I put in the "" instead of the specific names so that it pulls whatever is in the cell instead of specific words?
Thanks for helping me out!
Bookmarks