Newbie report questions
Posted by John on April 09, 2001 10:55 AM
I am just beginning to learn about macros and was given an assignment at work. This site is great and I would appreciate any help with this report.
I have exported a large amount of data from a database to sheet 4 of my workbook. I have set up sheet 3 to pull data for a specific provider from sheet 4 when I enter the provider's name in a cell in sheet 3. Sheet 3 contains a formula to identify cases that we would like to review. Here is where I am stuck. I am trying to use macros to only print the cases we would like to review. My questions are:
1) I have set up a formula in column O of sheet 3. I want to copy the rows from sheet 3 where the result in column O is greater than 10,000 to the first available rows in sheet 2. Is there a macro that would do this? Will there be a problem with running and printing a report on one provider and then entering the next providers name (changing the data in sheet 3) and running the macro again?
2) I have a formatted report (final report for printing) on sheet 1. I was going to just assign cells on the final report (sheet 1) to cells from sheet 2 (ex. b2 of sheet 1 would be =Sheet2!A1). My problem is some providers will have a ten page final report while others will have just one. Is there a way to have the print area set to just print the cells with data in them?
Thanks again for any help!