F

#### F J

without actually seeing the file I’m working with. I have a workbook

with a sheet where the data is set up like this:

A B C D E

10 20 30

40 50 60

70 80 90

In other words, every other column has data. A blank column separates

each column of numbers. And I have another sheet that needs formulas

something like this:

A B C

=100*Sheet1!A1 =100*Sheet1!A2 =100*Sheet1!A3

=100*Sheet1!C1 =100*Sheet1!C2 =100*Sheet1!C3

=100*Sheet1!E1 =100*Sheet1!E2 =100*Sheet1!E3

In other words, I want to be able to copy the formulas down for each

row in each of the columns. But, problem number 1 is that I am trying

to copy a formula down rows when the data is actually going across

columns from Sheet1, and problem number 2 is that there is a blank

column between each column of data on Sheet1. I guess it could be

done manually, but these formulas need to be copied down for hundreds

of rows and this is only one of many similar worksheets. Needless to

say, doing it manually would take a very long time. Is there a quick

way to autofill formulas like this with a pattern of going across and

skipping every other column? I might be missing something obvious,

but I just can’t figure out a quick way to do this. Does anybody know

of one? Thanks in advance for any information, and I’m sorry if my

explanation was confusing.