Lock The Lower Bound Prize
Can Anyone please tell me how i can lock the lower bound prize, rather than
the message to select. (YS or NO).
We have created a series of Utilities amongst which one of the options is to
control the Lower and Upper Bound sales. This is a paid add-on [ Store and
HQ Utility] that embeds a large number of options. Contact me for more
Afshin Alikhani - [ firstname.lastname@example.org ]
CEO - Retail Realm
= = = = = = = = = = =
"imma" <email@example.com> wrote in message
> Can Anyone please tel...Cannot delete a column
I've just upgraded to Office 2007. I'm trying to delete a column. I get
that "cannot complete task with available resources" error. I then tried to
delete a single cell, and chose "shift cells left". Same error. All I have
open is a browser to type this note, and Excel. Does anyone know what's
...Reversing a column
I need to take a column of calculated numbers and then reverse it .
I need to apply a compound interest factor. Using a 6% annual increase the
value at the end of the first year is 1.06. The next year it is 1.1236 =
1.06^2 and so on. In this example I end up in Year 40 with a factor of
10.28571794. Then I need to reverse or flip this over so that the 10.28571794
is in the first year and it ends with the 1.06 on year 40. I'm stumped and
would appreciate a helping hand.
PY Age Compound int ToRetirement Compound int
1 26 1.06 40 10.28571794
2 27 1.1236 39 9.703507488
Hi...Reseting the last row/column
I have a spreadsheet of data, lets say 35,000 rows long. So when I do
a [Ctrl] + [End], it goes to the cell at row 35,000 (and the last
column of the data).
Now lets say that I run a macro that deletes 5,000 rows. So now the
last row is 30,000. But if I do a [Ctrl] + [End] again, it still goes
to row 35,000.
Is there any way to reset the spread sheet so it knows that the last
row/column of data has changed since row/column deletions?
Thanks for any help anyone can provide,
Here is an article from Msft on the topic:
http://support.microsoft.com/?kbid=2444...To have a 'fixed cell' be equal to the last data entered cell in a column
Good Evening All,
I have a worksheet, example below.
I have frozen the panes to always show rows 1-3.
I wish the cell A3 to be the same as the last 'non-blank' cell in Column
A.(See explanation below).
2 Header Header
So in this case, at present, A3 would be M1001,(A9), but when I enter a new
value in A10, (eg M1008), I would like A3 to automatically update to A10 ie
I think that maybe INDIRECT or OFFSET maybe involved but am fairly
unfamiliar with ...One column of a list box does not display for all users.
I have a list box on a form that displays two columns of information from two
columns of a table. The main column contains material numbers and this is the
information that actually populates the box when selected. The other column
is a description that goes with the material number. On on everyone elses
computer the main column (material number) apears to be empty and only the
descriptions are displayed. On my computer the list box works fine with
everything displayed as it should be. It seems that it must be a setting, but
I cannot find one. Does anyone have any idea of what co...Fill with Gray if Column b is bold
My spreadsheet contains data from column A1 to K?. There may be 10 rows or
1000 rows. I need to look at column B and if it the font is bold then I need
to fill A:K with gray. Can someone help?
Thanks in advance,
I don't think you can but it might be worth taking a step back and looking at
how column B is populated. What is entered? How does it get there? What
makes it format bold? If it's not manual input where does the data come from
and is there anything else that can differentiate what can and can't be
...Text box referencing cell
Is there any way to put a text box on a chart and have it reference information in
a cell? I have a pie chart that breaks out worldwide volumes by division. I'd
like to put the total of all the pieces into a text box near the chart. Any ideas?
Any help is appreciated!
Senior Engineer/FedEx Express
The simplest way is to select the chart, press = and the click the cell
you wish to link to.
This should add a textbox to the chart, which you can then move and
format as needed.
Rita Palazzi wrote:
> Windows 2000
> Office 2000
&g...Last Value in a row or column
I need a formula or User Defined Function that will allow me to find
the last input cell in a row of variable width data.
This value will then be shown in a cell of my choice.
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
Hi - how about this?
Public Function Findlastcell(MyAddress As Range)
Findlastcell = Cells(MyAddress.Row, 256).End(xlToLeft).Address
You use it by entering = Findlastcell(B5) ...merge or combine columns
Is there a way to combine columns? I have a spreadsheet
with a couple thousand rows. I want to give each row a
unique identifier that has the components of a key number
(a 4-digit identifier). Some of the key numbers are the
I decided to simply add a row of sequential digits 1-2000
and merge that column with the key number:
column A = 1
column B = -
column C = 2567
Merged column = 1-2567
Is there a way to do that?
There may be other ways, but you could use the formula
=A1&B1&C1 in cell D1 to get the result you want.
&g...Followup flag time dropdown box
When flagging a message for followup, is there a way to either change
the list of times displayed or change your default start position in
the list? Ideally I'm looking to start at the 8:00 AM entry and range
through the rest of the business day.
...How to Format a Column???
How can i format a Column in order to show up negative numbers in a re
color, BUT using a MACRO..
So i want to Format this "G"Column with the option to show negativ
numbers ex: if it is -100 will show (100) in red.
Message posted from http://www.ExcelForum.com
I just did it using the Macro Recorder and then viewed the code:
Selection.NumberFormat = "#,##0.00_); _
Of course if doing it in a Macro there is no need to actually select the
Columns("...Returning Column Header based on Row and Value
I've run into a problem trying to return a value from the header row
based on locating a row value and a subsequent value within that row
to define the column header needed.
For example in the confusing example below imagine that the top row "
A B C D" is the column headers and the column 1 "A B C D" is the row
labels i've assigned. Given values of "C" and "D" I'd like to write a
formula that searches down column 1 for "C" and then looks across the
row for value "D" and returns the value of the column header &qu...bound column in combo box
My form contains a combo box that allows me to pick a particular client. In
this combo box there are five columns - the first being the bound column.
Once I select the correct record I click on a command button which should
pull up a different form filtered to this combo box selection. However, I
get an error that states "... can't find the field "|" referred to in your
Private Sub Command116_Click()
DoCmd.OpenForm "frmMain", acNormal, , Me.Cbo108.Column(0) = [ID_No]
Any thoughts on what is wrong here?
On Wed, 11 Jul 2007 10...6 numbers in one column
6 numbers in one column separated by hyphen. want to put them in separate columns
Data|Text to Columns with hyphen as delimiter.
"Edo" <Edo@discussions.microsoft.com> wrote in message
> 6 numbers in one column separated by hyphen. want to put them in separate
Try using Text to Columns,
1) Select your data
2) Data > Text to Columns
3) Choose Delimited as your Data Type
4) Click Next
5) Check Other as your delimiter and type the hyphen into the box next
6) Click OK/Finish
Hope ...automatic name finding in To: box feature
I can't find out how to make my Outlook 2000 program
automatically fill the names I type in the To: box. I
know how to do it in Outlook XP, but can't find it in
Outlook 2000. Is there a Help Book that I can download
for Office 2000 or just Outlook 2000?
Outlook 2000 doesn't have an AutoComplete feature -- it uses Auto Resolution
instead. See the following article for a description of how this works:
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please
reply only ...Creating query from other queries- dates column
I'm trying to create a query from other queries, all of which have a 'date'
column. However not all the queries have the same dates in e.g one query may
only have entries for 01/01/2006 and then for 05/01/2006 but not for any
dates inbetween these dates, although other queries may have. But the new
query seems to ignore the fact that other queries have data for these dates
inbetween and only display data for the dates that appear in the first query.
I want ALL dates that have data entries to appear, even if some columns will
have no entries (as some queries have no data f...Difference between (subtracting) 2 columns
In Excel 2003 , I want to do the following thing :
suppose we have column A with the content :
and column B with the content :
I want that column C (using a single formula) will have the content :
ie. column C will be column B , minus column A (corresponding to the
indexes of the cells : 20-12=8 , 40-14=26,
60-16=44,80-18=62,100-20=80) . How can I do that using a single formula ?
Thanks in advance ,
Select column C1 and down, as far as the data goes.
Type =B1-A1, hold CTRL while you press ENTER
Kind regards,...some font characters appear as boxes
Recently some of the font characters in Publisher 2003 have been replaced by
small boxes. Different characters are affected in different fonts, e.g., in
Times New Roman small-case "f"s are replaced, as well as italicized "!" and
symbols such as "&" and "+"
In Arial, "w" is replaced as is capital "J" - and the list goes on.
It doesn't matter whether the text originates in Publisher or Word, or if I
"Edit the Story in Word." I've reloaded both Publisher and Word, to no avail.
If I "Edit Story in Word&qu...Renaming columns #2
I'd like to rename the A B C D at the top to the name of my columns, o
at least leave the column headings at the top of my screen.
Does anyone know how
Message posted from http://www.ExcelForum.com
Tools>Options>View, uncheck "Row and column headers".
You can insert a row and a column with your own names, but they will not be
recognized in formulas the same way as "A1". But you can define row and
column names and use the intersection as an address in a formula. The
intersection operator is a space. So if you defined the name "Material" for
column ...Catalog bound on top
I am looking for a template that allows you to use a normal sheet of paper,
folded to make a book. Now I know this works for Catalogs, however I want to
bind it at the fold and have it turned with the fold at the top and open it
like a flip chart. Any suggestions. I can work it out, but the page
printout doesn't work in the booklet format.
Does your printer have this setting? It will have something like "flip pages up." You
could also use the tent card option, add as many pages as needed. Publisher will
automatically print it correctly.
Mary Sauer MSFT MVP
h...Can I reverse a column ?
Is there a way to reverse all the plus in a column into negative and the
negative into plus?
I mean a fast way, not manually all and every entry by hand.
In an empty cell, enter the number -1. Edit>Copy. Select your numbers.
Edit>Paste Special, check Multiply. OK.
Microsoft MVP - Excel
"Karl" <karolus@NOSPAMcomcast.netNOSPAM> wrote in message
> Is there a way to reverse all the plus in a column into negative and the
> negative into plus?
> I mean a fast way, not manually all and e...Combo box fill Text box
I have a combo box(officename) in a a form in which I select the office name
and I want that result to be shown in a text box. I did it but I get the id
of the office i select in the combo box (officename) and not the name.
Please help me!!
It's because when you create a combo box that uses a table or query as it's
row source it usually automatically adds the ID as the number associated with
the comboboxs pick.
So you can do multiple things to change this
1. Go in to the properties of the combobox, and go to "Bound Column" and
change it from 1 to 2.
Or if you go in ...Checking data in 2 columns against a further 2 columns....
I need to check the values of two columns agains another two colums (with
same data) and if they are both in the sheet return a positive result, or if
wrong return a "Missing Order".
A B C D
SENT Received CHECK
Account Order Date Account Order Date
123 01/12/2009 314 05/12/2009
231 02/12/2009 142 04/12/2009
314 03/12/2009 123 01/12/2009
So I need to take the info from Colum A and B (account...Cumulative Columns in Frx.
I have configured a monthly forecast based on the budgeted figures in
Frx. I have 12 columns in it and 13th one is the total of all the
I want to add a row in this report which is cumulative of the previous
Column 1 - Column 1
Column 2 - Column 1 + Column 2
Column 3 - Column 2 + Column 3
and so on..
I couldnt figure how we can do that in Frx.
Any help will be appreciated.
If you mean a "column" which is cumulative of the previous "columns"
then try this.
If first column is A and last is N then in O configure a Calc column