Hello,
I have several excel files with active links to a PowerPoint file. I need
to combine the Excels into one, but any way i try to do so breaks the
links. Is there a way to combine the files whilst maintaining the links?
Thanks in advance
David
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
Hello everyone,
I have 2 spreadsheets. One with raw data, the other is the one i need
the data in. When i copy the data across the dates change. In the
original spreadsheet, the data code is 40556, and when viewed as a
short date it is converted to 1/13/2011. However, the in the second
spreadsheet
Hello everyone,
I have a loop in which at one point i need to draw data in via a
Bloomberg terminal. This always takes a few seconds to achieve this.
Without any pause, the operation is not completed before the next step
(which is to copy and paste special the data somewhere else) goes
ahead. This
Hi Guys,
So I a simple indirect function that looks into another file (the name
of which is in my sheet in cell I1) and find the value in cell A3 of
the sheet in that file called Output. This is that function:
=INDIRECT("["&$I$1&".xls]Output!A3")
However, when i drag this formula down the refere
Hi everyone,
I am trying to create a fan chart that displays the probability of
different outcomes occurring in the future for a single variable. An
example can be seen here:
http://www.bankofengland.co.uk/publications/inflationreport/mktgdpfeb09large.gif
Producing the different lines is easy bu
Thank you Kishan and Dave, your answers were very helpful
David S
On Aug 21, 4:09 am, Dave Bonallack wrote:
> Hi David,
>
> Have a look at the attached. I hope it meets your needs.
>
> As good as the macro recorder is, it always returns way too much code. Part
> of learning VBA is learning how
Hello everyone,
I am trying to write a macro to name four ranges in a sheet. The
ranges will have the same width every time, and the ranges below the
two at the top with always be separated by 1 blank row but more or
less rows. I thought it would work by using:
Range(Selection, Selection.End(xlDo
