I have a sumproduct formula that was working fine. In my table that it looks up to 1 of the columns contains a formula that returns Q1, Q2, etc... based on...

Hi all (is Luke still listening?), In Range(Cells(rijrij, kolkol), Cells(rijrij, kolkol)) I want to extract the part after position (say) 18 and before...

I am having trouble pulling data from one sheet to another: SHEET 1 A B C D ...

I have been setup signcert within office 2003, and assign its cert into macro, so I can skip the security pop up message whenever I open this file and it...

Hello I am not getting total sum when trying to add following times. I have used H;mm format. I get total of 9:20, which is wrong. How can I get accurate...

Can you tell me the difference between a regular Excel workbook and a binary workbook? We use a shared workbook as a tracking system for our department, and...

I am using Excel to write a program. I would like to incorporate text within the same cell as the result of an equation but the I cannot control the number...

Is there a way to get a formula to return a value instead of an error (#DIV/0, #N/A, etc...) so when I usr that cell in a chart I can get a value at some...

I'm using Excel to record and track my students' attendance and assessment. I would like to know how to get Excel to count up the number of sessions students...

I am trying to open a file from a userForm....When stepping through the code; when it gets to the FileNm part where it sets the Files name to open, it runs to...

Hi I am trying to open multiple instances of Excel using the runas command from the DOS prompt. I am following the DOS command line method because the...

I have a worksheet that I copy cells from other worksheets. Just a simple copy/paste/link works great - unless the original cell is blank - and then it puts...

I'm not sure I am explaining this right I want the data from C21 on sheet 1 in a cell on sheet 2 if the A & B column data matches SHEET 1 row 21 A ...

This should be simple, at least I would think so, but I can't find a way to do it. I have a workbook that imports data from another workbook, then populates...

I am linking to SQL server and creating a pivottable in Excel '07 with the data that's returned. I would like to highlight a row when the last data column is...

Hi, This is Akash Maheshwari. I am stuck with a formula and not able to break through since last few days: I require your help in this relates... I have two...

I am trying to use the countif function but want to include and exclude specific cells within the same column. Row 1 = "4" Row 2 = "4" Row 3 = ...

I added a summary worksheet at the end of the sheets to summarize some info. I will name the range and use it to pull in info from an Access db. I want to...

I have a combo list which is allows multiple selection. I need to be able to display the selection in a different cell. For multiple selections, I'd like...

This is what I get for trying this on my own. I just want a macro that will insert 2 blank rows at the current cursor position. Sub Insert2Rows() ' ' ...