Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

There are no ready-made tools for such a highly specialised task. Thus: Doing it by formulae using standard functions and operations (spreadsheet-do) would require to prepare the respective formula in every single cell of the range where probably a dislocated value is to be expected.

Doing it with formulae based on a user function pushing the data by side-effects would -1- violate one of the principles of spreadsheets -2- require to enter the respective formulae either in an extra sheet or in the importing sheet, to activate them after the import, and to disable them later.

Doing it with a user Sub explicitly called should be the better way concerning the above statements.

For a very primitive (inflexible) way to do it, you will need about 25 lines of BASIC code.