Hi All I have a workbook which contains 200 sheets. What I need to do is to insert a "cover" sheet and then create a macro pick up 5 cells from each...

I have an Excel sheet that has 8000+ rows that include contact information. I'd like to move them from all of those rows into 6 columns. Currently it...

Bold is too heavy, normal is too light, I need something in the middle

Dave... try to open this link...so many information about creating drop down list http://www.contextures.com/xlDataVal01.html reza "Dave" wrote: Hi

I am having a problem with formating when I copy a table from a word document into excel. Someone in my company decided to use Word to make a very large table....

I am trying to print an entire workbook and would like the page number to be specific to each worksheet set. For example, my workbook contains 7 sheets, each...

I have a list of mm:ss times in a column. I want to find the average of the list. I have tried different things, but I keep getting 'Divide by zero error'...

In some of my spreadsheets, when I try to use the currency format icon (the one with the $), I get "style 'currency' not found. Why would this happen?

I created a large multi-sheet workbook with lots of Vba macro stuff. This worksheet has been working fine until lately. Just recently after some minor...

What is the Maximum number of cells that correlation function in Excel can calculate?

I have a file with about 100 tabs along the bottom for other tables. I have a row that I need to copy and insert into each one of those (at the top, first...

the broom icon shows in some instances. what does it mean and how do i remove it?

I accidentally hit Ctrl S and saved a document. Unfortunately, I meant to do a Save As, instead. Is there anyway to recover my original document? I haven't...

How do i copy data from one sheet to another, to include the footer and header. I created a log for work. I need 20 of them to be able to fit everyones name...

Hi, Can you please help me identify why this macro is failing with the following error? Runtime error 1004: Sort method of Range class failed Row 7 is the...

I am creating a purchase requisition form in Excel and when users open the spreadsheet I want the requisition # incremented by 1 so we have unique requisition...

Ethan wrote: Hi, I have a Workbook that is displaying one dashed line column divider and one dashed line row divider on all worksheets. What do these...

Hi All I have a workbook which contains 200 sheets. What I need to do is to insert a "cover" sheet and then create a macro to pick up the same five cells...

Hello, I am trying to write a formula that first looksup a number and then runs a calculation from that number. Here is a look at what I have so far: First...

The text in some of my cells is turning blue for no apparent reason. The cells can't be changed back to black by reformatting or changing the cell type. It...