I am trying to get some values from a different workbook into my sheet. The formula I am using is simple, like this: ='I:\ORKUN\Konya\Istatistik\2'!$D$59 what...

I have a spreadsheet B that referes to spreadsheet A. If I sort spreadsheet A then the references for B don't match. What do I need to add to the formula that...

You click on the one you want.

Hello: Would you mind to tell me is it possible to find the average on every day with the following data? Date ...

Is anyone aware of specifications for the random number generator? Namely accuracy, repeatability, etc... Thanks.

When you are using Data Validation List, Is there any way to assign a macro or formula that will choose preselected entries... for example, I have 10 different...

Thanks for the input dave. I am trying to figure out how to take a column of dates and extract a specific range of dates out (ultimatly counting the extracted...

I am new to VB, coming from C. Perhaps had I stated with VB, I would be catching on sooner. I am trying to fill an array of a user-defined data types, which...

I am actually working on a spreadsheet that I would like to use them for but I am having troubling understanding how I can use the statements to my advantage. ...

I would like to reference a remote cell within a function argument, that would return not only the remote cell value, but also the remote cell format. ...

How can I (most easily) do this: Type in item specific information such as a part number into a Excel spreadsheet cell (spreadsheet is already...

After blocking text I can use Ctrl+C to copy but the copy command under the edit menu is always greyed out. Cut and paste are fully functional.

I have a spreadsheet with 1600 rows of information. I am trying to cut and past information from another spreadsheet into it. The cut and past function...

How do I create a three-way datable.

This works in Me why not in XP Workbooks.Open Filename:="C:\My Documents\One\" & _ ActiveWorkbook.Worksheets("sheet4").Range("A1").Value _ & ".xls" Thank...

I want to put a condition in my if statement that asked for a check of any data in a particular cell that is like a certain string of text or contains a...

This is done with the Group and Outline feature. Search Help for Outline. HTH -Dave "kami" wrote in...

Hi, Is it possible to Display Progress bar which runs on its own with a Macro?? Actually i have seen in one of the sites that it is possible but our program...

Consider my following excel sheet A |B |C |D ---------------------------------------------- 1 |Student ...

When using a list for data validation, is there a way to populate the selected cell with a default value from the list? If the cell is selected and the default...