Next sequential number on a different form
Is there a way to do this:
I have a form called "List of Proposals Written" that is listed by th
Is there a way to display on another excel spreadsheet, the mos
current Proposal number?
I know Access you use something like Dmax(ProposalID)+1
What should I do in Excel:confused:
Any help would be greatly appreciated!
Message posted from http://www.ExcelForum.com
"daniels012 >" <<firstname.lastname@example.org> wrote
> I have a form called "List of Proposals Written" that is listed by the
> Propos...numbering rows, but skipping blanks
I'm using Column A of a spreadsheet to number some items in Column B.
I've been using Excel's automatic series-filling function, where you
drag down from the lower right corner of a cell. However, since some
of the rows in Column B are empty, and I don't want them numbered, I
have to stop numbering and manually "jump" over the blanks in Column
A. Is there a way to automatically number down in Column A, while
skipping over the blanks and continuing where I left off? I.e.
? Thanks much.
Try this in A1:
Try going to File/Page Setup/Header-Footer/Custom Header/Should be the
button shown in the header box with the # sign in it.
keithl816's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21287
View this thread: http://www.excelforum.com/showthread.php?threadid=498476
I am trying to automatically print sequential numbers on individual
cards on 8.5" x 11" business card stock (to create tickets) using MS
Publisher and cannot figure out how to get it to do this. Does anyone
know the secret? Thanks.
Hi Scott (email@example.com),
in the newsgroups
|| I am trying to automatically print sequential numbers on individual
|| cards on 8.5" x 11" business card stock (to create tickets) using MS
|| Publisher and cannot figure out how to get it to do this. Does
|| anyone know the secret? Thanks.
Check out the following tutorial:...Controlling Sequential Numbers
I have been researching using sequential numbers for invoices an
purchase orders, but all of them seem to advance the number eithe
every time the document is opened or saved. My purchase order is par
of a larger file, and since I will be opening and saving the fil
without necessarily writing a purchase order I need more control ove
its advancement. I was wondering how I could create a button that whe
pressed or selected would advance the number by 1? Also, how could
make it create a unique number depending on who's creating the purchas
order. For example, let's say the user is ...HELP!! Trying to convert numbers.
Here is my problem.
i have a series of 3 digit numbers that
need to be cinverted to a series of 4 digit
numbers using this following
722 needs to read as 5622 and in the next collum SV-7822
in the collum's to the right.
what type of formula is this and how can i do it?
The above is an example, i have a whole range of 3 digit numbers
that need the exact. rules applied to all numbers.
which is why i need a formula to do it.
Help someone please!!!!
I'm not completely clear on what your looking for but if 722 was in A1
in B1: = A1 + 4900
in B2: = ="SV-" & A1 + 7100...What is the max number of...
What is the max number of records that can be put into a table in Microsoft
Access? Does it vary from version to version? Thanks in advance.
"Mike C" <MikeC@discussions.microsoft.com> wrote in message
> What is the max number of records that can be put into a table in
> Access? Does it vary from version to version? Thanks in advance.
Google or the online help would be your friend on this one. There's no
fixed limit, there's only the limit on the overall size of the database
file...Find missing sequential numbers
Hello, I'm looking for a way to quickly find what numbers are missing in
column B. I can sort them ascending, but how do I find if there are missing
I need to know 4 and 8 are missing.
select B2:Bx. Choose Format/Conditional Formatting...
CF1: Formula is =(B2-B1)>1
Format1: <pattern>/<some color>
or, without sorting, select column B (with B1 active):
CF1: Formula is =AND(B1>MIN(B:B),COUNTIF(B:B,B1-1)=0)
Both CF's will activate if there are missing numbers before them.
In article <28706E9E-2624...maximum number of worksheets in Excel 2000
Can anyone tell me what the maximum no. of worksheets is in Excel?
From Help...Limited by available memory (default is 3)
Microsoft MVP - Excel
"Ton" <Ton@discussions.microsoft.com> wrote in message
> Can anyone tell me what the maximum no. of worksheets is in Excel?
The maximum number only depends on the amount
of memory available.
Followup to newsgroup only please.
"Ton" <Ton@dis...Varying numbers against conisistent ones
Hello! I would like to chart varying salaries against
specific Low, middle and high numbers.
Any suggestions on how to show this? Example:
Salary 1 10000
Salary 2 12000
Salary 3 16000
Do you want the Low-Mid-High values to be like a benchmark to measure
salaries against? You could put horizontal lines across your chart, and
use markers for the salary data. Here' a few ways to get your lines:
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials...Maximum number of rows in a excel 2003 work sheet
As a new user to excel I am thinking of setting up a data base of my music.
The total number of tracks is in excess of 70,000. I have seen a simple
solution using excel which would be ok but I'm not sure if I can have 70,000
rows in one work sheet. A friend has suggested access which I am not
familiar with and don't know if this will allow 70,000 entries. Can anyone
please tell me what the maximum numbers are in both access and excel 2003.
Max in Excel 2003 is 65536 (in one sheet) whereas Access only limit is your
...Page Number as watermark.
I have a file that displays the text "Page 1" in the center of the worksheet.
I have not been able to find a way to stop the page number from displaying.
There is no header/footer, no "background", no other special items that I
could find that would force the display of this.
It does not appear during the printing so it's not a "watermark". It merely
displays in my view when I'm working in the worksheet.
you're in page break preview view ... choose view / normal from the menu
"whalenohana" <whalenohana@dis...Sequential number in a query
I am working on a YTD Sales report. I would like to know if I can create a
cell in a query that will be a squential number. Starting with 1 on up. If so
how would I do this?
Report would look something like:
Num Customer YTD Sales
1 Bobs Sales 495,000
2 Denny's 395,000
3 Biffs Supply 390,000
mattc (at) saunatec [dot] com
Message posted via http://www.accessmonster.com
You can use a text box in the report:
Control Source: =1
Running Sum: Over All
Microsoft Access MVP
"mattc66 via AccessMo...Change default numbering
How do I set up the basic template for text numbering in Word 2008 for the
Mac? Here is what is driving me nuts:
I want to generate numbered lists - lots and lots of them. The first level
numbered lines will have second level under them in many cases, also numbered
and indented below the first level. The second level will also have third
level under them, intended some more and also numbered.
This "sort-of" works fine. It USED to work excellently. Here is what I do.
I click the Numbering button in the Bullets and Numbering palette. The line
indents and a 1) is aut...Page Numbering #2
Is there a way to have page numbering span multiple worksheets in a file? I
would like to be able to print all the worksheets in a file and have the
page numbers in the second worksheet pick up where the page numbers in the
first worksheet ended without having to manually adjust the start point in
Please response back to the group.
I assume the page numbers are set up in your header/footer.
If this is correct then all you need to do is select all the sheets you
want to print by clicking on each sheet tab while holding down the
This will the...Formatting phone numbers in Outlook 2003
Does anybody have a way of formatting the phone numbers in
Outlook 2003 so that they appear as xxx yyy zzzz that is no
dashes, no parentheses?
If I am going to synch to my PDA I want the numbers as
short as possible and, to me, as readable as possible.
No. Masking of phone numbers is hard coded and based on your default dialing
"Steve E." <firstname.lastname@example.org> wrote in message
> Does anybody have a way of formatting the phone numbers in
> Outlook 2003 so that they appear as x...Make positive number negitive
Budget is our income and sometimes this is positive. I need to make this
column in a query all negitive values.
I am using the IIf function but it is not working.
Budget: [budget_amount] IIf ([budget_amount] >=0, [budget_amount]*-1,
or is there another function I could use?
On Mon, 29 Oct 2007 19:18:00 -0700, Tamm Fox wrote:
> Budget is our income and sometimes this is positive. I need to make this
> column in a query all negitive values.
> I am using the IIf function but it is not working.
> Budget: [budget_amount] IIf ([budget_amount] &g...Precis Numbers
A3 is the result of A1/21
I want to bracket the number in A4
In MSWorks I would type the statement
In excel I get in some cells [1.436871259834]
I'd like it to read 
(Remove gum to reply)
MS Excel MVP
"Rodney" <email@example.com> wrote in message
> A3 is the result of A1/21
> I want to bracket the number in A4
> In MSWorks I would type th...how to insert page numbering in an excel cell
I'm trying to have a repeating cell automatically update the page number and
number of pages, much the same as in a header/footer situation, but I need it
to be done in 1 cell. Any suggestions?
I want to a sequential number to fill in automatically each time the form is
A simple way would be to use something like this, you could assign it to a
button, an open or before print event.
Sheets("Sheet1").Range("A1").Value = _
Sheets("Sheet1").Range("A1").Value + 1
For other ways to do this or if this is going to be used in a temple have a
Always backup your data before trying something new
Please post any response to the newsgroups so others...Restart check number
we have printed AP checks using the check number from 0000000001 to
0000000006, but we havent posted those batches. we have only one checbook.
Now can we restart the check number from 000001. Then do we need to delete
the previous batches for checks printed. What is the best approach in this
Thanks in Advance,
In the Post Payables Checks batch window (Transactions > Purchasing > Post
Checks), choose the batch in question, then select Reprint Checks from the
drop-down list. Enter 000001 for your starting check number. You will also
need to go ...Number of E-Mails
is there any limit on the number of E-Mails ? I created an archive of 270000
E-Mails (IMAP) and it caused trouble.
Can I have that amount in a local folder ?
Are there any recommended number ? It locked that 50000 starts being a
problem on IMAP already.
How else would you handle an archive that you need frequently ?
Thanks for your help
If it were me... exporting them(selectively) to user created properly named Windows Explorer blank folders on the hard drive and
backing up to a different drive(internal/external/cd/dvd) outside of Windows Live Mail woul...Number Auto
I am creating a process map in Visio, is it possible to
get Visio to number my boxs on my flowchart. At the
moment I create the shape, put the text in but I have to
manually put the number before the text, can visio do this
In Visio 2003, try Tools > Add-ons > Visio Extras > Number Shapes. The same
feature can be found in previous versions under Tools > Macros.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Glenn Robertson" <firstname.lastname@example.org...Problem Sequentially Numbering Records
Hi everybody. I am having a problem with a query that I am working
I have a table containing customer names, trade dates, and dollar
amounts. Customers can have multiple trades on the same day,
sometimes even the same dollar amount. I want to have the table
sorted by name, date, then dollars so the query pulls everything in
from lowest/earliest to highest/latest.
I was trying to make a query that pulled in the customer name and
trade dates, then added a new column called "Row" that had the record
number. I want the query to show all names and dates, since there are
...How do I save number of copies to be printed?
I need 2 copies to be printed each time I print from a certain file. Is
there any way to save this command so I don't have to change the number of
copies each time I print?
you could record a macro while doing this manually and assign a
shortcut or button to this recorded macro
> I need 2 copies to be printed each time I print from a certain file.
> Is there any way to save this command so I don't have to change the
> number of copies each time I print?