How do I import data into Excel from Bloomberg using Excel 2007?
Thu, 18 Mar 2010 20:16:01 -0700
How do I import data into Excel from Bloomberg using Excel 2007 (Microsoft
Vista)?
I need to import historical prices of 14 tickers into the same workbook.
...
|
Using VBA to setup calender to determine sales quantity
Thu, 18 Mar 2010 19:41:02 -0700
Hi,
I have a problem with this:
I have a worksheet named Sales historical data:
Column A: Dates
Column B: Phone Description
Column C: Sales quantity
I need to get the total sales quantity for 5 days.
On the left hand side, i want to create a calender in which i can choose the
date. then on the righ ...
|
using VBA to retrieve values to ComboBox
Thu, 18 Mar 2010 19:21:01 -0700
i am trying to retrieve a range of data (the stock code of different phones)
from worksheet("Inventory") based on the name of the branches of where the
phones are stored.
worksheet("Inventory") has branch (Column A) and stock code (Column B)
i have 2 combobox.
combobox1 contains values (name of branches) ...
|
Delete duplicate records from both columns
Thu, 18 Mar 2010 18:31:02 -0700
Hello,
I've got 2 columns of data. How can I delete both records if the appear in
both columns? This is in Excel 2007.
Thanks ...
|
Updating links
Thu, 18 Mar 2010 18:29:02 -0700
Hi,
I have exchange rate of several currencies in a workbook that is updated on
a monthly basis. From this, all the rates will be linked to several other
workbooks (more than 20). The problem is when I emailed out those workbooks,
all information, formulas and charts are affected as the recipents do not
h ...
|
tab to next unlocked cell
Thu, 18 Mar 2010 18:28:02 -0700
Hi... hope you can help.
I have a spreadsheet with locked and unlocked cells. I would like to TAB to
the next unlocked cell available. Is there an easy way to set this up?
Thank you. ...
|
4 day work week
Thu, 18 Mar 2010 18:24:01 -0700
How would you calculate the difference between work days with a 4 day week
AND holidays??
thanks
--
AJ ...
|
|
|
Show significiance between 2 bars
Thu, 18 Mar 2010 17:01:01 -0700
I want to put a line that connects two bars in Excel, and put different
values on top of it, like correlations or significances between the two bars.
Example: http://hawaii.edu/mri/excel.jpg
Right now, I am doing each by hand. I open it in PowerPoint, and then use
the shapes and text boxes to connect ever ...
|
Multiple Tabs
Thu, 18 Mar 2010 16:55:01 -0700
I am creating a workbook and it has numerous tabs for each spreadsheet to the
point you have to scroll left and right. Is there a better way to access each
of the spreadsheets?
Thanks ...
|
#Ref! after row deletion
Thu, 18 Mar 2010 15:53:01 -0700
How can one stop the #Ref! from appearing after deleting row from above? Exam:
Col A = Date field
Col B = Data field
Col C = Reference from Col B, formula = if(A2="",C1,B2) Etc. to row 10.
Row C11 contains formula =C10
delete rows 3,4,5 leaves row 11, now row 8 with #Ref!
What kind of formula can s ...
|
