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 RepliesI 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'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?
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 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 need the tabs of a project action log to auto-populate and auto-delete in a master log. (So when something is added or deleted in a tab it is added or deleted on the master) I use excel a little bit for work and personal finance purposes but I have zero experience with macros or VBA.
View 1 Replies View RelatedMaking a mission tracker that requires less upkeep than my units previous methods. I am using Excel 2007 and have some things in mind that I would like it to do.
On the down side, I have only basic experience with excel and have never used macros or VBA.
Even if what I am after could be solved with functions (which I prefer), I simply do not quite know how to make what I want without assistance. Ok, now on to the description.
The mission tracker aside from showing a list of the missions we have done during our program, it needs to also generate metrics automatically. In my worksheet, I am using columns A-G and rows 1-501.
The mission scheduling type in Column E are listed below. The letters on the left are what I am using in the sheet, the part to the right is what it really means:
Column D has the day of the week listed as: Mon, Tues, Wed, Thurs, Fri, Sat, Sun.
now the metrics I need to be generated are the number of different types of each mission compared, how many of each type of mission was flown per day of the week, how many of each type of mission was flown per month.
Basically what I need is a way to automatically count the number of rows that meet a specific criteria throughout the range. This would require being able to check the value/text of multiple cells at a time and count the number of rows that meet that criteria.
[SOLVED] 1. The first part would be to have the worksheet be able to count the number of each type of the 9 mission scheduling codes throughout the range. I would be storing the count in new cells that would then be connected to pie charts.
[SOLVED] 2. The second part would be to count the number of each type of mission that was flown per day of the week. That would require searching both mission type and day of the week. All I would need is a working formula for 1 set, then I could switch mission codes and weekdays to match all the 63 possible outcomes.
3. Knowing the number of each type of mission flown per month. This would be checking the date and the mission type. The trickier part that comes up in my mind is that our programs span multiple calendar years, so it would have to track it by month and year, that way there is a difference between Jan 2009 and Jan 2010. The counted numbers would be used to make histograms. It would be nice if the chart titles could be automatic based on the dates inputed in the mission tracker. If I needed to choose a maximum time length for it to cover, I would pick 3 years.
4. I would like to figure out how to make an inputted line of data on the main tracker sheet to create a copy in the corresponding worksheets based on schedule type, that way a person could look at/print a specific type without having to sort the main list.
The actual goal is to make it where a person can enter the 1 line of data per mission (cells A-G) and the mission metrics update automatically after each mission is inputed allowing upper level supervision to have current information quickly whenever it is needed. Currently we need about a weeks lead time to get the information asked for on our current progress.
Within a data validation selection, are you able to do both Auto Complete and Auto Delete? I have this posted at another forum [url]but have not been able to find a solution (a copy of the file, test. zip is there as well). I am not sure it is possible, or, at least I have been unable to get it working. I can do each, but not both.
I have also been utilizing:
[url]
[url]
I have one worksheet that contains a large table. I'm using VLOOKUP to spread each row of the table to separate worksheets.
When VLOOKUP refers to an empty cell, is there a way to set that row to be hidden?
Also, if VLOOKUP returns data to a cell, is there a way for Excel to automatically set the row height to display all of the linked data in that cell?
I have one worksheet that contains a large table. I'm using VLOOKUP to spread each row of the table to separate worksheets.
When VLOOKUP refers to an empty cell, is there a way to set that row to be hidden?
Also, if VLOOKUP returns data to a cell, is there a way for Excel to automatically set the row height to display all of the linked data in that cell? There is only one column of data.
Possible to auto count and auto sum based on Unique ID.
Download link to the file in question [URL] ..........
So for Example ID 79125 should get a sum 537.39 and count should be 12, also in any given week like 50 , 51 , 52 , week 1 etc.., duplicate entries must be all counted as 1
I am trying to auto generate a calendar based on two drop down menus - Month and Year.
Once the month and year is selected I want to import all work orders onto the calendar based first on the "Labor Name" found in the list of work tab, then assign each work order for that labor name to the respective date on the calendar for the month.
August PM Schedule Demo.xlsx
I have dates values in 3 columns.
A1 - Header - "Holidays in XXXX'
B1 - Header - "Holidays in YYYY'
C1 - Header - "Leaves by YOU"
A2:B11 have static dates consisting of 10 dates in each column.
C2:C11 - the user may enter any date at any point of time.
I would like to auto-merge the dates in all the 3 columns (A2:C11) in a single column say D2:D31 and then the system should auto-sort the column based on dates in any one order. So as soon as the user enters a value in say cell C2, all the 10+10+1 dates should get sorted.
Also the constraint here is a user may not apply all 10 leaves at in a year. So many of the cells may have blank values.
I would like to know if there is a way to Auto number a text.
I have a column with text tags (lets say Column B). These cells look at a specific cell (ex. A1) and see what text is written in it then copy the text into their own cells B1, B2, B3 and so on. So if cell A1 reports AAA then Column B cells become AAA all the way down.
Now what I like to do is for column B cells look at A1, copy the text and add _01 infront of their copied text. so for Column B, B1 reports AAA_01, B2 is AAA_02, B3 is AAA_03 and so on
I run an online store where all the product details are handled by a .CSV file and naturally all the information has to be exact or it won't work at all especially UPC codes and product codes. However whenever I open the .CSV file to edit anything it auto formats several bit of information including several UPCs and product codes that begin with one or more 0's. This among many other problem I have had are all caused by excel's auto formating "tool" and I find it of absolutely no use. Is there any way at all to disable this "tool" so it will stop messing with my data every time I need to make a product change? (I have tried using the '0 trick but when I save the file and open it again later all the '0s are gone again)
I am running Excel 2007 on Windows Vista SP1
this will not be easy since I do not know any English terms for Excel operations (only Swedish ones...). But I'll give it a try:
I have a column A, and a column B. I want the numbers in B always to be
=(cell above)+(cell to the left).
Example:
B1=1, A2=1 --> B2=2
B2=2, A3=7 --> B3=9
B3=9, A3=5 --> B4=14
and so on.
Column A is a column for my expenses, column B is my cashbox, you see...
I could do this with a simple "sum"-formula in every B-cell, but I hope there's a solution to tell the spreadsheet that any B cell=(cell above)+(cell to the left).
There are only 3 columns, A, B, C and only 10 rows but I would like it to sort automaticaly. I enter data on other sheets and it is loaded automaticaly back to sheet 1 after some calculations are made. I would like the data on sheet 1 to sort automaticaly on column C keeping the rows of data intact.
View 14 Replies View RelatedI have a column data on a worksheet, the PO number for specific purchases where a PO number may be listed multiple times. One a separate worksheet within the same workbook, I have a PO summary section where PO numbers are manually entered and the next column sums the the total value of each PO.
Is there a way I could have the Summary section identify POs and automatically total them without having them manually entered?
Is it possible to create a macro which adds a new sheet and names the tab from a cell value somewhere?
View 5 Replies View RelatedI wrote below code, I am expecting column to be updated as 1, 2, 1, 2, 1 ,2 till last row, but it is updating as 123456...
[Code] .....
I need it to autofill just as if you selected range A1 and A2 and double clicked that little square on the bottom right hand side of the cell (so it stopps auto-filling at the last active cell in B)
View 5 Replies View RelatedI want create an conditional delete macro i.e.: if in column a - b - c the cell is not coloured = delete.
View 3 Replies View RelatedI am trying to figure out how to auto sort information on a spreadsheet so that when update notes are added by date at the bottom of the list, they are automatically sorted (moved) to the top of the list so the latest update is shown first. I am pretty clueless when it comes to macros although I have given it some attempts after reading other posts without success. I am including a copy of the spreadsheet. The info that I need sorted starts at B43:E43 and goes to B104:E104. That same sort info would then be used for the similar info to the right of this one. For example everything on the line B43:E43 would move together.
View 11 Replies View RelatedOk, so this is my first attempt at an excel macro. I'm trying to develop a macro that will assist me in auto-populating a column in a new worksheet based on another worksheet. Recently I ran a new report at work that is 4000 lines long that I really do not want to have to edit by hand, since I already had to do it with the older one.
I can't post my data but i'll try to explain it the best I can, but basically it's set up as a part number, next column is the steps in completing that part, and then a workcenter number. I'm trying to populate that workcenter column in the new worksheet. I've put this macro together with the best of my ability along with excel help and the internet but I just can't seem to get it to work.
make the auto naming code displayed on the worksheet tab die after first entry into, so that regardless whether any values are changed in the worksheet--a minute, hour, day after-- the "namedate" stays the same.
View 3 Replies View Relatedi have formulas in a range L5:L15 which sometimes return some value and
sometimes zero. i want to give them auto numbers in column M in a way that it
should only count the cell which has some value.
suppose formula in L5 returns some value, L6 also then L7 & L8 have no
value(but formula persists), cell L9, L10, L11 has values then L12 has no
value L13, L14 has value and L15 has no value (but it has formula in it)
values in these cells changes and some goes to zero and some return values.
now i want to give them Auto Numbers in a way that cells with some value
should only be considered.
Is there a way to use the auto filter when all cells on a spreadsheet are protected. It doesnt appear to work when cells are protected.
View 9 Replies View Related