Hi,

I have a spreadsheet with two sheets... Sheet1, and Sheet2, that I use as sort of a staging area to format info before bulk uploading to my product database. The products I'm working with at the moment have 10 subcategories below each of them. Sheet1 is the full product database listing. I place new subcategories in blocks of 10 that I plan to add to the database on Sheet2. Sheet2 also holds the default partial category names in cells A2-A11.


Part 1:

I am currently using the following formula on Sheet2, in column C to combine the category name value on Sheet1, with the default partial category name values on Sheet2 (A2-A11). I'll paste two blocks so you have a clear picture of what I mean by blocks of ten.

=CONCATENATE(Sheet1!B3407;" ";Sheet2!$A$2)
=CONCATENATE(Sheet1!B3407;" ";Sheet2!$A$3)
=CONCATENATE(Sheet1!B3407;" ";Sheet2!$A$4)
=CONCATENATE(Sheet1!B3407;" ";Sheet2!$A$5)
=CONCATENATE(Sheet1!B3407;" ";Sheet2!$A$6)
=CONCATENATE(Sheet1!B3407;" ";Sheet2!$A$7)
=CONCATENATE(Sheet1!B3407;" ";Sheet2!$A$8)
=CONCATENATE(Sheet1!B3407;" ";Sheet2!$A$9)
=CONCATENATE(Sheet1!B3407;" ";Sheet2!$A$10)
=CONCATENATE(Sheet1!B3407;" ";Sheet2!$A$11)
=CONCATENATE(Sheet1!B3408;" ";Sheet2!$A$2)
=CONCATENATE(Sheet1!B3408;" ";Sheet2!$A$3)
=CONCATENATE(Sheet1!B3408;" ";Sheet2!$A$4)
=CONCATENATE(Sheet1!B3408;" ";Sheet2!$A$5)
=CONCATENATE(Sheet1!B3408;" ";Sheet2!$A$6)
=CONCATENATE(Sheet1!B3408;" ";Sheet2!$A$7)
=CONCATENATE(Sheet1!B3408;" ";Sheet2!$A$8)
=CONCATENATE(Sheet1!B3408;" ";Sheet2!$A$9)
=CONCATENATE(Sheet1!B3408;" ";Sheet2!$A$10)
=CONCATENATE(Sheet1!B3408;" ";Sheet2!$A$11)


Part 2:

On Sheet2 in the adjacent column D, I use the following code in blocks of ten to pull the higher category id value from Sheet1.

=Sheet1!A3407
=Sheet1!A3407
=Sheet1!A3407
=Sheet1!A3407
=Sheet1!A3407
=Sheet1!A3407
=Sheet1!A3407
=Sheet1!A3407
=Sheet1!A3407
=Sheet1!A3407
=Sheet1!A3408
=Sheet1!A3408
=Sheet1!A3408
=Sheet1!A3408
=Sheet1!A3408
=Sheet1!A3408
=Sheet1!A3408
=Sheet1!A3408
=Sheet1!A3408
=Sheet1!A3408

My question simply is how can I fill these formulas down when they are in blocks of ten? I've tried the fill handle, and copy/ paste... no matter what I do the pattern doesn't stick.


Huge thanks in advance to all who post answers on the board... you're all fantastic!

_________________
Danny Tedesco
http://www.wirelessphonecity.com
Cut the cables and let your data fly...