Hi,
I am trying to find a vba code that will find blank cells in a certain column (Column O), and replace these cells with a formula that includes the median of cells above (up until the next blank cell)
for instance, cells O3:O15 are filled in, O16 is blank, I want a code that can find the blank O16 cell, and in that cell calculate the median of O3:O15.
I have about 150,000 rows, and there is not a uniform spacing between the blank cell ranges.
Thank you in advance!!
Hi
I am trying to find medians for a series of values (in a column) separated by blank rows where the formula knows to end the median calculation when it runs into the first blank cell--and the median number will be calculated in this blank cell.
For instance, cells O3:O15 are filled in, O16 is blank, I want a code that can find the blank O16 cell, and in that cell calculate the median of O3:O15.
I have about 150,000 rows, and there is not a uniform spacing between the blank cell ranges.
thanks in advance!
Beth
Hi,
I have an excel sheet with many entries. At the bottom of excel sheet i like to have a cell to enter any value and based on that value, a macro finds that value on the sheet, copy found cell and the cell above it and the cell on the very left column on the row above found cell into a new sheet. Thenthe macro to find the next value on the sheet, again copy found value and cell above it and the cell on the very left column on the row above found cell and copy them on the new sheet.
Example: i enter "car" as a vlue in a predefined cell. The macro finds the value on a particular cell containing that value, lets say G499, then the macro copies G499 and G498 and A498 to a 2nd sheet on the following cells respectively: A1, A2, A3.
Then the macro should come back to the original sheet with many entries find "car" again and it finds the next cell containing "Car" lets say H510, then the macro copies H510 and H509 and A509 to to a 2nd sheet on the following cells B1, B2, B3.
It keeps doing that until it finds all "car" entries on the original sheet and then it gives a message "All entries copied".
Thanks very much
Hi,
I'm currently working on a spreadsheet which has 7000 rows (source tab)
On the other tabs, I've got formulas picking up certain data...but my goodness, when I have to add a line or delete or save...it takes ages to process. Is there any way I can speed things up?
The file size is 1,611 KB
Thanks
Jen
iinterested to determine whether there is a relationship between the number of room airconditioning units sold each week and the time of the year. What type of graph would be most useful in performing this analysis? why?
I use BUTTONS (Form Control) in xl07 to trigger macros.
It is easy to adjust their size and other properties, but I am
looking for a better way to precisely place them on the sheet
to give an aligned clean look.
Any tips on moving/placing BUTTONS ??
I would like to know what tools I need to learn in order to be able to write a VBA routine that can browse Google finance" for example and get quotes or historical quotes of stocks.
Is there something special, other than writing VBA code, that I need to have. How is this related to google APIs which I hear much but know nothing about? Do I need to know these tools in order to make this task easier?
The colde below for example can open the google finance page, fill in the symbol of a stock (CPE in this case) in the search bar and thats all. I still can't know how to make it click the "get quotes" button. But even if I know, is this the way to go or there is easier way?
Sub VisitWebsite()
Dim ie As Object
Dim Webbrowser As Object
Set ie = CreateObject("InternetExplorer.Application")
ie.Navigate "http://finance.google.com/ "
While ie.busy
DoEvents 'wait until IE is done loading page.
Wend
ie.Visible = True
ie.Document.all("q").Value = "cpe"
While ie.busy
DoEvents 'wait until IE is done loading page.
Wend
End Sub
Thank you very much
In Excel I have a few spreadsheets which use charts, just today when I mouse over the bars the little "Chart Tip" stopped showing up. I checked in Tools/Options and under Charts the options are checked for both "Show Name" and "Show Value". Anyone see this before? Nothing changed on the system really.
What is the easy way to create forms in different sheets.......
In Main Sheet (Sheet1) each row contains some informations about a particular item.
I want to create Forms in separate Sheets and datas for this Form 1 (Sheet2) should be datas of Row#1 of Sheet1 & datas for this Form 2 (Sheet2) should be datas of Row#2 of the Sheet1.......
