duplicate sheet

Hey everyone, I have the following code: ... If IsEmpty(Sheets("Start").Cells(number, 7).Value) Then s = InputBox("How would you like to call it?") If s = "" Then Exit Sub 'Sub gets exited if no sheet name entered or "Cancel"...

Hi, I am having quite a time figuring how to make this work.. I have a Sheet with a very big table data base with several columns. The table is basically a budget calculator for my engineering projects. I ve created some buttons with recored macro for easier (one click) filtering. All works...

Hey Excel Gods need your help for a small problem. VBA noob here. i have a workbook with Sheet 1: - random date entry(which will manualy updated) in Column B4:B100 i have 2 macro lets cal it "1" & "2". Macro 1 create a new sheet with the sheet name same as date entry of B4 in Sheet 1 and...

Hey All, This has been driving me crazy, and I can't seem to find an answer anywhere. I'm creating a document at work for creating new item products. The workbooks currently has one sheet visible and the rest hidden. The hidden pages do all the work with lists, and Vlookups ect. The Visible...

Hi everyone, First I must say that this forum is awesome. Everybody wants to help! So to my question. Is it possible to create a macro that makes it possible to duplicate the activated sheet by clicking a cell (Something like a "hyperlink"). Is this possible to do? I would be grateful if...

I have this code that duplicated my main sheet and renames is based on a cell value. My problem I don't want to duplicate the sheet if it already exist, which is going to happen A LOT. I need help making this happen. Below is what I have so far. Dim MySheetName As String MySheetName =...

I have a sheet named say "A". I have to create a duplicate sheet in the same workbook and rename it as "B" which can be done as <Code> Sheets("A").Copy After:=Sheets(1) Sheets("A (2)").Name = "B" </code> But the problem is I want to create this new sheet "B" immediately after "A" where the...

Hi, I'm trying to feed information from a MSProject file to an excel workbook. I want that for every uncompleted task that is a non-summary task, that I duplicate a sheet in the excel workbook and rename it to the Text1 field value of the task. The template sheet is the 2nd sheet and is named...