Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to collect information from other worksheets, and I want to
delete the rows which are empty. Basically, I want to search each worksheet for "True/False". If Worksheet 2 has A1=True, then I want to print on Worksheet 1 (my summary sheet) B1 and B2. If it is false, I want to continue the seach on the second line, etc... Using an "if" statement will list all the true values, but if the values are false it leaves a blank line. I am new to programming, and suspect there is an easy way to create a macro to solve this? Any help? -- Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Very Simple formatting Question | Excel Discussion (Misc queries) | |||
Excel Simple Number Formatting | Excel Discussion (Misc queries) | |||
Simple formatting question.... | Excel Discussion (Misc queries) | |||
simple conditional formatting | Excel Discussion (Misc queries) | |||
Simple? Formatting Question | Excel Programming |