Need help!!

  • Thread starter Thread starter Genevieve
  • Start date Start date
G

Genevieve

Can anyone tell me how to hide rows in a worksheet that don't have
valuable data set in it?
 
Hi Genevieve,

Select the rows in question, RT click, select Hide. Or
through the menus, Format>Row>Hide

Biff
 
Genevieve

1. Hide rows that have nothing in them across entire row?

Select any column and Edit>Go To>Special>Blanks>OK

With blanks still selected Format>Row>Hide

2. Hide rows that have nothing in a particular column?

Select that particular column and repeat the Edit>Go To as above.

You could also use VBA code and a Macro if desired.

Gord Dibben XL2002
 
I'm sorry, I didn't clarify my need. I have a payroll sheet with tons o
data in it. Part of that data includes the employee and employer
contribution to a 401(k) plan. I have created a worksheet directl
linked to the payroll worksheet that will be sent to the 401(k
administrators with payment to allocate the distributions a
appropriate. Since not everyone participates in the plan, I was hopin
to create an if statement of some sort that would hide the row if ther
was no contribution amount. That way the administrators only have t
see a list of individuals that actually participate. Any ideas??
 
You can use MS Query to extract the data from the original workbook.

In the payroll sheet, name the range that contains the data. A dynamic
range would be most flexible:

http://www.contextures.com/xlNames01.html

Then, create a new workbook, and choose Data>Import External Data>
New Database Query.
Select 'Excel Files', click OK
Select your payroll file, click OK
Select your table, click '>' to select the fields, click Next
Select to filter the Contribution amount field, and only include rows
where 'is greater than' and type a zero.
Click Next, click Next, click OK, click OK

To refresh the data later, select a cell in the extracted list, and
choose Data>Refresh Data
 
Unfortunately it is happening on all machines at our
customer end
Click to expand...
well as the server did you enable the access to write on the hdd
because when the customer logs in he/she is a guest of some type
therefore the server may not enable the guest to write on the hdd
therefore you can't save and will crash the program.

another idea is to try updating windows with the new patchs located
MS.

Hope this helps. DA
 
Back
Top