Replies

Devices and Printers worked in the past.
All the printers are attached and usable through Word etc.; they just don’t show in Devices and Printers.
None of the suggestions I’ve seen work (including the “Bluetooth solution”.
I’m, perhaps, looking for a registry hack.

I’d suggest that hiding the worksheet (with or without a password) is more efficient than hiding all the rows and columns

Go to Format>Sheet>Unhide

Use Absolute values.
In your sample, click in to A2 in the formula and touch F4 on the Keyboard. You can also edit the address by hand so that it reads $A$2.
That means always in column A always in row 2.
If you want to also drag the formulas down, use $A2.
Alway column A and adjust the row number relative to the formulas position.

I’ve done this before.
Just a suggestion. Go to Tools>Macro Record macro.
Go to your data page. Go to Data>Filter Auto filter.
Make your selections and then stop the recording.
You’ll have some code that can be used to solve your problem

I’ve done this before.
Just a suggestion. Go to Tools>Macro Record macro.
Go to your data page. Go to Data>Filter Auto filter.
Make your selections and then stop the recording.
You’ll have some code that can be used to solve your problem

Pearson also has an Event change macro that might help:

Date Time Entry

Pearson also has an Event change macro that might help:

Date Time Entry

Here’s everything you ever wanted to know about Dates and Time in Excel CPearson.com .
Format the numbers as time. Seconds are entered 0:0:xx. See Chip’s site for a macro that will allow alternate entries.

Here’s everything you ever wanted to know about Dates and Time in Excel CPearson.com .
Format the numbers as time. Seconds are entered 0:0:xx. See Chip’s site for a macro that will allow alternate entries.

Have you tried the Report Manager?

“Using the Report Manager add-in program, you can combine worksheets, views, and scenarios into printable reports. For example, if you have a Best Case and a Worst case scenario, a Summary view, and a Details view, you can create a report that presents the Best Case scenario in the Details view and another report that presents the Best Case Scenario in the Summary view. Reports that you create are automatically saved with your workbook so that you can print them at any time.
The Excel 2002 Report Manager add-in is not included with Excel 2002, as was the case with previous versions of Excel. To use it, you must first download the Excel 2002 Report Manager add-in from Downloads on Microsoft Office Online. Follow the instructions on the Downloads page to install the Report Manager.”

Have you tried the Report Manager?

“Using the Report Manager add-in program, you can combine worksheets, views, and scenarios into printable reports. For example, if you have a Best Case and a Worst case scenario, a Summary view, and a Details view, you can create a report that presents the Best Case scenario in the Details view and another report that presents the Best Case Scenario in the Summary view. Reports that you create are automatically saved with your workbook so that you can print them at any time.
The Excel 2002 Report Manager add-in is not included with Excel 2002, as was the case with previous versions of Excel. To use it, you must first download the Excel 2002 Report Manager add-in from Downloads on Microsoft Office Online. Follow the instructions on the Downloads page to install the Report Manager.”

John Walkenbach has some suggestions

John Walkenbach has some suggestions

Take a look at VLOOKUP. You can place your values in a table and be able to return the answer based on some criteria.