The Autosum in all my Excel files is greyed out. I am able to use the icon button to perform autosums but am unable to turn off "autosum" from the tool bar. I have turned the EnableAutosum to "true" in the Editor with no luck. What am I missing?
View 2 RepliesI have a user that is having problems with AutoSum updating after a cell is deleted. He has the following...
100
200
100
400
If he deletes one of the cells, (lets say 200), the autosum number stays at 400. I reinstalled his MS Office and it worked for a few days, but now he is having the same problem.
So now he has...
100
100
400
I have a formula that is in ColF Row4, and it is copied down to ColF Row 13. But trouble is that when I autosum this column I get 6, but the answer should be 8.
The data in Rows A-E are extracted from an external data source. I've attached the spreadsheet. =IF((AND(A4=7,D4="")),1,(IF((OR(A4=7,D4>=2)),D4,0)))
with vba code that autosums column O two cells below the last row of data.
I am currently using the following code:
Range("O2").Select
Selection.End(xlDown).Select
ActiveCell.Offset(2, 0).Select
Application.CommandBars("Standard").Controls("Autosum").Controls("Sum").Execute
SendKeys "{ENTER}", True
The problem is it switches over to editing after the autosum command and doesn't execute the sendkey correctly.
Let me preface this by saying I am very new to macros in Excel....I was wondering of there is a way or an existing macro that will automatically calculate the sum of a column at each inserted line break?
I am working with a spreadsheet with 3 basic columns...the first column has a dollar amount, the second a part name, and the third column a quantity. The spreadsheet is quite large, so I am hoping to find a way to have a macro autocalculate the sum of the dollar amount and quantity columns whenever a line break has been inserted in between parts.
Here is what I am looking for:
I have several groups of data separated by a couple of blank lines. For each group of data I would like to sum the rows in column F. I do not want to use the subtotal feature but rather the autosum feature for each section. It is important that the formula is actually entered so if I add additional rows of data the formula will keep calculating. So at the end of each data the formula is as follows =sum()
where I can input and keep track of my receipts for tax season. So there would be a date column, price, etc and for the price column I'd like to be able to not have to add all the totals manually.
I've looked around for something like this on the Microsoft templates site but haven't found anything so I think I may just have to make this myself but I don't know how to.
I have this autosum macro it does its job very well. Problem is that it returns autosum with absolute cell references ($ signs around cell numbers). This way I cannot copy paste formula around same row but different columns. I would rather have to copy paste code for each column and change declarations.
How to edit this code so that variable cell references are returned in the result.
Code:
Dim cel1 As String, cel2 As String
cel1 = ActiveCell.Offset(-2, 0).End(xlUp).Address
cel2 = ActiveCell.Offset(-1).Address
ActiveCell.Value = "=sum(" & (cel1) & ":" & (cel2) & ")"
I have made up a sheet to show approximate CO2 consumption of fluorescent and LED light fittings, and on my sheet I have used an autosum so that all you do is type in the quantity of light fittings you will have on a job and the sum will show you the yearly CO2 consumption automatically.
However, I was wondering if in the same cell as the auto sum could you choose to have some text displayed in the same cell after your sum?
Something along the lines of:
=SUM(A13*B13) (DISPLAY: Tonnes Of CO2 Used)
Its just so I don't have to have a separate cell adjacent to the autosum with my text displayed.
I have a macro that takes a large block of info, sorts it by certain criteria, then adds blank rows, and puts in Autosum for the various blocks of info. Problem occurs when a particular "block" of info is only 1 row. Any dirty little tricks to keep the macro running past this roadblock? The section of code looks like
Range("O1").Select
ActiveCell.Offset(2, 0).Select
Do While ActiveCell <> "end"
If ActiveCell.Offset(-1, 0) = "TOTAL" Then
ActiveCell.Offset(-1, 1).Select
ActiveCell.Font.Bold = True
SendKeys ("%="), False
SendKeys ("~"), True
ActiveCell.Offset(1, -1).Select
Else
ActiveCell.Offset(1, 0).Select
End If
Loop
the autosum is not working on one cell which has a formula. All the other cells with formulas are summing correctly. The forumla i used is: =IF(C21="No","-1","") If i enter "No" in C21 the value -1 is return.
However the autosum does not seem to pick up this -1 and only returns 0.
I have a set where there are multiple rows on same date ( ascending order). The data set looks like following:
Date Variable 1 Variable 2 Variable 3
1/01/2014 (M-D-Y)
1/01/2014
1/01/2014
Insert a new row over here and calculate auto sum from 4 Column (D) onwards for all the data for 1/01/2014
1/02/2014
1/02/2014
1/02/2014
Insert a new row over here and calculate auto sum from 4 Column (D) onwards for all the data for 1/02/2014
As i have 365 days in a year and i have to insert a blank row for every date then calculate the auto sum for all the dates.
I opened an Excel file, and the whole page is grey. I can't see the cell lines at all. How do I get it back to white with all my gridlines?
View 3 Replies View RelatedI've read a bit on the web about there being a bug with the 'edit links' feature. How/Can I get this function to work?
View 6 Replies View RelatedPaste Special is no longer available in the Edit menu--it's grayed out. (I am using Excel 2003). I can't find any info on what disabled it or how to re-enable. It's probably something moronically obvious, but this moron needs a shove in the right direction.
View 6 Replies View RelatedI have noticed that the submenus for the following main menu items are disabled
Edit Insert Format Data
The submenus for the other main menu items are fine.
I have not run any macros that alter the menus.
I have tried Tools>Customise Reset Menu and Toolbar usage. I then exit the Excel session, but the problem still remains,
I have a cashflow spread sheet on which there are three properties that are currently being renovated and are being rented out. I would like to see ongoing costs for each individual property on the main spread sheet. I can filter and sort by the properties and autosum to get the individual costings of properties, but I would like to be able to see the costings of each property on the main spread sheet once I have stopped filtering.
View 1 Replies View RelatedI would like to restore some important functionality in Excel 2007 which has become disabled for a spreadsheet which I saved in different file formats.
I opened an Excel 2003 file with Excel 2007 and used 'Save As' into different formats (default, macro-enabled, binary) to see the resulting file size.
A number of Ribbon items are now greyed out for this file, including,
- Insert - Tables, Illustrations, charts, etc.
- Styles - conditional formatting and Format as table,
- Formula Auditing
- Data - just about all of them
- View - some of the Window items.
Also, I cannot resize or move a button on a worksheet.
Attempts to 'Save As' into the Excel 2003 format cause Excel 2007 to hang.
What caused so many features to become disabled?
How do I restore them?
I sometimes come across spreadsheets that have only a few white, "normal" looking cells and the rest are grey with no borders.
Usually there is a thick blue line around the "normal" cells and I can make more cells look "normal" by dragging the blue border line.
What is this? And, how do I set it up in a spreadsheet if I need to?
In some excel files the redo / undo buttons are grayed out
View 3 Replies View RelatedMy spreadsheet is locked and protected, and i have found out that the BOLD, underline and italic functions have been disabled, is there anything i could do via VBA to keep these functions active,...????
View 4 Replies View RelatedI am using Excel 2000 on Windows 2000. There are no macros on spreadsheet and no protections at all yet I acnnot use trace precedents/dependents as the items are greyed out.
View 2 Replies View RelatedI've just finished writing some vb code that i need to assign to a button. Trouble is I select the control toolbox and put it design mode and all of the icons with the tool box are greyed out. pic attached below
pukks Auto Merged Post;Doh Doh and double doh!
Problem solved: I inadvertently had selected more than one worksheet tab and this was stopping me from placing a button on the worksheet.
I am using excel 2007 and when I right click on the worksheet tab, delete is greyed out. My workbook/sheet is not shared. I also had the problem owith row and columns. CommandBars("row").Reset sorted that out but I can't seem to sot out the tab issue.
View 6 Replies View RelatedI've got Combo Boxes and at times I want to hide this. However, when I do, the combo boxes don't hide and are still visible. Here are my steps: Right Click on the combo box, chose Format Control, then under the properties tab, the choice to select "Move and size with cells" are greyed out.
View 4 Replies View RelatedI cannot figure out why this setting has changed. When I right click my tab worksheet in Excel to copy or rename, it does not allow me. I will need your advice to re-activate that options so it is visible and not gray. I tried in the VBA workbook properties settings with no luck and also Tools, Options.
View 6 Replies View RelatedI'm using Excel 2010 and when I highlight a range and right click 'name a range' is greyed out. I can bypass this by going to the formulas tab and defining a name from there.
Anything I can check to see why this is not an option for me?
I ran a simple macro that I created in my workbook, got a run-time error, clicked debug, clicked reset to stop the macro running, and now all of the icons in my workbook are greyed out. I can select cells, change worksheets, enter information in cells etc....just I can't save the workbook, or select any of the icons on my ribbon / in the office menu. Would really like to avoid terminating the application as I made a number of changes that I didn't save (doh doh doh).
View 9 Replies View RelatedI am making a spreadsheet in which I have been asked to have certain column greyed-out based on an answer that was given in a dropdown menu. Specifically, a dropdown menu in column D asks if the client was a Youth or an Adult. Depending on what the anwer is, other columns in the spreadsheet will be greyed-out; different ones for each answer. My problem is, I need this to occur for the active row being editted. For example: The first row that the user can input data into is row 4. If D4 is answered with "Adult" then certain other columns are greyed-out. However, if the next time the user updates the spreadsheet with information for a different client (now entering information in row 5) and they select "Youth" for column D5, then different columns get greyed-out. The columns that are greyed-out will depend upon the answer for the dropdown menu in column D for whatever row is actively being editted.
View 5 Replies View RelatedI have a spreadsheet that runs a macro resulting in a different number of rows everytime the macro is run. Columns H, I & J are the only columns with currency in them. I would like a macro to find the bottom-most row of currency data in these columns and insert the Auto-sum formula in the row directly below each of these 3 columns. Then bold this row and increase the font by 2 points (or 12).
View 13 Replies View Related