I have been entering data from surveys into an Excel spread sheet. Each respondent may have up to twelve types of problems that they will have written...

I need to do an if and statement something like this- if A1=1 and A2x(A1)110 then no more than 10, but if A2=2 and A2xA125 then no more than 25 so if A2= 12...

I recorded macro that imports a text file and adds headers to the columns. When I run the macro it opens a new workbook and inserts the text file. Is is...

Hi - I Hope that somebody may be able to help me I need to highlight duplicate rows in a spreadsheet using vba and to display a message box indicating that...

on excel,i've been using v-lookup to get values in the same row from one column but i was wondering if it was possible to use data in 2 columns and get a value...

Is there any option available in exel, where customer can just click and select the item they want.

Note I mistakenly posted this in "excel.misc". Not trying to cross post. Sorry. Hi, I have two columns 300+ rows long. One (A) contains names. One (B)...

I need a formula that basically works like this.... If the total (currently =F14-F47) is less than zero show zero, else show the number. any...

I need a crash course on macro and forms, Specific thing I need to know how to do is to create a sheet that gives me the specific salesperson on a specific zip...

I am trying to find a means to track the different grants we get for our research that also provides a means for our Executive Director to quickly view them...

I am using excell and woul like have invoiced goods automaticaly deducted from inventory spread sheet.

I'm using Excel to carry out simple accountancy tasks. I'm using autosum to total up a column of figures to two decimal places. In some worksheets it works...

Hi see my response under microsoft.public.excel.misc you also might like to check out pivot tables see www.contextures.com/tiptech.html for...

When i want to close only one workbook all of them closes and then i have to reopen the ones i want Why?

I am wanting to write a group of childrens stories and am looking for a template that would help me. Does anyone know what I would use? Thank you.

I'm trying to copy and paste Cisco switch port information in to Excel and to be able to sort the port information so it looks like 2/1, 2/2, ...2/21, 2/22,...

How can I change an Excel to thumbnail? Thanks in advance.

Hello - I have report that shows customer account numbers and the date transactions occurred for that account. Some customers have more than one row on...

I would like to type Jan in A2 and AutoFill up to however far the selection goes. However, there are some rows that are hidden. I am not able to autofill the...

Sub Macro1() ' ' Macro1 Macro ' Macro recorded 3/16/2005 by jim ' ' Range("B9").Select Selection.Cut Range("F8").Select