Filling column with a range of formulas

[mprice214]

Hello all,

First time posting here.

I have a spreadsheet with about 100000 rows. The rows are made up with inspection data from parts and all of them have been put into a single excel file.

Each part has about 100 rows of data. I have created formulas in about 10 rows in a single column. I can then copy those 10 rows to the next set of data and the next, etc. I can even highlight the 100 cells in the column that has the formulas and then drag the copy "+" down to the next part and the next, etc. However, to get all the way down to 100000 would take way too long.

So, is there a quick way to copy a range of cells in a column all the way to the last row in the sheet without a macro.

Thanks in advance.

Mike

[6StringJazzer]

Welcome to the Forum!

1. Select the cells you want to copy (e.g., B2:B11).
2. Hit CTRL-C (or the Copy command)
3. Go to the Name Box (the box in the upper left that shows you what cell you are in)
4. Type in the range of the destination (e.g., "B12:B100000") and hit ENTER
5. Type CTRL-V (or paste command)

The number of cells in the destination has to be a whole-number multiple of the number of cells that you copied, or it will only paste one copy.

[mprice214]

Thanks. My data has gaps in it, so I have to accommodate that. That function just gets me only one copy.

Here is some cheesy code (I am not a VB guy) that I can only get to do 10000 increments because I am getting an overflow error if I try to do anymore. In other words, if I set x to 10000, I can get it to work. Then I can manually increment to the next set at 10000 and go to 20000, etc. However, seems to be stuck at 30000....

Hopefully even with the bad code, you can get a better idea of what I am trying to do.

Please Login or Register  to view this content.

[/code]

I remember variable declarations a little. Stupid of me to use an integer instead of a long or something else......

Mod's note - code tags added for you - this time

[FDibbins]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here