ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do i insert lines into a worksheet depending on if data exist. (https://www.excelbanter.com/excel-programming/322734-how-do-i-insert-lines-into-worksheet-depending-if-data-exist.html)

Nutter

How do i insert lines into a worksheet depending on if data exist.
 
I have a variable number of items around which i perform some calculations. I
then want to produce a separate sheet in a customer-friendly manner so i only
want to reproduce those lines for which input information exists. As the
number of lines will vary in each instance i want to automate the design of
the printable worksheet.


All times are GMT +1. The time now is 05:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com