move sheet

Hey all, I have a workbook with a tab named 'References' Based on the current date, I would like the 'References' tab/worksheet to be assigned/moved as follows. If today's date falls between: 'References' Sheet Position in the Workbook Jan13 - Jan26 3rd tab from left Jan27 - Feb9 4th tab...

Hello Everyone. I have a folder with some file sets in it. Something like this: 12_500 07-02-2017#01.xls 12_500 07-02-2017.xls 12_501 07-02-2017#01.xls 12_501 07-02-2017.xls 12_502 07-02-2017#01.xls 12_502 07-02-2017.xls 12_503 07-02-2017#01.xls 12_503 07-02-2017.xls I would like to merge...

Hi I'm searching for VBA code to move a sheet from an already open workbook to a workbook that will be selected by the user. I'm using Excel 2010 on Windows 7 Open workbooks are: Macro workbook and Source workbook I've searched the forum but could't find a specific answer to my question. I've...

I current have some code that first copy a worksheet do some cleaning and then move it to another workbook. My problem is that when i copy or move a sheet it also copies the vba code that is attached to the sheet object. Is there a way to avoid this? Also when i move the sheet to another...

I have designed a couple of graphs using named ranges to give dynamics to the number of series in a chart. This works fine as long as I don't want to copy and/or move the sheet to a new work book. When I do this, Excel chooses to remove all references to the named ranges in the SERIES forumla...

When I record a macro to move a data sheet within a workbook, I get something like this: Sheets("Parameters").Move After:=Sheets(5) There may or may not be hidden sheets in this file. How do I get the proper "Sheets(5)". I can't figure out what that is. I have no sheet by that name. It...