microsoft excel 2010

I need the final cost in "P13" and I already defined each variable but it doesn't appear the number. What is wrong with the code? I know the select case is correct because I ran it before and it was working, but now is just the info of an specific cell. I think is the reference to the specific...

When I try to save as the Microsoft Excel 2010 worksheet in HTML format, it is not visible in Google Chrome but it is visible in Internet Explorer 11. I looked at the HTML source and it seems it must be visible but perhaps there is some tag which makes it difficult for Google Chrome to display...

Hi all - I have the below code to copy a set of row data from one tab and paste/transpose when a Command Button is clicked on a second tab. How do I edit this so that every time the Command Button is clicked, the data is pasted to the right on the first blank row? Currently, when it's clicked...

Hi all - I've got the below code to copy column data when a Command Button is pressed and paste/transpose on a different tab. Each time the button is pressed, the data is pasted on the next subsequent row. Is there a way to paste/transpose the data but keep the original cell formatting where...

Hi everybody.. I'm looking for help to update the below code to transpose data from Column format to Row format. I have the below code (thanks Yongle for your help!) that copy values in a set of column cells when a button is pressed and pastes those values onto another tab. If the user...

Hello, I would like to know if there is a way to automatically update the content of a cell based on the value of a cell in another sheet ? That original cell's value is based on a drop down menu. Could someone exlpain to me how to make it work ? Thank you very much for your help

Hi there, How can i make a population pyramid in excel, including age in the middle of pyramid and male-female rates on the right and left part of screen, i.e. something like this

I am using Excel 2010. Let's say I have a workbook that contains 13 worksheets. The first worksheet is named "Summary" and the remaining 12 are the months of the year (January-December). In "Summary" I want to ask the user to choose a month. Then, I use '=DATE(YEAR(E1),MONTH(E1)+1,1)' to...

I have a procedure that was written to loop through the approximately 250 rows and place the ship name and a date in the last two open columns. The Table looks as follows: Hull Number Ship Name Sync Date CG-2 USS HOME 10/3/2015 DDG-3 USS Light 4/23/2015 CVN-70 USS Enterprise...

Friends I want to insert time in a range which should not get updated automatically. For example if there is any value in cell no k5 then the current time should automatically be inserted in cell no N5. Similarly if there is any value in k6 then the current time should automatically be inserted...

Good afternoon. I have a project I'm working on where I need to Search this website: http://mysbse.web.irs.gov/collection/toolsprocesses/AllowExp/AllowExpLookup/default.aspx entering the text value found in Sheet1 Cell D6. The information found on the website would be copied and pasted to...

Dear All I have plotted X against Y at different values of Z. <tbody> X Y1 (Y @ Z=1) Y2 (Y @ Z=2) Y3 (Y @ Z=3) 20 2 4 6 40 4 6 8 60 6 8 10 80 8 10 12 </tbody> Now, I have to interpolate Y for any value between X=20 & X=80 and any value between Z1 & Z3...

Hello, In A1, I have Nov2013. Columns A2:Z2 have various headings with data underneath each column. I would like to find the column with the heading "Nov2013" and pull the all the data underneath that column into a new column, column AA2. How can I do this? Thank you!

After creating the Pivot Table shown below https://www.dropbox.com/s/80fys3eb9ovbmyc/Pivot1.jpg I want to get a continuous list of dates with the year included as shown below https://www.dropbox.com/s/hdo7yea6usckx7u/Pivot3.jpg In order to get the data organized as shown above, I have copied...

Hi, I have two excel files. (Say A & B). "A" excel file contains data of 100 Names, Addresses, Zip Codes Etc. "B" excel file contains template letter format. What i want to do is export data from "A" excel file to "B" excel file and save all 100 files individually. Is there any excel...

I have data like so: <tbody> <colgroup><col width="136"></colgroup><tbody> 00:01:18.941 </tbody> <colgroup><col width="133"></colgroup><tbody> Session begin </tbody> <colgroup><col width="79"></colgroup><tbody> State start </tbody> <colgroup><col...

Where are the best online course Microsoft Excel 2010 for Beginners?

Is there a way that i can compare multiple sheets in a graph. I am trying to graph totals from 5 different sheets all the totals I am trying to do graph are in the same cell on all the sheets

Is there a way to create and new macro that i can link to a button that will create an new sheet copy my format of a previous sheet, then apply that to the new sheet, then change the name of the new sheet to the current date (but the date in the macro has to imput the current date so it would...

I am trying to create a formula consisting of if statements based on a data validation box. The formula im trying is =IF(a1="Medium",i9*0.03,IF(a1="High",i9*0.7,IF(a1="Low",i9*0.01,0))) A1 is in a table with a dropdown box to limit to High,Medium,and Low.im also adding similar if statments...