Manually Update the formula in table Using VBA

[mahhdy]

Hello,
I have a big table of data, 10000 row and more than 20 formula fields with links to other files... I have to update this table each day by new data (I just update the first column). I wanted a way to manually update these data so it happens per field not as per row (default behaviour of excel table) and I can control the screen updating and manually calculate and so. But I knew a way for directly computing cell values in VBA, something like putting the formula in [] or computing based on the cell address. Any help or idea?

Regards,
M

 

[oldbrewer]

if B1 = 3 and C1 = 4
and you want to add them and put the answer in A1

cells(1,1) = cells(1,2)+cells(1,3)

 

[mahhdy]

Thanks I have a little bit knowledge about this.

I mean something instead of :
.range("table1[test1]").formula= "=vlookup([@code],table2,3,0)"

I write something that allocates values to that range not the formula, I know there is something for that.
Thanks

if B1 = 3 and C1 = 4
and you want to add them and put the answer in A1

cells(1,1) = cells(1,2)+cells(1,3)

 

[oldbrewer]

give us some pretend numbers and a pretend answer - use a left table for one sheet and a right table for another