Simple fill down, flatten and loop through all columns - THANKS!

**virsilens** · 03-16-2018, 04:34 PM

I would like to create a macro which will:

Take the formula in G2 and fill down,as far as there are data rows exists. (actual data has 100K row)

THEN convert the cells that was just filled (only G3 and below) into a static value (copy/paste value).

THEN loop the same macro to all the columns to thr right, one column at a time, all the way to column AZ.

File attached.

Thank you

**Fluff13** · 03-16-2018, 04:40 PM

How about

Please Login or Register  to view this content.

**virsilens** · 03-16-2018, 04:56 PM

Good shot at it Fluff13. It works!

**Fluff13** · 03-16-2018, 05:10 PM

Ok, how about

Please Login or Register  to view this content.

**virsilens** · 03-16-2018, 05:14 PM

Even better!!!!!! Thank you

**Fluff13** · 03-16-2018, 05:34 PM

Glad to help & thanks for the feedback

Simple fill down, flatten and loop through all columns - THANKS!

LinkBack

Thread Tools

Rate This Thread

Display

Simple fill down, flatten and loop through all columns - THANKS!

Re: Simple fill down, flatten and loop through all columns - THANKS!

Re: Simple fill down, flatten and loop through all columns - THANKS!

Re: Simple fill down, flatten and loop through all columns - THANKS!

Re: Simple fill down, flatten and loop through all columns - THANKS!

Re: Simple fill down, flatten and loop through all columns - THANKS!

Thread Information

Users Browsing this Thread

Similar Threads

How do i flatten the loop so that it checks only one sheet?

Flatten rows into columns based on id column

Loop to fill in text where a columns cells are blank

Flatten/ de-pivot

Flatten a Crosstable

How to 'flatten' a set of values

Setting up a simple loop to fill labels?

Bookmarks

Bookmarks

Posting Permissions