Replies

Fred:

Your post does not mention if anyone attempted a simple test. In other words, did anyone create a new Apple Excel Workbook and insert a checkbox control? Then upload to cloud and test on an iPhone.

I ask because sometimes coverting files from “numbers” the to Apple Excel and loading to the Cloud could case issues that may not occur if you start with a new workbook and inset the control.

If the test works then copy over as much data as possible from the old to the new and then copy and paste the ‘functional’ checkbox as many times as needed.

Good Luck
TD

A problem I have run into is “pasting” where the Crtl C does pick up the data but Excel will not allow the data to be pasted. If this is the issue it may have something to do with Add Ins. However, Using VBA execute the following “Applicaiton.EnableEvents = False” This resolves the paste issue. Just remember to make the statement “True” once done copying so Excel is back to full functionality.

Regards, Tom D

Ed

Attached is a sample of what I think you are looking for.

However, it may be better to Pivot Table the Data and use the Pivot Table Filters to extract the desired results. By example use the page for the part number.

Hope this can help.

Regards,

TD

Have not seen this specific problem but make sure the Workbook is ‘compatible’ with Exel 2013. This may require that the Workbook be saved using a different extension. Also in Excel 2010 certain workbook with links (especially borken links) causes Excel to freeze. The only way I have resolved this matter is by breaking the offending links.

Hope this helps.

Your Idea is very good but needs some refinement.

Since auto-complete needs all of the informaiton to be in one column you may try this:

At top put in one column all 25 Categoires. Next hide as many rows as you like (say 15) Now the top of the screen has 10 rows. Use the other columns and copy the hidded Category items so they are visible to you.

Hidding the rows should not effect Excel’s auto-completion and you save top side space.

Of course, you can hide more than 15 rows if you like.

hope this helps.

Tom D

Welcome to the Lounge.

Just a suggestion. Skip the Combo Box and Instead Use Auto-complete.
If possible make each of the 25 items unique, by example:
Original List
Machine Repair
Machine Replace
Machine Down Time
Machine Run Time
Revised List
Repair Machine
Replace Machine
Down Time – Machine
Run Time – Machine
Then put the list above the input lines leaving no empty rows between the list and the first input cell
Now by typing the first letter or first letters Auto-Fill will find the right Category and enter it in the current cell.
HINT: If there has to be blank rows between the Categories and the Input put a Period in the blank cells
Also you may want to use View and Freeze the list of Categories at the top of the Worksheet.
As long as the Category Names are unique this will allow fast and accurate input.
Hope this helps.

Zeddy:

You might try http://www.mztools.com/v3/download.aspx, I found this on the Web but have never used the tool

Good Luck

Tom D

Muddy:

Can you be a bit more specific. For Excel to assist you would need to open the workbook every day so that the workbook would compare the due date and the current date. This could be done by using Excel’s Auto Open routines. However this still requires someone to open Excel. What I mean is if someone is away for several days and does not Open Excel you have no protection.

However, if you are using Outlook putting a reminder in Outlook Calendar with a one click “Send out E-Mail” could all be done and skip the Use of Excel. Outlook supports Macro’s.

Regards,
Tom Duthie

D:

One thing that may help, before running the Macro set Excel 2007 Security to the lowest level. Then run your Macro.
After the Macro is done put the security back to the level your IT Group has as the default.

Hope this helps.

TD

For learning VBA you might want to check hte below MS site

http://msdn.microsoft.com/en-us/library/ee814737%28v=office.14%29.aspx

Hope this helps.

TD

Try this

=IF(AND(B1=”all”,C1=”grp”),6,IF(AND(B1=”all”,OR(C1=”Grp-k”,C1=”prv”)),7,IF(AND(C1=”grp”,OR(B1=”AM”,B1=”PM”)),3,IF(AND(OR(C1=”grp-k”,C1=”Prv”),OR(B1=”AM”,B1=”PM”)),3.5,0))))

Good Luck

Dear TMG9671

If this workbook was created in an older version of Excel make sure you have converted it to an Excel 2010 xlsx or xlsm workbook.

In addition, make sure the properties on the check boxes and option buttons are set to “Do Not Move or Size with Cells”

The above should eliminate the problem. If not you may need to post the workbook so everyone in the Lounge can see the issue and hopefully find a work around.

Hope this helps,

Tom

Welcome to the Lounge:

Your might want to try INDEX rather than offset. I have attached an example. You will need to change some formulas to pick up the data you want.

Hope this helps

Regards,

Tom D

You could try going to the actual data that the PT is based on and create a new column. Call the new column somehting like ZERO. Put a formula in the new Column that identifies when data is zero and returns a value. BY Example if each row in the Data has 11 columns of crieteria some which could be zero, expand the Data to include a new Col 12. Then use a formula such as IF(AND(A10 =0, B10 = 0, C10 = 0),25,0) Copy down.
Run the PT and include the new column as part of the PT. Using above example, after the PT is done filter on the new column to exclude all 25’s. Now your zero’s are filtered out of the PT.

Hope this helps.

Welcome to the Lounge

If I understand your question the current Macro is working but it is showing the PATH and FILENAME in COL B, Col C, Etc.

What you want is Col B, Col C, etc just to show the PATH.

To do this you should change the following

Current line myList(1, n) = myDir & “” & MyFileName
New Line myList(1, n) = myDir & “”

Hope this helps you issue.

Regards,

TD