I'm making an order form and I want specific cells to ALWAYS display their contents in caps regardless of how text is entered, is there a way to do this? I looked all through formatting and could not find the option, I found the command for =Upper but that doesn't work if you put it in that same cell then type over it obviously.
is there a way to use an =upper command that'll make an entire block always print in caps?
when typing in a cell in excel, I sometimes need to put my initials in lower case at the end of a comment, indicating that I have responded in that cell. When I do, the first of my two initials changes to a capital instead of lower case. Can anyone tell me where to turn this feature off?
View 9 Replies View RelatedI am having problems with auto capitalization of words. I want to be able to enter words into a cell and have it auto capitalize in proper grammer ie: Name, the, or, and, 's. The problem I am having is that every word gets capitalized along with the 's.
View 2 Replies View RelatedI have a table array which shows me that amount of each I have in each spot.
What I need is a warning to auto popup when it reaches a certain number.
I need this for many different cells.
So if cell m20 changes from 3 to 2 it should popup and say only two xx are available and keep going down from there.
Is there a way to format a cell such that regardless of whether or not an upper case alpha character is entered, the character will appear in upper case?
View 9 Replies View RelatedI have 40K asset list with different Capitalization dates, the depreciation will start either in the mid month, mid qtr or mid year (determined by dep key)
The goal is to come up with a accumulated depreciation up unitl 12/28/08.
The problem I`m running into is getting the depreciation start date (due to different years)
This is what I`m doing right now:
ie. asset cap date 12/5/2004
1. extract month: Dec
2. Extrac year: 2004
then I have table that says if the Month is Dec then the depreciation should be 12/15. However, when you enter 12/15 excel automatically adds in 2009. How do I replace the 2009 with 2004 ?
I've noticed that when one pick up a value (word) from a cell in excel and try to use it in a form that it needs to be exactly the same (e.g. if a letter is capitalized in the cell, and not in the form, it wont be recognized as the same). So i was wondering if there is a command that one can type so that the form doesn not read the word for its capitalization but for the letter in it.
View 5 Replies View RelatedI have a row of addresses - each was typed by users on website.
examples:
po box 1451 (would like to see: PO Box or P.O Box or P.O. Box)
PO box 427 (same here)
1735 park st. (would prefer 1735 Park St.)
I have a column which consists of different dates. Some dates have a letter behind them (12.6.K). When I sort them they don't come in order because of the letter.
View 9 Replies View RelatedName They are all QC(Quality Control) then Rank
In cell A1:
Anderson, Bob QC, Top Gun
I need in B1:
Anderson, Bob
In C1:
Top Gun
What could I use to get these results? The QC, is consistant every time in each set of text.
I am trying to create an invoice but the invoice show #N/A in certian columns when there is no number which already have formulas, how do I modify them using the if function?
View 9 Replies View RelatedIm looking to clean up the way the code is writen.
It Cheeks for cell value if correct then paste data onto another sheet then cleans certin cell values.
Here's what I want it to look like:
Here's Macro Code I have thus far: ....
I have the following code:
[Code] ....
When I run the macro, some columns are already hidden. The macro doesn't seem to autosize cells correctly. For instance, one cell in a row appears to have some contents hidden (or below the reading area of the cell). In other instances, the rows are auto-size to huge heights and widths.
I am trying to write a formula that will do multiple IF statements checking to see if words are written in certian boxes and if so to do certian things and I need help, never done multiple IF statements in one formula before and can't find anything in the books I have or on the web.
= IF(D30 = "Oceanic",
IF(D35 = "Yes",
Both True
(((D32 * 4) + (D33 * 5) + (D34 * 9) + D31) * 0.15) + ((D32 * 4) + (D33 * 5) + (D34 * 9) + (D31 + 4500)),
Oceanic = "Oceanic", D35 = "No"
(((D32 * 4) + (D33 * 5) + (D34 * 9) + D31) * 0.15) + ((D32 * 4) + (D33 * 5) + (D34 * 9) + D31)
Oceanic = False, D35 = "Yes"
((d32 * 4) + (d33 * 5) + (d34 * 9) + (4500 + d31))
Both False
((d32 * 4) + (d33 * 5) + (d34 * 9))
=======================================================
I got:
= IF(D30 = "Oceanic", IF(D35 = "Yes", (((D32 * 4) + (D33 * 5) + (D34 * 9) + D31) * 0.15) + ((D32 * 4) + (D33 * 5) + (D34 * 9) + (D31 + 4500)), (((D32 * 4) + (D33 * 5) + (D34 * 9) + D31) * 0.15) + ((D32 * 4) + (D33 * 5) + (D34 * 9) + D31), ((d32 * 4) + (d33 * 5) + (d34 * 9) + (4500 + d31)), ((d32 * 4) + (d33 * 5) + (d34 * 9))
I am very new to vba and trying to figure out an auto save macro that will automatically save my workbook when a certian cell range is changed. Right now I have a macro set that automactially record the time and date of when a change is made to the name cell, I want to set up a macro that will automatically save the file when the time is updated.
This program is used by several users and they have a tendnecy to forget to save the program so that when other people want to check the updated data nothing has changed because the changes have not been saved. I have attached the file that I am working on. When a change is made in column F then Column G automatically updates, now I want column G to trigger autosave. I would also like a msgbox to appear to tell user that file has been saved.
What is the formula for results in C?
A | B | C
NAME|RNK|SORT
Frank|2|David
Jane |3|Frank
Lisa |5|Jane
David|1|John
John |4|Lisa
Abby |6|Abby
My sheet goes from monday to friday on the coulombs. On the rows i have various data sections for each day. I would like the data on the last day (any day after monday) that there is data for a sheet to input that data into the monday slot when the "master date" is changed on the cheese sheet. The idea here being that the script will take the last entered data for a given sheet, and put it into the monday coulomb on the same sheet when the date is changed. This is kind of hard to explain so if you need clarification let me know. Attached is the sheet i'm working with.
View 14 Replies View RelatedIs there some feature that lets you auto number cells? IE (1-20) Instead of me having to manually type in 1-20 in each cell or making my own formula up to do it.
View 3 Replies View RelatedWorking with 2 worksheets in the same spreadsheet. In worksheet A cell F6 is a solution (hex2dec) these solutions are staggered consistently in column F (F6, F9, F12, F15 etc) In worksheet B cell A2 displays workshop A cell F6 details (=ATR!F6)
Worksheet B cell A3 Autofil uses (=ATR!F7) I want (=ATR!F9) Worksheet B cell A4 I want (=ATR!F12) How do I condition autofil to follow my chosen sequence ie F6,F9,F12,F15 etc...
I have been tasked with coming up with a solution to an excel issue my boss has. I'll try to explain it as simply as I can but it might get confusing.
We have workbooks containing ledgers for a retail establisment. We create a new book for each year. Each book contains a sheet per month. We also have a comparison book/sheet. Currently we have the rolling total for each line item transfer over to the comparison sheet and then manually workout and enter the data for the same day from the previous year. What we would like to do is have the data from 2008 automatically update as we update the 2009 data.
I Have a sheet with many ranges, when i push the commandbutton I need it to insert the selected cell in textbox 1 witch works but it needs to insert the full range into textbox 2, 3, 4, 5, 6. I have attached an example.
View 5 Replies View RelatedI have a workbook with three sheets:
'Activity' 'Expenses' and 'Income'
On the 'Activity' sheet I:
select the date,
select the description, and
select the category (dependent on the description using indirect)
and enter a value. ($ dollar amount)
How do I make the entered values appear automatically :
- on the correct Sheet for the Description - 'EXPENSES' or 'INCOME'
- in the correct columns (matching) the category
- and in the correct row (matching) the date,
- "add to" - if a value already exists in the cell (more than one transaction on a date)
after they have been hand entered on the 'Activity' sheet?
Every time i open my workbook it recalculates and takes ages
is there anything i can press to halt the recalculations so i can go in and change the formulas that are making it take so long.
What I'm trying to do is this:
In sheet "Available", I have a list of all shirts available in store. I often make a printable shopping list in sheet "Shopping list". Once the shopping is done, I would like to automatically add the shirts bought to "Available" sheet.
I have a database in the form of a spreadsheet with the following column headings:
A=DATE (3 letter abbreviation for the month...jan, feb, mar, etc)
B=Client
C=City
D=State
E=Department
F=Contract number
Is there a formula that I can enter in another worksheet (which is being used as a report), that will "grab" the monthly data for all entries for a given month (i.e. "mar"), and auto-populate corresponding cells with each?
If I click on cell A1 is there a way to make Cells A12 and A13 highlight in yellow?
View 9 Replies View RelatedIs there a way to automaticaly highlight multiple cells if there is data in two other cells else were? What kind of programming will I have to use. I.E. highlight cells D1:E15 only if there is data in cells A:2 & B2
View 3 Replies View RelatedI tried using SUBTOTATL but no luck.
As always, I prefer without helper column(s) and/or VBA - but If not - I will, probably, have to compromise.
I have 2 drop down menus based on car make and model.
The first contains Make and the second contains the models of that make using the indirect function (All through data validation (this may be my problem))
Now what I'm wanting is that when the Make changes, the Model will automatically changes to either the top (or any really) model from the list for that make or to change to blank. So can this be done without VBA?