[NoOne]

These are just tables you could make in a word processor. Looks like you typed all that info in by hand? You can avoid that.

insert sheet from file - the csv. This should be it's own worksheet and nothing else in it. Use the "link" or "data link" option. this way each time you open your spreadhseet it'll update all the data if you update the csv file / replace it with a new one.

The table you want to create should be its own worksheet, too.

Do your table headers and formatting the way you want it... use borders etc.. but you only fill out the first row of the table data by hand using references to the first row of the "data-from-file" worksheet. The fill will also keep all your formatting... zero work after typing in headers, first row of table and any formatting

Same goes for any math applied to that data.. formulas and cell references only. Make use of "!" if you need to lock row, column or both. Stock convrsion factors or constants can be typed in but better to reference a cell.. can more easily 'fix' the table that way if it needs to be changed. edit 1 cell, and it's fixed.

When you use the fill function to complete the table, it will auto-increment cell references where no "!" is used.

You should never have to fill out that table again... everything will auto-update each time you open or tell the program to update links. (depending on default settings, it may be one or the other, initially, but whatever you prefer it to be can be the case going forward).

you should never have to type in data... that should be automatic. It's worth the effort to do this. each time you hand type in all that info, think about it.


you can add sorting optiosn and such to various columns using macro editor. This makes it a bit sketchy when you share it, though.. macros can be malicious but if you are the creator, no worries.. doesn't happen on accident, obviously.

settings of the spreadhseet program you use may be different defaults. if anything i said doesn't play out properly, it's a setting regarding updating links or autoupdating spreadsheet in real time vs when you press a shortcut key to recalculate everything given new data entered etc....

The effort to use these sheets should simply be opening them up then clicking a button to update... you should never have to hand-type anything into a spreadsheet. once it is created it should do it all on its own or by simple 1-step command.