-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
move sheets
-
VBA: Work Around for moving from one sheet to another based on cell value?
Hi guys! You've helped me so much in the past, I'm hoping you can help me again. I get a large data dump I have to do once a month but I have some formatting and moving around I need to do. (Lots of sorting, moving, resorting, etc.) I use a vlookup multiple times to pull in data from another...- larinda4
- Thread
- move sheets sort & filter vba
- Replies: 0
- Forum: Excel Questions
-
M
Macro to move sheet to another workbook if sheet name is equal to specified cell value
This one is a little complex and I am in way over my head on this one, but have come too far to turn back now. What I have is... On workbook "1" I have tabs named for the inspectors and their order numbers are in column A. Then in workbook "2" each tab contains order details and is named with...- mack321
- Thread
- macro match 2 criteria move sheets
- Replies: 6
- Forum: Excel Questions
-
D
Copy multiple sheets to a new workbook and then save
Hi, I'd like to move several sheets to a new workbook and then save the new file. This is what I have so far: Sheets(2).Select For j = 2 To ThisWorkbook.Sheets.Count Sheets(j).Select Replace:=False Next j ***Open new workbook and move active sheets*** ActiveWorkbook.SaveAs...- Davg
- Thread
- move sheets vba
- Replies: 2
- Forum: Excel Questions
