Bill_Gates
$163 Billion Dollar Man
- Local time
- Today, 10:02
- Joined
- Oct 22, 2010
- Messages
- 11
So, I want to insert an iterative calculation into successive columns of a table.
Using a loop, I calculate the first the number as use INSERT INTO Table1 VALUES Number1.
Then do the same for Number2, Number3....etc
The result is each calculation on its own record, when I want it all in one.
How can I format my table so it will look like I want it to?
I was thinking:
If record is null, shift cells up.
Is there a way I can do that with vba?
Using a loop, I calculate the first the number as use INSERT INTO Table1 VALUES Number1.
Then do the same for Number2, Number3....etc
The result is each calculation on its own record, when I want it all in one.
How can I format my table so it will look like I want it to?
I was thinking:
If record is null, shift cells up.
Is there a way I can do that with vba?
