My company saves 2010 excel workbooks in a shared network drive. The problem is that everyone has access to them so sometimes they are mistakenly deleted. Is...

I have a worksheet with VBA code that has been in use for at least 12 years. It still works flawlessly in XL7 (2007). The code opens a folder which contains...

I'm new to Excel, and struggling with compiling multiple duplicate rows, example: col1 col2 Mark Robbery Mark Murder Mark Arson John Assault John ...

Hi Using 2010 I have a spreadsheet with 276 rows (can be variable) In columns K,L & N, *I have financial amounts some of which are zero or blank. What I would...

I wish to use conditional format type functionality to distinguish between cells that have values only in versus cells with formulas in.

I have been using a VBA module for several years in XL 7 but crashes in 2013. Even when I step thru the code, it will crash about 50% of the way. The code...

Hi guys, I am trying to create a spreadsheet of daily energy use and have the ability to shift the max values to a period when the values are lower....

Hello I am stuck in a wierd situation. I have a data, with which I creates a Pivot. Some of the value coming in Pivot are Zero, however some of those Zeros...

I have and use the Avery Wizard. However, when I open Excel, Word, or Outlook it automatically appears in the toolbar section. I have deleted it over and...

Hello, I am working on a spreadsheet that is tracking additional vacation hours earned by employees as a result of perfect attendance. For every 3 months of...

Good Morning/Afternoon, Was hoping for help with a complicated (to me!) excel issue. Seen others use animals to try and explain there issues so will do the...

My company saves excel workbooks in a shared network drive. The problem is that everyone has access to them so sometimes they are mistakenly deleted. Is there...

i have 1 workbook with about 20 sheets, i need to search this workbook for a name in one column on each sheet. i made a list of the sheets in the 2nd workbook...

I have been asked by my work to create a Lunch Buddy Program. I will need to enter employee names into a list and then have a randomizer select two people at...

Okay I had to code data and possible values were as follows: -2c -2b -2a 99 1a 1b 2 I accidently put them all in the same cell however I need the letters and...

I have multiple worksheets within the workbook. There are tab 1,2, 3, etc. Each tab represent days of month(May). I have a rep stats summary tab to sum up by...

Hello, Please refer attached work sheet . I have inserted a helper colum where i need to insert of formula to find out those customers with certian values....

Hello, Please refer attached worksheet and advise a formula to lookup and then do a calculation and adding IS ERROR to it. Thanks heaps Excel Dumbo

> >Maybe, Myrna will post the entire functioning code module > > Since you asked, here it is. It is generic, i.e. it isn't written specifically > for a given...