J
Jim Lee
Hi all,
Based off a parameter query from a database, say I return the data to
an excel worksheet with columns 1 & 2 below. Because the output is
based off criteria, I don't know how many row entries there are for
the first two columns, and I need to make column 3. I'm going to to
need to do this multiple times for multiple queries, so I want to make
a VBA function to make entries in col 3 and stop at the last row. Any
suggestions?
(Col 1) (Col 2) (Col 3)
(row 1) 45 39 =(r1c1 + r1c2)
(row 2) 34 78 =(r1c1 + r2c2)
. . . .
. . . .
. . . .
? ? ? ?
Thanks much in advance,
Jim
Based off a parameter query from a database, say I return the data to
an excel worksheet with columns 1 & 2 below. Because the output is
based off criteria, I don't know how many row entries there are for
the first two columns, and I need to make column 3. I'm going to to
need to do this multiple times for multiple queries, so I want to make
a VBA function to make entries in col 3 and stop at the last row. Any
suggestions?
(Col 1) (Col 2) (Col 3)
(row 1) 45 39 =(r1c1 + r1c2)
(row 2) 34 78 =(r1c1 + r2c2)
. . . .
. . . .
. . . .
? ? ? ?
Thanks much in advance,
Jim