Over 1 million tech questions and answers.

Excel - Workbook page numbering

Q: Excel - Workbook page numbering

hi all,
I have an excel workbook with several worksheets, each a page a long (i dont want them all merge in one sheet). I need to number them sequentially as they appear on the workbook.
The only way i can number them now is by going into each worksheet and inserting a page footer and enter a number manually !

Is there a way whereby all worksheets/pages are numbered automatically and more importantly page numbers changes if a new sheet is inserted ?
Thank u kindly.
Edd.

RELEVANCY SCORE 200
Preferred Solution: Excel - Workbook page numbering

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Excel - Workbook page numbering

Read other 12 answers
RELEVANCY SCORE 77.6

I use Excel 97 and for the life of me can't figure out how to change where the number goes. Is there a way to place it elsewhere than the bottom right hand corner?
 

A:Excel Page Numbering

Yes you can change the page numbers.

Go to File, Page Setup. Header/Footer tab and click on the Footer botton. Set the page numbers there.
 

Read other 1 answers
RELEVANCY SCORE 77.6

We have recently upgraded from version 2000 to 2003. The page numbering I had which started at 15 by entering page number+14 has changed from 15, 16, 17 etc to 24, 34, 44 etc.

When I simultaneously enter the centre and left footer with the same formular the number correctly show 15, 16, 17 etc. However if I then delete the right hand footer the centre footer changes to 24, 34 ,44. If I then delete the centre footer the right hand footer also changes to 24, 34 etc.

Please help, as I want to use right hand footer to match page numbering from word.
 

A:Excel - page numbering > 1

Read other 12 answers
RELEVANCY SCORE 77.6

I have an Excel file with several worksheets in it. Some of the worksheets are two pages, and I want to put page numbers on the second page only --- and leave the first page blank. Is there a way to do that?

Thanks.
 

A:Page Numbering in Excel

Nope. Sorry.

Unless you wanted to write a UDF of your own (example here) and manually input the formula into every page except the first. But that sounds crappy.
 

Read other 2 answers
RELEVANCY SCORE 70.8

Hello Everyone

I am having some difficulties finding a solution to my problem. I am hoping someone can help or lead me to the right direction.

I have a workbook called Data.xlsm, below is a sample:

ID, Name, commission
1 john 1000
2 eric 2000
3 ryan 3000

Now I have another excel file called Temp.xls which looks pretty much the same as Data.xlsm.

ID, Name, Commission
1 john 200
2 eric 300

I need a macro that will read the Temp.xls and grab the commissions and bring them to Data.xlsm. The commissions need to be summed based on ID.

The final Result on Data.xlsm should be as follows:
1 john 1200
2 eric 2300
3 ryan 3000

Any help would be greatly appreciated.

Thank you
 

A:Solved: Excel Macro - Upload Workbook value from Another Workbook based on ID

Just a quick and dirty solution

Make sure you place this in the same folder as your Temp.xlsm file and press the button

It will open Temp
update the data, if a new Id is in Temp it will add the data and set the commission values in Temp to 0 to avoid running it twice.

I hope the code explains itsefl.

Think of a macro of a step by step instrcution as you would say it out loud.
 

Read other 3 answers
RELEVANCY SCORE 70.4

Hello,
I have a master workbook with 20 worksheets. 5 worksheets in the worksbook are distributed to field reps, but the remaining 15 worksheets are not. What is the best practice for receiving the 5-worksheet workbook from the field rep and importing the data into the 20-worksheet master workbook? If I merely use Copy Sheet I am able to copy the worksheets into the master workbook but then I have to remove the pathname references in each of the copied worksheets in order to map the data in the master workbook - which is quite cumbersome. Suggestions?
 

A:Populating data from one Excel workbook to a master workbook

Hi jpirhalla, welcome to the forum.

Have you tried moving the sheets over. Dragging the sheet from the field reps back into the now-15-sheet book?
 

Read other 2 answers
RELEVANCY SCORE 68.8

I have two workbooks that I am using and I am trying to add one cell's data to another cell in another Excel workbook. It used to be as simple as beginning to "add" another cell's data(from another workbook you just migrate to the other workbook) into a different workbook. It isn't working like it used to in Excel 2003. Cant' speak of it for Excel 2007 as I never had it.

Any thoughts on why it won't work? Any way to make it work?

A:Excel 2010 - Workbook to Workbook Reference?

  
Quote: Originally Posted by Lewiedude


I have two workbooks that I am using and I am trying to add one cell's data to another cell in another Excel workbook. It used to be as simple as beginning to "add" another cell's data(from another workbook you just migrate to the other workbook) into a different workbook. It isn't working like it used to in Excel 2003. Cant' speak of it for Excel 2007 as I never had it.

Any thoughts on why it won't work? Any way to make it work?


Merging Data from Multiple Workbooks into a Summary Workbook in Excel

Looks like it's possible.

Also I would look at the DATA Tab under DATA TOOLS - CONSOLIDATE.

Read other 3 answers
RELEVANCY SCORE 66.4

Hello, advicer
I do not understand why sometime I cannot copy a range from a workbook to another workbook in EXCEL (but I can if i paste the range in the same workbook). My PC is in the network of the company using WinNT 4.1. Please help me
Many thanks
Qan
 

A:Excel: Cannot Copy from Workbook to Workbook

Read other 7 answers
RELEVANCY SCORE 64.8

I used to know how to do this but I have forgotten... I need to have the numbers for Section 1 (title page, TOC, etc) be like i, ii, iii, etc... and then Section 2 (Chapter 1) needs to be page 1. Nothing I've tried is working, and I know this is simple, I've just forgotten how to do it! Thank you for your help!!
 

A:Solved: Page numbering in Word 2007... different numbering for Section 1 and Section

Read other 9 answers
RELEVANCY SCORE 62.4

This question is about using "Page {PAGE} of {NUMPAGES}."

I've read many solutions for this online and in MS's help files. None of them are working, and it really has me perplexed because I consider myself an advanced user.

My document is a book:

The first page of my book is a cover page. It shouldn't be counted in page numbering.
Beginning on the second page, my book has a TOC and then 9 chapters.
The TOC and each chapter are set up in their own sections. (I do this because I include the chapter's name - which is the section name - in the footer along with page numbers. It also facilitates creating the TOC)
I want the TOC to be counted as Page 1
All of that works fine for the {PAGE} page number. To accomplish it, I told Word to start counting page numbers from 0, and I suppressed displaying the number on the Cover. Then for subsequent pages I selected "Continue from previous section."
My issue is that I really want to show both the current page and the total number of pages ("Page {PAGE} of {NUMPAGES}") in the footer.

When I try that, {PAGE} displays correctly, but {NUMPAGES} shows one too many. It is obviously counting the cover page.

Evidently what I did in #5 above only affects the count for {PAGE} and not for {NUMPAGES}.

All over the web I find the simple solution of using a formula field for {NUMPAGES} as follows:
=1+{NUMPAGES}

Actually, I think that would do the opposite of what I want. I would probably have to... Read more

A:Solved: Word 2007 Page Numbering: Make {NUMPAGES} start counting from Page 2?

I was just messing with the same issue and found a solution:

{={NUMPAGES}-1}

This may look exactly like something you tried already but here is the difference:

Instead of typing in the curly braces ( { ) manually, you have to hit "Ctrl-F9" to insert a field, then do the same for the braces around "NUMPAGES". You wind up with a field inside a field. That way it interprets the "NUMPAGES" as your document property, returns a number like "42", then the next field takes the equation "= 42 - 1" and returns "41". If you don't use "CTRL-F9" to enter the "NUMPAGES" field, it sees the first curly brace and stops, seeing it as a syntax error.

Hope it works for you! It worked for me!
-cheers
 

Read other 2 answers
RELEVANCY SCORE 62

I am knee deep in writting up my final dissertation and need some help.

I need to number my pages but not from the first page. I looked online and it said I should have an option to number pages from the page I was on but that was not the case.

I then read that you can insert an header and the page will be numbered from there, again I could not get this to work.

I know in word 2007 you can generate a contents page that will show the page number of all my subsections and headings but I have no clue how to do this and until I get the page numbers working I cannot do it anyway.

If anyone can help me please reply, I don't want to do my usualy trick of having two documents, one the body of the work and the other all the pages that are not numbered because it will take for ever at this point.
 

A:Need help making a contents page and page numbering word 2007

Read other 6 answers
RELEVANCY SCORE 62

Can anyone help with this problem that I have in MS Word 2000.

I have created a 15 page document with a Title page and a Table of Contents(TOC).

I want to do the following:

1. create a footer with the following page format - page X of Y

2. Ensure that the title and TOC page do not display the footer numbering.

The help feature in Word says a section break should be inserted to prevent a page number from displaying. It is not clear to me where I should do this as the end of TOC page already has a section break and also the Help doesn't indicate how one can prevent page numbers from displaying on two pages.

Any suggestions would be greatly welcomed.

Regards
 

A:Preventing page numbering in title and table of contsnt page

Firstly, in the footer of the required section, you'll need a custom NUMPAGES field, but you'll have to tweak it to allow for however many pages aren't to be counted. I used "-1" because I had a first section containing one page.

See attached for the syntax (NB: you can't type the brackets, they must be inserted with CTRL+F9).
 

Read other 2 answers
RELEVANCY SCORE 60.8

Hello,

I've been working on a certain workbook and everytime a try to save it an error occurs:

Microsoft Excel for Windows has encountered a problem and needs to close. We are sorry for the inconvenience.

AppName: excel.exe AppVer: 9.0.0.2719 ModName: excel.exe
ModVer: 9.0.0.2719 Offset: 002aa2b3

HELP !!!

Thanks

Mark R

A:Excel 2000 .. When saving a certain workbook excel crashes

Hi, try running a repair from control panel>click on MS office and run change or repair if I remmber correctly.

Read other 1 answers
RELEVANCY SCORE 60.4

In Word, I want to add automatic page numbering to my document. But suppose I have some X number of title pages that I don't want numbered. How can I have no numbers or headers at all on pages 1 through X, and then start the page numbering only on some arbitrary page X+1, and have the numbering offset, so that page X+1 is numbered p.1, page X+2 is numbered p.2, etc.?
 

A:How to start Word's page numbering on a different page?

a horrible question

you're wanting to use section breaks to define specific parts of your document
- have some sections without page numbers, then some with page numbers
- and the page numbers starting at a specific number on a specific page and going in order from there
right ?

see Dreamboat's webpage for some initial info.

ex:
your first section should have the unnumbered pages
your next section should have the numbered pages

you create a section break by clicking on 'insert' from the menu bar and choosing 'break'
normally use 'next page' when it asks what kind of break you want
it helps to have the option selected to show all characters, marks etc so you can see where the breaks are (tools, options, formatting marks)

you format the numbering through page numbering, also in the 'insert' section (i don't use this option)
or
through the header/footer options - you can insert a page number, insert the number of pages, or format the page number (ie where it starts etc)

this is one of the most frustrating things to master in word (in my opinion ) because it seems to have it's own logic
- once you get the hang of it, it works well

http://ca.geocities.com/jbcalg/pagedoc.htm
is a very simple example [forum doesn't allow .doc attachments)
- no page number on page one
- page number on page two, starting at 1

note: when printing, your printer sees all pages without knowing what page number you gave it
- so wit... Read more

Read other 3 answers
RELEVANCY SCORE 59.6

I have a workbook located on \\server\servershare\type2015
file name: TYPE.xlsx

how do i write the path of the table name in my query.

Any suggestions?
Thanks.
 

Read other answers
RELEVANCY SCORE 57.6

I have a wookbook with multiple spreadsheets. Each spreadsheet has two sections. How can I insert page numbers on all the sections on the workbook? I am using windows 7 operating system. Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Ultimate, 32 bit
Processor: Intel(R) Core(TM)2 Duo CPU T7250 @ 2.00GHz, x64 Family 6 Model 15 Stepping 13
Processor Count: 2
RAM: 3070 Mb
Graphics Card: Standard VGA Graphics Adapter, 3 Mb
Hard Drives: C: Total - 139633 MB, Free - 51344 MB; D: Total - 10313 MB, Free - 1 MB; F: Total - 476937 MB, Free - 467704 MB;
Motherboard: Dell Inc., 0KY768
Antivirus: Norton Internet Security, Updated and Enabled
 

A:Page numbering

You can add footer at File > Print > Page Setup
 

Read other 1 answers
RELEVANCY SCORE 57.6

I have Word 2010 and I'm trying to start numbering on page 4 - starting at 1 on page 4. I'm having trouble making the page numbers start on that page and not have any page numbers of the first 3 pages.

I tell it to start with page 1 on that page, and it puts 1-3 on the first 3 pages and 1 on page 4. It shows section 1 and section 2, then if I try to delete them in section 1 it deletes all of them.

what am i doing wrong?

besides getting out of bed this morning....

thanks!
 

A:Page Numbering W10

Found a link that may be helpful.
http://www.ehow.com/how_5831952_start-numbering-middle-word-document.html
 

Read other 1 answers
RELEVANCY SCORE 57.6

Hi all,

I putting together a A5 booklet (approx 30 pages) using Word 2007, Iím setting it up in A4 landscape, so when I print it off it has text on each side (A5), the question I have is how do I insert the page numbers under each page, so when I print it off its in the right order, currently I can only put one set of page numbers under the page, but of course require page numbers under each side, Iím also having to do the page numbers manually.

Any help and tips would be gratefully received.

Smithx
 

A:A5 page numbering

I do not have Word 2007 .
However, in 2003 to number pages
1.Select View/Header and Footer and place cursor where you want numbers to be
2 From the drop down box change option from "Select auto text" to "Page X of Y"

Pedro
 

Read other 1 answers
RELEVANCY SCORE 57.6

Client has SharePoint 2010 project server.
When the user clicks on a Excel file, the file open in the browser and when the user click on "open in Excel" we receive the below message 
"To open this workbook, your computer must have a version of Microsoft Excel installed and your Web browser must support opening files directly from Excel in the browser."
Below is the browser version 


However when the same is tried/accessed through a browser deployed on a dev machine, it works normally. Below is the version of the IE on the DEV server

What is causing this to happen?
Is there any tool to check the difference between the IE settings on my Desktop and the dev box.

Satyam....

Read other answers
RELEVANCY SCORE 57.2

This is driving me crazy! I just got a new computer with Windows 10 and Office 2016. I'm numbering entities in Excel and find that as soon as I hit row 100, the count goes back to 1. I want the row count to be what it is 101, 102, etc instead of 1, 2, etc. There is probably an easy way to fix this but I can't find it.
 

Read other answers
RELEVANCY SCORE 57.2

I have a document with several sections. The first 2 pages are not numbered. The TOC is numbered Page i, Page ii, Page iii, etc. Then in the next section I would like Page 1 of (number of pages remaining in document. So the whole document is 80 pages, but I want the footer to include Page 1 of 77. On other thing to note is that I have "Even/Odd" footers, too.

I have tried the formula with the Cntr F9, but that gives me a syntax error.

Here is the formula that I have tried.

{={NUMPAGES}-6}

I have also tried to just use QuickParts SectionPages, but that only adds up the pages in a section. I want all the sections to add up with the exception of the first 2.

Can you help?

MK
 

A:Word Page Numbering HELP!!!

Read other 9 answers
RELEVANCY SCORE 57.2

I am entering page numbers for my document and I want to add the chapter number with the page number, e.g., 1-1, 1-2, 1-3, etc.; however, even though the information in the "Format Page Number" area is correct, it only prints the page number without the chapter number, e.g., 1, 2, 3, etc. Do you know what might be wrong and how can I fix the problem?

A:Page Numbering Problems

I'm assuming you're referring to Microsoft Word. If so, this article describes the process and why the author recommends against it: I want to include the chapter number with the page number in the Header - how can I do this?

Read other 2 answers
RELEVANCY SCORE 57.2

how do i get MS Word to insert page numbers, but to skip the first 2 pages .... i can get it to skip the first page, but not the first 2. i tried doing it manually, but doesn't work.

and on the 3rd page (1st 2 are skipped), I need it to start at page 1 ....

anyone?
 

A:page numbering in MS Word

Insert a section break at the end of the 2nd page. Then start the numbering from the beginning of the new section.

Rgds,
Andy
 

Read other 3 answers
RELEVANCY SCORE 57.2

I have found and tried MANY suggestions for numbering a booklet that I am preparing.
So far, none have worked. I don't need anything fancy, just plain numbers in the lower right hand corner of each page. I have a cover page with one blank page following. I can not get numbers on any page. I am very frustrated.
 

A:Page numbering for booklets

Read other 8 answers
RELEVANCY SCORE 57.2

Is there a way to include in the footer of a document the total page number of the document minus the first 3 pages. For example: I don't want to include the first 3 pages because they are a table of contents. I have many section breaks in this document of over a hundred pages so entering the field sectionpages doesn't give me what I'm looking for. Is there another field that might exist to include the total number pages of many sections but not the entire document?

Thank you!
 

A:page numbering in word

You didn't mention which version of Word you are using, but my reply applies to 2003 and 2000.

I write novels using Word 2003, and I insert Section Break after the title page to start the page numbering of the new section. Then, after accessing View/Header or Footer, I type in my last name/title and close. Next, I click on Insert/Page Numbers and indicate where I want them to appear, that I don't want the first page of the section numbered and -- this is important to you -- click on FORMAT. Down at the bottom, click on Start With (which deselects Same as Previous Section) and confirm that the appropriate page number appears or change it to whatever you need. Click OK and OK to get out, and your section and page numbers should work for you.

Let us know if this fixes your problem.
 

Read other 1 answers
RELEVANCY SCORE 57.2

I need to suppress page numbers from 4 pages in different locations in a Word document. The document has 479 pages in all. I had to insert these 4 pages into the existing document. So that I do not have to re-page number the entire document I want to leave these 4 pages without page numbers. My first insert page is after page 192 and I want the page that follows this insert page to stay as page 193. Is there a way I can do this without redoing the entire document. I have the page numbers as footers. Thanks, gambergirls
 

A:Page Numbering in WORD

Hey Gambergirls

Does the page have to be included in the document file?

If not the non-technical way of doing it would be to insert a blank page into the document where you need the insert and create the insert in a new word file, without page numbering!

Hope it Helps!

Rutter
 

Read other 3 answers
RELEVANCY SCORE 57.2

I use Word 2002.

How do I format page numbering in a document that has

- a title page, for which I want no page number,

- a few pages of table of contents, for which I want Roman numbers starting with ii, and

- the rest of the document for which I want Arabic page numbers displayed as page x of y, centered on the footer, with x starting at 1 and y being the total number of Arabic numbered pages (i.e., not counting the title page and table of contents)?

I tried inserting a section page break at the end of the table of contents pages, then using the header/footer pagexofy insert, formatting the first page as number 1 and manually replacing the total number of pages, but the table of contents pages stil showed as Arabic numbers.

Thanks!

A:Page Numbering In Word

There is no automatic way to do that. You can set a different first page, but the i ii iii is the killer. Im pretty sure office 2007 can do this, but Ive never seen anyone do it with 2k.

The simplest way would be to have 2 different documents. First one has different first page with no header, then the i ii iii numbering, and the second document has the page x of y numbering.

Its View->Header and Footer.

Billy3

Read other 2 answers
RELEVANCY SCORE 57.2

Hi, anybody offer any advice with a word document.
I have around 100 pages with section breaks and different page orientation.
Its fine until page 50, I move to the next page and it says page 52.
With it the Page 1 of 100, etc moves from page 50 of 100 to page 52 of 100.
How can I get it to show me page 51? Tried everything I can think of.
Thanks.
 

A:Page numbering in Word

Hi mrbud,

You say that you have tried everything so maybe you have already covered this!

Have you switched on show formating marks (the funny button symbol to the left of the zoom control)?

This would show you where you have section breaks, page breaks etc.

Looks like you have an extra page break that needs removing.

lol
Hew
 

Read other 2 answers
RELEVANCY SCORE 56.8

I have two workbooks I'm trying to combine in a VBA macro. The first excel spreadsheet is just simply a sheet of 30 columns of data and 5k rows. It adds a new row every day.

The second sheet will be the model with the macro. I would like to write a script that will use a sort of vlookup to the data sheet to pull in specific parts of the datatable instead of searching through the whole big sheet.

For example, see attached. The Model tab lets you input a date or dates in the C column and then it would have to somehow search another WORKBOOK, not within this one as the example shows (for simplicity). Any ideas would be much appreciated.
 

A:Call Excel Workbook in VBA

Read other 9 answers
RELEVANCY SCORE 56.8

Hi,

I am working on an Excel 2002 report. I need to be able to create a copy of the workbook, strip it down a bit (for uploading purposes), and let the user save it as he/she pleases.

Is it possible to make an active copy of a workbook without saving it?
Excel VBA help is not being very "helpful" on this matter.

Thank you,
ABentsionov
 

A:Copy Excel Workbook

Hello, welcome to the board!

It is always best if you work from a saved file. This is just generally a good idea. Is there a reason you do not want to save the workbook? You need to save to do what you want. There is a way, but it is more convuluted than just saving your file.
 

Read other 3 answers
RELEVANCY SCORE 56.8

My O/S is Windows Vista and I am running M/S Office 2000 Professional. In the past when using Windows XP I have been able to change which workbook opens when I open Excel. Now with Vista, I have designated 2 different workbooks to open when Excel begins however I cannot delete them form the Excel XLS folder. When I delete them, the screen shows that they are gone however when I strat Excel afterwards, they are back! How can I dlete them and install a new workbook. The standard process shown in the Excel help files is not working. Thank You.
 

A:Excel Startup Workbook

Closing duplicate...........replies here: http://forums.techguy.org/business-applications/672809-revise-excel-startup.html
 

Read other 1 answers
RELEVANCY SCORE 56.8

Howdy, kinda new here. Anyway, I've got a doozy I can't seem to figure out. We just installed dual-monitors and now Excel is coming up saying "Not enough resources to display completely." It does this even when Excel is just started, with the blank, new workbook. There doesn't seem to be any screen real-estate issues since there's now double the screenspace. Any thoughts or ideas to try would be greatly appreciated.

-Ted
 

A:Not enough resources for Excel, even with a new workbook.

Read other 13 answers
RELEVANCY SCORE 56.8

Hi there

Sometimes I click on the X to close the workbook and I accidentally press NO when the computer prompts me to save the workbook since it usually comes up in a yellow box that does not really capture my attention. This usually happens when I'm in a hurry or late at night when I'm half asleep. Is there some code that makes a message box pop up with a message that says in big bold letters "YOU FORGOT TO SAVE YOUR FILE" when I click on the X to close the workbook? If so, this will save me a lot of headackes.

Mario
 

A:Save Excel workbook.

I am no guru, however I did find this in the hep wizard of MS Excel. Hope it is of some help to you.

Save workbooks automatically as you work
On the Tools menu, click AutoSave.
If the AutoSave command is not on the Tools menu, you must install the AutoSave add-in.
How?
Select the Automatic save every check box.
In the Minutes box, enter how often you want Microsoft Excel to save workbooks.
Select any other options you want.
 

Read other 3 answers
RELEVANCY SCORE 56.8

I have a shared workbook that when some people open it the formatting does not show the same. Example I have hidden columns, but they don't see them hidden
 

Read other answers
RELEVANCY SCORE 56.8

Hi,

I am using Office 2013. I have a workbook which has to be shared. I want to protect it in a way that none of the options can be changes (like I have enabled 'track changes'. 'highlisght changes from users' etc). I do not want that someone turn off the 'track changes' option or as a matter of fact any other option.

They, however, should be able to edit the workbook. Is it possible?

I tried searching but could only see an option to protect workbook structure but noes not protect options.

-regards
 

Read other answers
RELEVANCY SCORE 56.8

I created an Excel workbook to monitor my investments. One of the work sheets contains a long column of currency values from an annuity investment with each row showing daily values.

Presently, I manually copy the daily value of that investment and paste it into worksheet # 2 that contains all of my investments. Worksheet # 2 daily refreshes, updates and totals all investments.

My question is this: is there a formula that would automatically copy and paste the daily annuity values from worksheet # 1 into worksheet # 2 without having to manually copy and paste? If so, could you please guide me through the steps to accomplish this?

Many thanks for your prompt attention and cooperation.
Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Professional, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM)2 Quad CPU Q8200 @ 2.33GHz, Intel64 Family 6 Model 23 Stepping 10
Processor Count: 4
RAM: 4028 Mb
Graphics Card: NVIDIA GeForce 9800 GT, 1024 Mb
Hard Drives: C: Total - 476837 MB, Free - 414208 MB; D: Total - 114439 MB, Free - 21161 MB;
Motherboard: Intel Corporation, DG43GT
Antivirus: avast! Antivirus, Updated and Enabled

<edited by moderator (etaf) to reduce font size - not required default forum font size is adequate >
 

A:Excel investment workbook

Read other 9 answers
RELEVANCY SCORE 56.8

When I attempted to save an Excel workbook, I couldn't because the file name had changed to a number. What should I do?
 

A:Can't Save Excel Workbook

Read other 7 answers
RELEVANCY SCORE 56.8

I have an Excel (2010) template from which I need to create separate workbooks for our range of ocean-going vessels.

Requirement 1
Upon loading the template, I need to prompt the user to enter the name of the vessel.

Requirement 2
The name must be transferred to a particular cell, probably A1, in proper case.

Requirement 3
I then wish to save the workbook using the vesselís name, in capitals, followed by a space, a hyphen, another space and then the rest of the filename Ė based on the name of the template.

Example 1: name of template Record of voyage.

Example 2: name of workbook OCEAN TRAVELLER - Record of voyage.

Any thoughts?

 

Read other answers
RELEVANCY SCORE 56.8

I write a few macros for other users, and right now I just request that they rename the workbooks each month (or however often they run it) to the same names and then offer a reminder at kick-off. Something like:
Code:
If MsgBox("Are the workbooks saved as 'Workbook_1.xlsx' and 'Workbook_2.xlsx', and are they both open?", vbYesNo) = vbNo Then
End
End If
Windows("Workbook_1.xlsx").Activate
Range("a3").Select
Etc, Etc
Otherwise, I don't know how to make changes or run actions based on workbooks whose names might change. But is there a better way? I've had some people - those least familiar with automation - forget to rename, ignore the message, and then call with problems. Perhaps there's a way, instead, that asks them to name as variables whatever the sheets are called, though this might require some hand-holding, such as a list of what workbooks are open? I don't know. I'm open to suggestions - just putting it out there.

Thanks!

Windows XP
Excel 2007
 

A:Excel VBA: Prompt for workbook?

Read other 10 answers
RELEVANCY SCORE 56.8

Tech Support Guy,

I have a question regarding linking two Excel (I am using Office 2003) workbooks and varying worksheets.
Here's what I want to do, using a macro, create a link to a cell in workbook A/worksheet X to workbook B/worksheet X (where X is variable).
Now creating a link is easy, except I want the "link" itself to appear in workbook A.
I tried the following:
Workbooks("Workbook A.xls").Worksheets(Worksheet A).Cells(6, 4).Value _
= Workbooks("Workbook B.xls").Worksheets(Worksheet A).Cells(57, 3).Value
However, Excel places the value instead of the link in the cell. I want both, meaning, you see the value in the cell, but when you highlight the cell, you see the link to the 2nd workbook.

I have also tried the the following:
Workbooks("Workbook A.xls").Worksheets(Worksheet A).Cells(6, 4).Value _
= "='[Workbook B.xls] Worksheet A '!R57C3"
This gets me what I need except as I mentioned, the worksheets vary and I have not been able to figure out how to do use a variable worksheet name in this example.
I appreciate your help in solving this problem
Take care,
RJ
 

A:Excel Workbook Question

See if using the indirect function is the solution?
 

Read other 1 answers
RELEVANCY SCORE 56.8

Hello guys.
Please guide me through building my own tool in Excel.
I need to have workbook WK 1 with macro to modify another workbook WK2 which already have macros in it.
That is my plan : WK1 should have several command buttons first is to find person by ID from WK 2 , copy entire row with persons details to WK1 list 1, another button same but copy entire row to WK1 list 2, than when both lists created, I must have third command button which will : for each person in List1 WK1 will change value in cell 1 in WK2 from none to 1 and cell 10 enters =today date, for each person in List2 WK1 will delete value in first cell of the row in WK2.

I am keep loosing the track of what would be most simple way to do those steps, WK 2 file name is changing every day with date in beginning of the name of file,
 

A:Need help Excel 2 modify other workbook

Read other 13 answers
RELEVANCY SCORE 56.8

I just got a new computer and bought Excel 2016. I'm very happy with both but am frustrated because I sell books on Amazon and have to list them. When using Excel 2007, once the listings went over 100, they would continue to number 101, 102, etc.
 
However, with Excel 2016, once I go past my 100th row, the rows start numbering at 1,2, 3, etc. again and it's driving me crazy. If I have over 400 different items, I'll have 4 different sets of 100 items and they won't be numbered sequentially. This makes no sense at all as a default.
 
In any case, I am sure there's a simple way to get consecutive numbering to exceed the 100th row but I can't figure it out.

A:Excel numbering starts over again at 100

Try this on a blank sheet first. Type 1 to 4 in consecutive rows. Highlight the cells from 1 to 4. In the bottom right corner is an anchor. Left click and drag down until you get to 400 or more. 
 
https://support.office.com/en-us/article/Automatically-number-rows-in-Excel-2016-for-Windows-598f6fb5-a5dc-4474-af7a-6cce5559ad92

Read other 6 answers
RELEVANCY SCORE 56.8

I just got a new computer and bought Excel 2016. I'm very happy with both but am frustrated because I sell books on Amazon and have to list them. When using Excel 2007, once the listings went over 100, they would continue to number 101, 102, etc.
 
However, with Excel 2016, once I go past my 100th row, the rows start numbering at 1,2, 3, etc. again and it's driving me crazy. If I have over 400 different items, I'll have 4 different sets of 100 items and they won't be numbered sequentially. This makes no sense at all as a default.
 
In any case, I am sure there's a simple way to get consecutive numbering to exceed the 100th row but I can't figure it out.

A:Excel numbering starts over again at 100

Try this on a blank sheet first. Type 1 to 4 in consecutive rows. Highlight the cells from 1 to 4. In the bottom right corner is an anchor. Left click and drag down until you get to 400 or more. 
 
https://support.office.com/en-us/article/Automatically-number-rows-in-Excel-2016-for-Windows-598f6fb5-a5dc-4474-af7a-6cce5559ad92

Read other 6 answers
RELEVANCY SCORE 56.8

I am trying to number the first column by 10's for example the #1 is in rows 1-10, the #2 is in rows 11-20 and so on. Is there an easy way to fill it in or do I have to fill it in manually using the fill down?
 

A:Excel Numbering Question.

This isn't 100% but will do most of the work.

With 1st number in A1, 2nd number in A11, whatever you like in A21.

Select A1:A21. Press F5, click Special, check Blanks, click OK.

Type =A1, press CTRL+Enter.

Reselect the range, copy and paste special (values).

Time for bed. Rgds,
Andy
 

Read other 2 answers
RELEVANCY SCORE 56.8

Hi all
I need to number a large amount of cells. is there anyway you can highlight 200 cells in a collum and then automatically number them from 1 to 200 in one go.
Thanks in advance for the help.
 

A:Numbering cells in excel

Read other 6 answers
RELEVANCY SCORE 56.4

I am trying to write a macro that will allow me to print either only the first or second page of the 30 or so Sheets I have in an open workbook. I found how to print the second page of an open sheet and how to print all pages of the workbook but I need help combining the two! I am using this for activity sheets on the first page that are printed at the beginning of the week and the time cards on the second that are printed at the end.
 

A:Printing every other page of an entire workbook

What spread sheet program and version are you using?

What printer and model are you using?
 

Read other 3 answers