The discussions

Excel: find & offset

 Solved

Hi can someone help me to get a macro code to make following: I have a file in which some cells having data as 10000, > 10000 and some others 10000...

3 replies Last reply on 28 May 2010 by
rizvisa1

Yahoo password

Hello, Configuration: Windows XP / Internet Explorer 8.0 Sir, i am nothing know about internet n computer. May be, My wife is cheat to me... ...

2 replies Last reply on 28 May 2010 by
rizvisa1

Copy/paste cells from different sheets

Hello, I am trying to create a diary using excel to keep track of everything. As I am a referee I want it to have all the games I have refereed on a...

3 replies Last reply on 28 May 2010 by
rizvisa1

Need to get a count with multiple conditions

Hello, Configuration: Windows XP / Internet Explorer 7.0 In Tab # 2 I have a column that has different "sites" in Tab 3 I have a count of a...

1 reply Last reply on 28 May 2010 by
rizvisa1

Code for copying whole data in auto filter

 Solved

Hello, Configuration: Windows 2003 / Internet Explorer 6.0 i am using excel 2007. i recorded a macro to copy segregate the data from data t...

6 replies Last reply on 28 May 2010 by
Jitu

Restore data from outlook express

Hello, refer to your answer, i have remane my outbox name from outbox to xoutbox and my problem gone, but how can i restore my date from outbox fold...

1 reply Last reply on 28 May 2010 by
closeup22

Audio device

Hello, I have lost my driver CD then how will i load the sound and audio devices?? please help Configuration: Windows XP / Internet Explor...

1 reply Last reply on 28 May 2010 by
shanoj_k

I forgot my password

Hello, i forgot my password,thats why i cannot open my deepfreeze.

1 reply Last reply on 28 May 2010 by
ash_perez01

Nokia n95

Hello, Please send me the incoming and outhgoing mail server info for yahoo on my cell phone Thanks Andy Configuration: Windows Vista / Intern...

1 reply Last reply on 28 May 2010 by
ash_perez01

Integrating excel & outlook

Hello Team , Iam trying to integrate excel macro and outlook .Once i click the macro , the macro should sort the data BU wise . There are 11 tabs f...

1 reply Last reply on 28 May 2010 by
rizvisa1

Autofilter tp leave out #n/a in macro

 Solved

Hello, I have a project id in column C , which iam checking from another source data which is there in a differenr tab .So ihave a vlookup fprmula...

6 replies Last reply on 28 May 2010 by
Lavanya

Outhgoing mail server on yahoo mobil

Hello, Please send me the outhgoing mail server for yahoo on my cell phone n95 nokia Thanks Andy Configuration: Windows Vista / Internet Exp...

1 reply Last reply on 28 May 2010 by
ash_perez01

Inserting rows through excel macro

Hello, I have 29 rows of product numbers composed of 6 different products in an Excel spreadsheet. I need a macro formula that will insert five ro...

1 reply Last reply on 28 May 2010 by
rizvisa1

Formatting using vba

Hello, I am creating a macro based application. I wanted to merge almost 20-25 sheets to one sheets. that task is completed. After merging Now...

2 replies Last reply on 27 May 2010 by
Rajesh

Sos...copy paste loop on vb and excel

Hello, I need help to copy a range od cells and want to copy it for "x" number of times given in a cell say "K2". Need the loop to copy for exact n...

1 reply Last reply on 27 May 2010 by
rizvisa1

Score predictor in excel help??

Hi I am doing a world cup predictor spreadsheet in excel. How do I match scores and assign points in excel? eg. If someone predicts england to ...

1 reply Last reply on 27 May 2010 by
rizvisa1

Excel - cond. copy data from tab to tab

Hello, I was hoping someone could help me out with a code for Excel. What I require is a macro or a workaround for Excel to copy a row from o...

1 reply Last reply on 27 May 2010 by
rizvisa1

Sum specific col if rows contain same info

Hello, I would like to add cells in certain columns (for example: a & c) if the data in a certain row (say "8") is the same. I'm sure it's a logic...

1 reply Last reply on 27 May 2010 by
rizvisa1

Newbie needs a macro

Hello, I need a macro that will search for the sku I'm looking for then scroll to the correct column and update the cell with the correct value th...

1 reply Last reply on 27 May 2010 by
rizvisa1

Inserting worksheets

Hello, Is there a way to automatically insert a new sheet in excel each day ? If yes, can the new sheets be formatted as the original sheet and al...

1 reply Last reply on 27 May 2010 by
rizvisa1

Problems with documents opening on diff comps

Hello, I am having problems while in MS Word (have written/edited/corrected many different documents) save the document onto a usb flash drive and...

1 reply Last reply on 27 May 2010 by
xpcman

Use cell value as array name in formula

Hello, I'd like to perform a lookup with a variable array name based upon another cell's value without VB code. Does anyone have a suggestion? ...

1 reply Last reply on 27 May 2010 by
rizvisa1

How to put apassword on usb drive?

Hello, Hi ,I want to ask a question that how i can put a password on my usb drive?please tell me Configuration: Windows XP / Firefox 3.6.3

1 reply Last reply on 27 May 2010 by
closeup22

Receiving one mail four times

Hello, after configure Gmail in MS outlook 2003, i m receiving every mail 4 times, do u have any solution for it. Configuration: Windows Vista ...

1 reply Last reply on 27 May 2010 by
closeup22

I heard that if somebody knows our password o

Hello, I HEARD THAT IF SOMEBODY KNOWS OUR PASSWORD OF GMAIL THEN HE IS ALWAYS ABLE TO SEE OUR CHAT HISTORY WITH THE HELP OF SOME CODES, HOW CAN ...

1 reply Last reply on 27 May 2010 by
closeup22

Want a formula

Hello, I want to get a text data of a perticular cell from sheet1 to a perticular cell in sheet2 Configuration: Windows Vista / Internet Ex...

1 reply Last reply on 27 May 2010 by
Trowa

Conditional formatting with excel

Hello, I'm making a doc where Column A has number values the same as column B and C. For each cell the conditional formating of cell in column C w...

1 reply Last reply on 27 May 2010 by
Trowa

Data matching

Hello, i'm having the data containing six months share markets whole sale deal. it is having around 1163 scripts. for the same scripts i have retail...

1 reply Last reply on 27 May 2010 by
venkat1926

Column to text

Hello, I have created a matrix and am attempting to link my column B with my Row 27. For example column B3 would read Robert and Row 27 C would also ...

1 reply Last reply on 26 May 2010 by
rizvisa1

Can't open 2003 docs. in 2007

Hello, i AM ON LINE STUDENT, RECENTLY i CHANGE WINDOWS 2003 TO 2007. BUT I CAN;T OPEN MY OLD DOCS. WINDOWS 2003. HELP ME PLS.

1 reply Last reply on 26 May 2010 by
rizvisa1

Macro/function question???

Hello, i am currently making a spreadsheet that will log our equipment that is being repaired and have had some luck using the IF statement in th...

1 reply Last reply on 26 May 2010 by
rizvisa1

Macro help!

Hello, I need a macro that will select all rows that have have the word "Japan" in one of the columns. And then Copy and Paste that to Another sheet...

1 reply Last reply on 26 May 2010 by
rizvisa1

Excel copying rows with two conditions

Hi I'm trying to create a dashboard - which will automatically pick up rows based on a condition. I.e. copy the row if its 'closed won' and if it...

8 replies Last reply on 26 May 2010 by
Ash

Why docs open differently lap v desk

Hello, when in word 2003 i save docs on either lap/desk and open either desk/lap. things are missing, not changed or incorrect. mostly opening f...

2 replies Last reply on 26 May 2010 by
alichik

General inquiry

Hello, How do I create a hyperlink on a button in excel ? Thanks Configuration: Windows XP / Internet Explorer 6.0

8 replies Last reply on 26 May 2010 by
rizvisa1

Formula reads only till 12th on month

 Solved

Hello, If I run the following formulae it gives the result only from 1st to 12 of the month. Is there any thing wrong with the formula or with my Ex...

3 replies Last reply on 26 May 2010 by
rizvisa1

Writing a macro

 Solved

Hello, I am trying to get data whcih has been inoutted into one workksheet to copy into another worksheets when it meets a command in one of the c...

28 replies Last reply on 26 May 2010 by
rizvisa1

Lookup for word in company name

Hello, I want to do a "Match" or "Lookup" for a word in a cell. For example I have 1,000 company names. I want to label them into type of compan...

1 reply Last reply on 26 May 2010 by
rizvisa1

Dates formatting in excel

Hi All, Thanks in advance for your help. I am autoformatting my dates in Excel 2007 to read as mmm-dd-yyy (i.e. Jan-01-2010) which is working per...

1 reply Last reply on 26 May 2010 by
rizvisa1

Help! please my interner browser wont open

Hello, My name is Edgar I have a problem with my laptop. the internet browser wont start when i open the internet explorer it closes down by itself....

1 reply Last reply on 26 May 2010 by
ash_perez01

Excel, if fuction with cell text values?

 Solved

Hello, I would like to include the text value of a cell in the statement I have for one of the IF options. So far my formula is -: =IF((B1...

2 replies Last reply on 26 May 2010 by
jen

Forget password

Hello, Hi! I put security lock in my contacts and I forgot the password. How I can open it again? My mobile is Samsung C5212

1 reply Last reply on 26 May 2010 by
dist.urbd

Req: 'if' formula in excel

Hello, In one of my excel formate below mentioned row/coloums are there, Disp. Month IPO # IPO Dt Customer Details Job Name PO No. PO DT Inv N...

1 reply Last reply on 26 May 2010 by
rizvisa1

Excel formula display in cell

Hello, I hope someone can help me. I need to print the step by step values of a formula in a cell for example ilets say: cells(A,3)= Cells...

1 reply Last reply on 26 May 2010 by
rizvisa1

How to copy and paste

Hello, I want to copy something from the 1st worksheet and paste to 2nd worksheet. I have already the code but did not work. What's wrong with t...

1 reply Last reply on 26 May 2010 by
rizvisa1

Excel:conditional formatting stops working

Hello, First of all i am using 3 rules in conditional formatting and those are =AND(c1"",c1today() Green it works perfectly but ...

3 replies Last reply on 25 May 2010 by
rizvisa1

Auto email when cells in range are edited

Hello, Heres my problem: The company I work for currently uses an excel spreadsheet for scheduling. Its annoying and cumbersome. Once updated...

1 reply Last reply on 25 May 2010 by
rizvisa1

Can you look into it ivan?

Hello, I have two excel sheets which have one column "name" in common. In one sheet, the values respective to that column are multiple and in anot...

1 reply Last reply on 25 May 2010 by
rizvisa1

Help me i have lost myy password

pls i have forgotten my password can you give me that back my id is starterfire111@yahoo.com

1 reply Last reply on 25 May 2010 by
francis

Setting up criteria for vba macros in excel

Hello, I need to set up a loop function that will only output the data of the cheapest house, with a pool. Here is what I have so far, but my...

1 reply Last reply on 25 May 2010 by
rizvisa1
Results 8401 - 8450 out of a total of 12,249