D
DR
I just finished an Excel file that had a mix of a bunch of tables plus a
whole lot of text. The text portion was a nightmare in Excel.
I actually first thought of doing this in Word and importing the tables
from Excel, but it seemed there were issues involving getting the tables
to inform each other properly and so on.
In choosing Excel, I first wrote the text in Word so as to be able to
concentrate on it. In importing it, I found among other things that the
row height limitation is very onerous and unrealistic. Had to import in
little pieces, and got gimpy results with the pastes. Also, since the
report needed the text to wrap around the interspersed tables, I had a
great deal of difficulty with the page breaks. The need to use fully
justified text caused a mess. There were other issues that I won't bore
you with, though it appeared they were inherent in such a process.
I have either used the wrong tools or not used them at all well. I
would appreciate your general or specific thoughts on this. Thanks.
whole lot of text. The text portion was a nightmare in Excel.
I actually first thought of doing this in Word and importing the tables
from Excel, but it seemed there were issues involving getting the tables
to inform each other properly and so on.
In choosing Excel, I first wrote the text in Word so as to be able to
concentrate on it. In importing it, I found among other things that the
row height limitation is very onerous and unrealistic. Had to import in
little pieces, and got gimpy results with the pastes. Also, since the
report needed the text to wrap around the interspersed tables, I had a
great deal of difficulty with the page breaks. The need to use fully
justified text caused a mess. There were other issues that I won't bore
you with, though it appeared they were inherent in such a process.
I have either used the wrong tools or not used them at all well. I
would appreciate your general or specific thoughts on this. Thanks.