F
F J
Hi, I’m trying to do something that might be difficult to explain
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.
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.
