Hello Excel friends
I have to export tables from summarized worksheet to different files, which are used as data files in Latex.
Example:
Source:
SheetX:
TableA: Range(A3:F10)
TableB: Range(H3:N10)
TableC: Range(A13:F20)
TableD: Range(H13:N20)
...
Goal:
TableXY.tex or *.txt files
columns delimited by tab,
rows delimited by enter
I have tried and tried with VBA, but I am not skilled enough to be able to write routine.
Thank You very much
Janez
I have to export tables from summarized worksheet to different files, which are used as data files in Latex.
Example:
Source:
SheetX:
TableA: Range(A3:F10)
TableB: Range(H3:N10)
TableC: Range(A13:F20)
TableD: Range(H13:N20)
...
Goal:
TableXY.tex or *.txt files
columns delimited by tab,
rows delimited by enter
I have tried and tried with VBA, but I am not skilled enough to be able to write routine.
Thank You very much
Janez