Auto fill?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Nope did not solve my problem, well it works but I have to do thing manualy.

So any other suggestions?
 
What are the formulae that you are using?

Andy.

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

So any other suggestions?
Click to expand...
 
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
 
Back
Top