[b]Copy / Paste formulas by row counts[/b]

fb250r

Board Regular
Joined
Apr 25, 2002
Messages
104
Hello Wizards,

Does anyone know how I can copy and paste formulas from specific columns to other rows by row count. For example:

Let say I have 16 rows of formulas.
G2 has a formula, as does H2, G3, H3,G4, H4,G5, H5 Etc.

Now, let’s say the next set of data only has 12 rows of formulas, how do I copy the formulas to those 12 rows only?

And the next set of data may have 15 rows of data.

I know I can sort and cluster by row count (all the 16s together, all the 15s together, all the 12s together).



Forever grateful

Frank

:oops:
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

jcvoth

Board Regular
Joined
Feb 23, 2004
Messages
198
Having trouble visualizing what you want here exactly. Any way you can use htmlmaker to post an example?
 

fb250r

Board Regular
Joined
Apr 25, 2002
Messages
104
Re: [b]Copy / Paste formulas by row counts[/b] with Table
Book2
ABCDEFGHIJKLMNO
1IndexSite_IDNgbr_List#ofNgbrsGridsCommentDistanceAway(mi)Site_ID#ofNgbrsNgbr_List
20AD6055177ADAM6016
31AD6903769ADAM6016ADAM690
42CU041983ADAM6016CUMB04
53YO351607ADAM6016YORK35
64CU021483ADAM6016CUMB02
75FK02539ADAM6016FRAN02
80AD69047913ADAM69016
91AD604295ADAM69016ADAM60
102CU043174ADAM69016CUMB04
113CU023010ADAM69016CUMB02
124YO352564ADAM69016YORK35
130AL25212589ALLE2516
141WS035637ALLE2516WEST03
152AL643839ALLE2516ALLE64
Sheet1
 

fb250r

Board Regular
Joined
Apr 25, 2002
Messages
104

ADVERTISEMENT

Book2
ABCDEFGHIJKLMNO
1IndexSite_IDNgbr_List#ofNgbrsGridsCommentDistanceAway(mi)Site_ID#ofNgbrsNgbr_List
20AD60551771.35177930.6964921ADAM6016
31AD69037691.35254050.69524120.00138054.74586328.78933865.5ADAM6016ADAM690
42CU0419831.35699790.69897560.004707416.18288629.97070418.6ADAM6016CUMB04
53YO3516071.35095950.69793440.00157335.408640810.0168036.2ADAM6016YORK35
64CU0214831.36025630.69723620.006543122.4934741.65790725.9ADAM6016CUMB02
75FK025391.35528640.70067730.004972817.09509931.66012219.7ADAM6016FRAN02
80AD69047913ADAM69016
91AD604295ADAM69016ADAM60
102CU043174ADAM69016CUMB04
113CU023010ADAM69016CUMB02
124YO352564ADAM69016YORK35
130AL25212589ALLE2516
141WS035637ALLE2516WEST03
152AL643839ALLE2516ALLE64
Sheet1


Columns G- L contain formulas that I want to paste down, but the blocks of data have varying row counts. I know I can just select the given number of rows and paste what I need, but I have so many rows to paste down to.

Does this make sense?

Thanks,

Frank
 

jcvoth

Board Regular
Joined
Feb 23, 2004
Messages
198
If I understand you correctly, then you want the formula to only be on rows that are not subtotalled. in your example below, you would want it in G3:K7, G9:K12, etc.?

If that is the case, and I know this may be overly simplistic, but can you add an if(isblank) to each of your functions?

example:

=if(isblank($a3),insert your formula here,"")


Let me know if this is what you're looking for.


-Jarrod
 

fb250r

Board Regular
Joined
Apr 25, 2002
Messages
104
Hi Jarrod,

It may a bit more complex than that. You are correct in that G2:K7 are specific formulas.

Do you see that B2 is a block of data with 6 rows associated to it? Look at B8, it has 5 rows of formulas. B13 has 3 rows of formulas.

I need to populate only the rows that are blank with formulas from the B2 thru Kx.

Again, I can copy manually, but I have quite a few rows and blocks. What I have been doing is copying and pasting one less row as I go down the list.

Frank
 

fb250r

Board Regular
Joined
Apr 25, 2002
Messages
104
Hi Jarrod,

It may a bit more complex than that. You are correct in that G2:K7 are specific formulas.

Do you see that B2 is a block of data with 6 rows associated to it? Look at B8, it has 5 rows of formulas. B13 has 3 rows of formulas.

I need to populate only the rows that are blank with formulas from the B2 thru Kx.

Again, I can copy manually, but I have quite a few rows and blocks. What I have been doing is copying and pasting one less row as I go down the list.

Frank
 

Watch MrExcel Video

Forum statistics

Threads
1,122,511
Messages
5,596,581
Members
414,079
Latest member
Frills

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top