[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:
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
Having trouble visualizing what you want here exactly. Any way you can use htmlmaker to post an example?
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,215
Members
448,554
Latest member
Gleisner2

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
Back
Top