New to Macros: Automatically Populate Data to Different Spreadsheet

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

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

I will make sure to do so! I actually have another question. I realized I made a mistake in my original cleanup and I was supposed to remove column titled 'require visa sponsorship'. I believe that changes the code to:

Rows("1:7").Delete Shift:=xlUp
Columns("B:J").Delete Shift:=xlToLeft
Columns("C:R").Delete Shift:=xlToLeft
Columns("E:Q").Delete Shift:=xlToLeft
Columns("C:C").Select
Selection.Replace What:="I am not a Veteran", Replacement:="N", LookAt:= _
xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Selection.Replace What:="Veteran", Replacement:="Y", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Columns("D:D").Select
Selection.Replace What:="Yes", Replacement:="Y", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Selection.Replace What:="No", Replacement:="N", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Rows("1:1").AutoFilter
ActiveSheet.AutoFilter.Sort.SortFields.Clear
ActiveSheet.AutoFilter.Sort.SortFields.Add Key:=Range _
("A1"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal
With ActiveSheet.AutoFilter.Sort
.Header = xlYes
.Apply


I am still trying to figure out the rest on how it copies to the Formatted Spreadsheet, I will need to populate the cleaned data as follows:

• Cleaned Data, Column A to Formatted spreadsheet, B25 (and on)
• Cleaned Data, Column B to Formatted spreadsheet, C25 (and on)
• Leave Formatted spreadsheet, D25 and on blank
• Cleaned Data, Column C to Formatted spreadsheet, E25 (and on)
• Cleaned Data, Column D to Formatted spreadsheet, F25 (and on)

I'm realizing recording a macro adds alot of extra code in the equation and that's why it seems so confusing at first. The code you created seems simpler, however, I have yet to learn the rules on how everything is separated and what can go together and what can't.