create new sheet

Ok - so I've figured out a few more things that help me, and I got the code to run on all 50 worksheets, but now I'm finding that it is not copying the last row in the range. *OR* it's somehow writing over the previous worksheet's entry onto the "BigSpreadsheet" tab. Either way, I'm missing...

Hi, I got help from a experienced member here to rectify my code and it resolves my issue. However my another function seems having conflict with the suggested code. Can someone help me to correct it ! My file is attached Excel file When I run module 1, I debugged to get NEXT C in module 4 keep...

Hey guys, I'm working on a sheet where I can use a macro to generate new sheets and rename them to names in a list. I have managed to do this. Yet I want to edit the code to instead of creating a blank sheet. The macro has to copy the sheet named "Blanco" and rename that with the predefined...

Hi, I am looking for VBA code to find a solution to a problem. I have a master workbook with various ‘quote enquiries’. Usual things are included such as name, address, phone number, quote details. I also have a column that has the date a quote was sent (column M). I would like a Macro...

Hello there! I've been trying to find a code that creates a new sheet at each change in data in a special column, but couldn't be able to find any that works for my sheet. Sheets: (1)Colors(2)Blue(3)Green(4)Red A Blue A Blue A Green A Red...

Hi All, I am using Excel 2007. I am trying to prepare new a Excel sheet which will replace a conventional white board usage in my company.Btw I'm new to Excel VBA. Ours is a car rental company we need to track where our vehicles are daily at the end of the day.So this sheet will be updated with...

Hi Everyone, I need help in creating a spreadsheet and hopefully someone can help me. The spreadsheet will have a main worksheet that will have like a profile information. It will also have a button than when clicked it will create a new worksheet with the label on the bottom with the...

Ok, First i have a Word report i copy over to the original macro1 and macro 2 and it cleans it up for me, next (where i could use a updated macro) then i copy to a new sheet and sort on Column A and remove all the data that (in this case, the line starting PM and below--- all data for the rest...