Multiple data positioning into large matrix

[ftp2jz]

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

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.

Then this data has to be stored in 4x4 ranges(=linked) in an 87x87 matrix according to the row and column number mentioned above

this is the final form for each bar​

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

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Multiple data positioning into large matrix
and Multiple data positioning into large matrix
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.