Search results

Hi all-- I am trying to do what I thought was easy (wrong :) ). All I want to do is create a button to sort data based on three diffent levels. I am in Excel 2010 but have it in compatability mood to accomodate the rest of the company. I have tried using the insert Button in Form Controls...

Hi all-- Here is a strange one. We have a formula sheet that is protected and only allows users to enter data on a few cells. It would be convenient to use the Styles ==> Calculation feature for this but as the sheet is protected this option is not available. One of salesladies came in...

Thanks, I will have to play with it a bit as ctrl "-" only deletes on cell not the entire row. More fun hehehe LCD

Thankyou, but I am trying to just delete certain rows (found with ctrl+f) without having to unhide them. Any thoughts? LCD

Hi all-- I have 50+ workbooks with 1-5 worksheets per book. All of the sheets have groups of hidden rows (order forms hiding less popular items). My task is to find items we no longer carry and delete them. To open each sheet and unhide all the rows and remember which were hidden after...

Hi all-- Any thoughts on where to get an Excel or Access template for perpetual FIFO inventory? Thanks in advance. Lawrence

Hi all-- I am looking for some templates to build an inventory program with FIFO (first in - first out) in mind. Any thoughts or suggestions would be greatly appreciated. Thanks in advance. Make it an awesome day. :) Lawrence

They are bill of ladings and we hide the items that don't get shipped often but enough that we don't want to always type in the data. Also as I am editing the cells I have to reorganize most of the rows. Thanks for any help. HAPPY NEW YEAR - I hope you obtain the goals you set for your...

Hi all-- I am working on a project that I have to open 100+ workbooks with 1-4 spreadsheets per book. Each spreadsheet has hidden rows that I have to open, highlight in yellow(to remember which ones were hidden), edit various cells throughout the spreadsheet, then hide the original rows. Is...

You are wonderful thank you, now to see if I can get it to work hehehe. Have a great day. ;) Lawrence

Thank you much, is there a way to make this a universal macro for all future workbooks to have and use? Lawrence

Hi-- Thank you very much for this great resource. Even though I don't use every point, I read them and file them all -- maybe one day I will get a chance to use them:). My question is this: I put &[date] into my footers and always get the format dd-mm-yy. I have set the control panel date...