The Spreadsheet I am working with.

Just wanted to attach the spreadsheet to give a better idea....

I am trying to write a code to look through one column of a large worksheet pulling in data from that sheet in to others. What I have is a column titled "sector" I want the code to loop through this column and seperate the like values. I then want it to pull the data based on each sector in the worksheets I have created for them.

For ex. the sector column includes things like U.S. Treasury, FNMA, and GNMA. I was to use vba...

I am trying to write code to copy and paste a worksheet from one workbook to another. The thing I cannot figure out is how to reference the workbook to be copied because the name will be different when this macro is run, as it is for monthly reporting. The workbook it is to be copied into is titled Monthly TAC Builder, sheet is Last Month. I dont know how to write the code without a certain name for my sheet to be copied from.

Tha...