Free Microsoft Excel 2013 Quick Reference

New Blank Worksheet Template

Using a template (book.xlt) I can convince Excel to open a new
workbook with preset formatting (for a custom table format). It works when I
open Excel for the first time, and if I open subsequent workbooks using that template.

What I want to do is open a new blank worksheet that has the same preset formatting
using the Office Button | New | Blank Worksheet button.

So far I have not been able to figure out how to do this. (Grrr) So I figured I'd humble myself and ask the
big brains for their help!

Thanks!


Hey everyone. I'm very new to excel and fairly confident a macro can achieve the desired results for the problem below. All help is greatly appreciate!

Situation:

I have a series of lines with domain names, i.e.

abc.com
abc.net
def.com
def.net
ghi.net
xyz.com

First, I'll be using the Replace All function to remove all .com extensions. Doing so leaves me with the following:

abc
abc.net
def
def.net
ghi.net
xyz

My problem lies in that I need to copy all instances without an extension to a new, blank worksheet. The final worksheet would look like:

abc
def
xyz

A know a macro to accomplish all this is the answer I just don't know how to do it. Any advice is greatly appreciated! Thank you!

David

Hi - I know how to place a book.xst template into the xlstart folder to
create a re-usable template, but I was wondering if it's possible to replace
the "worksheet" template that's always there?

Detail: I want to make sure I always use the company colour palette, so I
have a book.xlt template in "xlstart" that contains that palette (in Tools >
Options > color).

Excel correctly uses it by default when it starts up. Also, I can select it
from New ... > Templates > On my computer...so far so good.
BUT if I select File > New... then choose "Blank workbook" from the taskbar
on the right, or "workbook" from the New dialogue box, then excel uses its
own default template, with the old colour palette.... is there any thing I
can do?

Hi - I know how to place a book.xst template into the xlstart folder to
create a re-usable template, but I was wondering if it's possible to replace
the "worksheet" template that's always there?

Detail: I want to make sure I always use the company colour palette, so I
have a book.xlt template in "xlstart" that contains that palette (in Tools >
Options > color).

Excel correctly uses it by default when it starts up. Also, I can select it
from New ... > Templates > On my computer...so far so good.
BUT if I select File > New... then choose "Blank workbook" from the taskbar
on the right, or "workbook" from the New dialogue box, then excel uses its
own default template, with the old colour palette.... is there any thing I
can do?

here is a sample of the formula that I am trying to use, it works great except that I am using this as a Warranty type form, so what I need to have is a new blank open after the save to another worksheet has been done. any suggestions would be Greatly Appreciated

Sub test()
a = ActiveSheet.Range("A2")
ActiveSheet.Copy After:=ActiveSheet
a = a + 1
ActiveSheet.Range("A2").Value = a
End Sub

Hello,

I'm trying to figure out how to create a Macro that will create a new worksheet at the very end of all the current sheets. I want the macro to first come up with an InputBox, and whatever the user types into that Input box will be the new name of the Worksheet. I also want this worksheet to be identical to the Template worksheet I already have in the Workbook.

I thought this would be easy to code but I'm having some trouble of course

Here is what I have so far:

Option Explicit
Sub NewPage2()

Dim NewWorkSheetName As String
Dim Message1 As String
Dim Title1 As String
Dim DefaultTxt As String
Dim MyInput As String

Message1 = "Please enter the date to be used on the new Worksheet (Following the below format):"
Title1 = "Create New Worksheet"
DefaultTxt = "01.01.12"
MyInput = InputBox(Message1, Title1, DefaultTxt)
NewWorkSheetName = MyInput
Worksheets.Add After:=Worksheets(Worksheets.Count)
Worksheets(Worksheets.Count).Name = NewWorkSheetName
Worksheets("Template").Select
ActiveSheet.Copy
Worksheets(NewWorkSheetName).Select
ActiveSheet.Paste

End Sub
If I delete the bottom 4 Lines, it will create a new blank worksheet named after what I input into the InputBox. I just cannot seem to get it to copy the Template worksheet and Paste it into the newly created worksheet. Any help, as always, would be greatly appreciated!

ALSO: If there is a way to have an error message, or just have the macro stop if the user enters something that cannot be a worksheet name, that would be extra awesome

Thanks!

I have a worksheet template (ddsd.xlt) that contains links to a worksheet (Admin) within the workbook I am insterting it into:

When I click Insert on a tab and choose the template, it asks me 'The workbook you opened contains automatic links to information in another workbook...etc' if I choose Yes, it then says 'File not Found' (it's trying to find the linked cell workbook) the cells formula in the template is Code:
 this is a worksheet in the workbook I am inserting it into.
Even if I click Yes, Cancel or choose No at the message screen the sheet is added to the workbook but I get a Code:
 in the cell with the above code, even though that worksheet exists in the workbook I just inserted it into.
If I go to the Formula bar and click Edit Formula and click enter it fixes the Code:
 issue and points to the worksheet cell.

Any ideas on how I can avoid this happening, so that it inserts it and 'updates' the formula.
Also I am using a macro to insert the template (same issues):
Code:
Sub Insert_NewClient_Template()
    Dim sh As Worksheet
    Dim shName As String

    'name of the sheet template
    shName = "ddsd.xlt"

    'Insert sheet template
    With ThisWorkbook
        Set sh = Sheets.Add(Type:=Application.TemplatesPath & shName, _
                            after:=.Sheets(.Sheets.Count))
    End With

    'Give the sheet a name
    On Error Resume Next
    sh.Name = InputBox("Enter sheet name " & s & " of " & SheetCount, _
                    " NEW SHEET NAME")
    If Err.Number > 0 Then
        MsgBox "Change the name of Sheet : " & sh.Name & " manually"
        Err.Clear
    End If
    On Error GoTo 0
End Sub
Is there a way to suppress the Message Box ('The workbook you opened contains automatic links to information in another workbook...' )?

thanks

I regularly need to insert new worksheets into a workbook, based on the
format of previous sheets. I do this by inserting a new blank worksheet, then
copying the format from a previous worksheet , before entering data.
Can a workbook specific template be set up that will automatically insert a
ready formatted worksheet to that workbook only ?
Changing the workbook xlt. or sheet.xlt changes the workbook/sheet for ALL
other workbooks as well, which I dont want ?
Any suggestions please?

Hi all,

When I start Excel, it does not open with a blank worksheet.

It opens excel, then shows the grey screen displayed when you have no workbooks open.
CTRL-N or New opens a blank sheet as normal.

How come?

Using Excel 2007.
Starting Excel by its shortcut icon, with no parameters.

Thanks!
BigFurryMonster

My data is imported from a seperate program and the other program automatically opens a new work book when the import starts. My problem, the data only resides on the first worksheet and then there are 2 to 3 blank worksheets. Is there any way to right a macro to delete only the blank worksheets? Thank you for any help provided.

I have a large workbook that analyzes sleep data in the lab I work in. Essentially, there are twelve "Data" worksheets that raw data is copied and pasted into and then many other worksheets that graph, compare, and analyze this data. Recently however we have switched out sleep recording program and the raw data is now in a different format. I now export the data into a new workbook. Then I have created a Macro that edits this format into something that the original workbook can read, then copies and pastes into one of the data worksheets of the original workbook.

My problem is that the Macro always pastes the data in a specific data worksheet and I must manually edit the Macro to change what sheet it pastes it into for every new group of data. Ideally what I'm looking for is if there is a way to paste the data in the first available (i.e. blank) worksheet making it less restrictive. For example, if there is already data in the worksheets DATA 1, DATA 2, and DATA 3 it would paste it into DATA 4 (and only DATA 4) which is blank. Maybe some sort of if function?
Also if this is not possible is there a way to control a variable in a Macro. What I mean to say is can I run the Macro, then have a MsgBox appear asking me what worksheet I would like to paste the Data in.

Thanks in advance.

Hello

I am using Excel 2007 and I see it can handle over 1,000,000 rows which is a good thing. I am opening comma deliminated text files with about 500,000 rows and that works find they import find. The problem is I then want to sellect all the 500,000 rows in the newly imported worksheet and peast them into a new blank worksheet in another excel spreadsheet.

It does not allow me to do this as when you open a blank worksheet it only has the normal 65,000 or so rows, and therefore says the data I am trying to peate in is the wrong size etc.

This looks like an over sight my MS, any one know a way around this please?

Thanks I would be grateful if you could kindly email me the answer as well as answering it here

Thanks everyone.

I would like to change attributes in my 'New Blank Document' (the one created when pressing CTRL+ n).

I have managed to have my own template come up when first opening Excel (by placing a book.xltx in C:/program files/Microsoft Office/Office 12/XLSTART) but I would prefer this template to also come up when I create a 'New Blank Document'.

Help would be appreciated.
Martin
--
I am using Excel 2007 under Vista.

Hi Everyone,

I have a workbook with the usual 3 worksheets, I'm running a macro putting data into worksheet 1 and then transposing it to worksheet 2and 3. What I want to do is to show a blank worksheet in 2 and 3 even though they will contain data, as always any help is appreciated, as I am very much still learning this VBA/excel stuff. Feng

Hi i searched here but i didn't find out how to add a button and when i click on this button to open a new blank record?
I could really need some help. many thanks

Hey, I have a workbook with many sheets on it, with sheet names such as: 900355, 900356, 901977, (many 9##### format names) & a TEMPLATE sheet.

If I work off the TEMPLATE worksheet, can I make it so when I try to save the workbook, the TEMPLATE sheet will be saved on a worksheet with Worksheets("TEMPLATE").Range("B5") as the sheet name?

CTRL/END key combination should goto and select the last cell in a Worksheet. So for a Worksheet using Rows 1-4135 and Columns A-Z it should indicate Z4135 as the last cell
My current worksheet uses these Rows and Columns, but CTRL/END indicates last cell as being AB4506. (Inflated by 371 Rows and 2 Columns)
Deleting the unwanted Rows or Columns, or "Clearing contents" of them does not affect the result given by CTRL/END which still shows AB4506.
How can I adjust/correct the last cell indication?
Usual work-around is to select the wanted portion of the worksheet and copy it to a new blank worksheet, but is there an easier way?

Spreadsheet used by staff to compile statistics on work performance. strictly data, no formulas or totals on the sheet. I want to insert one row between the second last and the last row of data. Copy what was in the last row of data into the new blank row and then delete all columns of data after column a from the new last row.

Please help!

This query may seem simple to you all but its driving me crazy. I use spreadsheets on excel for different companies, and there must be a way of replicating a worksheet template within one workbook. I've tried doing this but then every workbook I open has the format. I only want worksheets within a workbook to have the same format. Can anyone help please?

Under Home - Format as Table Excel offers various table format styles:
Light, Medium, Dark. Users can add their own custom table styles as needed, however,
these are confined to the workbook in which they were created.

I need one, set as default, to be NONE (No Colors). I have tried loading it as a template
but have been unable to get it to reload when using the OPEN NEW BLANK WORKSHEET.

Can a custom table style be added using VBScript, perhaps as an add-in, that will stay
with Excel permanently?

Thank you!

Hi

I'm wanting a VB routine to remove any blank worksheets from the current work book.
Can anyone help ?

Everytime I open an Excel Worksheet, a second blank worksheet opens along with the one selected. This has only started over the last couple of weeks or so, how do I stop this from happening?

how do I return a sheet to it's orginal blank status without having to
delete it and insert a new one with the same name.

I'm trying to copy and paste some information in a sheet from another
workbook but it's giving me the merged cell error saying "the operation
requires the merged cells to be identically sized" and I can't paste,
can't paste special values either. I pasted onto a new blank worksheet
in a new workbook and it pastes fine. Even though I did a "clear, all"
of the sheet I'm pasting to and it still gives me that error, seems
like clear all doesn't remove the merged cell format. I can't delete
this sheet because it links to a lot of other sheets so I have to paste
on this sheet.

I want to know how to return this sheet to a blank status like a brand
new sheet. Thanks.

--
Mile029
------------------------------------------------------------------------
Mile029's Profile: http://www.excelforum.com/member.php...o&userid=21091
View this thread: http://www.excelforum.com/showthread...hreadid=386608

How do I get a blank worksheet to open in Excel at startup? It was doing it
for the longest time, but now no worksheet is opening.

Have a user who is running excel 2000 when they try to open a excel worksheet
they receive a blank worksheet - the only way from them to open up a
worksheet is to go to the open and select the file. 25 users at this site
only one having this problem. Anybody have experience with this ?