Enter Formula on Multiple Locations using Macros

Hi Guys,

I have the following

Please Login or Register  to view this content.

which gives me a location name along with that locations maximum value.

The formula looks for a condition met from column G, matches it to column AC and then gives me the result from column K , here is the formula

Please Login or Register  to view this content.

What i need is to be able to insert that same formula by first looking down column G next available empty row and once it finds it insert the formula on column E and F one row below where the empty row is first found from column g.

Sounds , I can manually enter formula then copy paste in the proper row and column but the problem I have others will be using this worksheet and I wanted to this automated.

Thanks...

please put code tags around code! it makes it easier to read and is in the forum rules.

Please Login or Register  to view this content.

if thats not the right cells adjust offset ,as it stands if last used cell is G25
then first formula is put in E27 second in F28

Thanks, I forgot to to wrap in code tags.

This seems to place the formulas and the very end of the data column. It does not find the empty rows in between.

I wanted to be able to start off and insert the data from the very beginning, which will be Column E row 27 and column F row 27. From there the macro will look at the next empty row from column G and insert the formulas in column E and F and continue to do this until it inserts the formulas .

Column G will have data but every so often it will have an empty row to separate one set of data from another.

Thanx

If I've understood correctly, I think this is what you want:

Please Login or Register  to view this content.

Note that your lookup formula does not actually need to be entered as an array formula.

Wow, great, thanks.It works like a dandy.

Just one question, how can I make it to stop a a certain row number. Right now my last row with data is row 200 on column G but the macro writes down to row 400.

Is it because I have data in row 400 but only on column AC?

I only have data in Column G row 200.

Can this be changed.

Thanx, looks like I found the right forum for my questions and answers.

Preatorian, please don't quote whole posts. It's just clutter.

This part:

Please Login or Register  to view this content.

looks for the last cell in column G with something in it. If it's writing down to row 400, then there is something in G400.