I work in a call center, and I do daily reports in Excel on call information for our customer service reps. I have a program called HiPath Composer which generates this data, and my Excel workbook covers each day for a month and does a lot of calculating at the end of the month. Because of my need for totalling at the end, each CSR must remain on the same line on each day. As not everyone works every day, I hide a person's line if they did not work on a particular day and no data was generated for them.
So here's the problem: This is a huge amount of typing every day and I want to automate the process. Composer will export into an Excel file. However, when I try to copy and paste from the exported file to that day's spreadsheet, I am unable to because some lines in the Excel document are hidden and Excel wants to automatically fill those in. What I need to happen when I copy is for Excel to skip lines that are hidden and only put data into the lines that are showing. I've attempted to set up filters for this and such, but unless I copy line by line (which takes nearly the time of typing the data myself), it will not ignore the hidden lines. Is there an Excel function that will cause the hidden lines to be ignored when copying data or will I need some sort of VB application for this? If necessary, I can send you an example of my Excel workbook and the exported Composer file. HELP!!!
This message was edited by mozzer13 on 2002-05-10 12:40
So here's the problem: This is a huge amount of typing every day and I want to automate the process. Composer will export into an Excel file. However, when I try to copy and paste from the exported file to that day's spreadsheet, I am unable to because some lines in the Excel document are hidden and Excel wants to automatically fill those in. What I need to happen when I copy is for Excel to skip lines that are hidden and only put data into the lines that are showing. I've attempted to set up filters for this and such, but unless I copy line by line (which takes nearly the time of typing the data myself), it will not ignore the hidden lines. Is there an Excel function that will cause the hidden lines to be ignored when copying data or will I need some sort of VB application for this? If necessary, I can send you an example of my Excel workbook and the exported Composer file. HELP!!!
This message was edited by mozzer13 on 2002-05-10 12:40