Hi all,

I am importing some data from a database to excel and is using some formulas
in some of the columns to manupulate the data. Every time I import the data I
got different number of rows and this is in order, because the database
ghanges. My problem is that I cant manage to get the formulas to adjust to
the number of rows I get automaticaly.

I have to copy the formulas manualy depending on the number of rows I get.
Is it possible to get excel to copy the formulas to the right number om rows
Idepending on the number of rows I import?

Thanks in advance

Hi Blueeyes

You can autofill down a contiguous column by double-clicking the little
autofill button the bottom right-hand corner of a cell.

Hope this helps.
Andy.

"Blueeyes" wrote in message
...
Hi all,

I am importing some data from a database to excel and is using some
formulas
in some of the columns to manupulate the data. Every time I import the
data I
got different number of rows and this is in order, because the database
ghanges. My problem is that I cant manage to get the formulas to adjust to
the number of rows I get automaticaly.

I have to copy the formulas manualy depending on the number of rows I get.
Is it possible to get excel to copy the formulas to the right number om
rows
Idepending on the number of rows I import?

Thanks in advance

Thanks Andy,

That way not really the soultion I was looking for, but I might be able to
combine this with a macro :) I give it a try.

Thanks


"Andy" wrote:

Hi Blueeyes

You can autofill down a contiguous column by double-clicking the little
autofill button the bottom right-hand corner of a cell.

Hope this helps.
Andy.

"Blueeyes" wrote in message
...
Hi all,

I am importing some data from a database to excel and is using some
formulas
in some of the columns to manupulate the data. Every time I import the
data I
got different number of rows and this is in order, because the database
ghanges. My problem is that I cant manage to get the formulas to adjust to
the number of rows I get automaticaly.

I have to copy the formulas manualy depending on the number of rows I get.
Is it possible to get excel to copy the formulas to the right number om
rows
Idepending on the number of rows I import?

Thanks in advance

Nope did not solve my problem, well it works but I have to do thing manualy.

So any other suggestions?

"Andy" wrote:

Hi Blueeyes

You can autofill down a contiguous column by double-clicking the little
autofill button the bottom right-hand corner of a cell.

Hope this helps.
Andy.

"Blueeyes" wrote in message
...
Hi all,

I am importing some data from a database to excel and is using some
formulas
in some of the columns to manupulate the data. Every time I import the
data I
got different number of rows and this is in order, because the database
ghanges. My problem is that I cant manage to get the formulas to adjust to
the number of rows I get automaticaly.

I have to copy the formulas manualy depending on the number of rows I get.
Is it possible to get excel to copy the formulas to the right number om
rows
Idepending on the number of rows I import?

Thanks in advance

What are the formulae that you are using?

Andy.

"Blueeyes" wrote in message
...
Nope did not solve my problem, well it works but I have to do thing
manualy.

So any other suggestions?

"Andy" wrote:

Hi Blueeyes

You can autofill down a contiguous column by double-clicking the little
autofill button the bottom right-hand corner of a cell.

Hope this helps.
Andy.

"Blueeyes" wrote in message
...
Hi all,

I am importing some data from a database to excel and is using some
formulas
in some of the columns to manupulate the data. Every time I import the
data I
got different number of rows and this is in order, because the database
ghanges. My problem is that I cant manage to get the formulas to adjust
to
the number of rows I get automaticaly.

I have to copy the formulas manualy depending on the number of rows I
get.
Is it possible to get excel to copy the formulas to the right number om
rows
Idepending on the number of rows I import?

Thanks in advance

Well, I use 4 different formulas one of them is to change the syntax
for the dates I got from the datebase and looks like this:

=MERGE(EXTEXT(L3;1;4); "-"; EXTEXT(L3;5;2); "-"; EXTEXT(L3;7;2))

I am not sure for the command MERGE because I use a Swedish excel but it
shoud be MERGE or something :)

However I think that this funktion I am loooking for should work regardless
the formiulas I am using :)

I maybe should use IF......... then use formula ....... otherwise .......

I dont know but there should be a setting or command for my request


"Andy" wrote:

What are the formulae that you are using?

Andy.

"Blueeyes" wrote in message
...
Nope did not solve my problem, well it works but I have to do thing
manualy.

So any other suggestions?

"Andy" wrote:

Hi Blueeyes

You can autofill down a contiguous column by double-clicking the little
autofill button the bottom right-hand corner of a cell.

Hope this helps.
Andy.

"Blueeyes" wrote in message
...
Hi all,

I am importing some data from a database to excel and is using some
formulas
in some of the columns to manupulate the data. Every time I import the
data I
got different number of rows and this is in order, because the database
ghanges. My problem is that I cant manage to get the formulas to adjust
to
the number of rows I get automaticaly.

I have to copy the formulas manualy depending on the number of rows I
get.
Is it possible to get excel to copy the formulas to the right number om
rows
Idepending on the number of rows I import?

Thanks in advance

If double-clicking the fill handle works for you, but you want it more automated
You could perhaps use the code posted by Tom Ogilvy in
http://groups.google.com/groups?thre...GP15.phx.g bl

More information on the fill handle in
http://www.mvps.org/dmcritchie/excel/fillhand.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm