I have a workbook with 600 worksheets. Every worksheet is named by the same naming convention "Table1", "Table2", etc. and data is organized in the same...

Sir, How to add new worksheet on right side of current selected worksheet? When I press Shift+F11, new worksheet comes on left side, but I want it to appear...

I have both dates and currency in the same column. How do I sum the column based on format of the cell? Specifically, how do I sumif only the cells...

I need to get data from several workbooks so I often use the "INDIRECT(ADDRESS" function and reference a variable in a cell for the worksheet name. Now I am...

Hello I have a list of survey names in A3:A726 and peoples names in Y3:Y726. Column Y also contains N/A and blanks. I am doing a summary table on the next...

I wish to create a conditional format formula that will change the background colour in a cell to Blue, if the value of another cell is between to values...

I have a workbook with 2 worksheets. Basically it is a daily sales log. On worksheet 1 the user will input multiple daily sales figures and the date. ...

I have a spreadsheet that has the following 4 columns. Term End Date Evg Term Days Notice Next Avail Termination Date The column "Next Avail...

I have a Workbook with worksheets labeled for each working day which has entries for different locations and quantities deliveries and I need to calculate...

Greetings, I need a date for specific product purchase. The data provided me was arranged as follows: Customer IDs in column A. Subsequent columns are...

I have column A. In Column b i have a formula that selects column a acording to specific parameters. Then I want to sort column b, which has some of column A...

"Sandeep Lohchab" wrote in message ... Sir, How to add new worksheet on right side...

What is the formula to have Excel automatically enter the decimal so all I have to enter is the numbers?

Hi sorry if this is a stupid question, how do I add refresh a pivot table to include data added to the END of my existing data? Do you have to recreate the...

My class is working with Goal Seek. They go to the Data tab and most of the icons are gray shaded and can't be clicked on. One of them is the What If...

I am trying to combine multiple contact lists - I want to not only get rid of the dups, but unfortunately some duplicated rows have data in columns that...

I have a list with two text columns. I want to identify the rows where the cells share a common word. For example, Fujitsu Consulting in col A and Software...

How do I link a range of cells in a column on one worksheet to a range of cells on a line in another worksheet. E.g: the data appearing in 'sheet 1' is on...

Hello all! Does anyone know how I may be able to search a string and extract text from it using the MID and FIND function with multiple FINDS? I have a...

I have created a worksheet with locked and unlocked cells. When I protect the sheet, the cursor will tab nicely through the unlocked cells until I get to a...