Hello, I am making a spreadsheet for the calculation of stiffness, a series of very extensive engineering calculations that requires a very meticulous selection of data, so part of them require manual data pasting when making formulas
The spreadsheet calculates the following data for what we will call a bar
M5tBIXh.png
This contains a total of 16 data, according to the numbering in row and column from 1 to 87 (Nx, Ny, Fx, Fy) for each bar
vIr5RCt.png
then this data has to be stored in 4x4 ranges(=linked) in an 87x87 matrix according to the row and column number mentioned above
kuFblXW.png
QoR2sa6.png
this whole process must be repeated for each bar
I tried using IF conditional format, but the ranges for the autofill are different
I thought about using the vlookup but I will get the same error when using autofill, or at least I don't have enough experience with this command
Bookmarks