The discussions

How copy rows from multiple excels to one xl

Hello, I am very new to Macros,Now i have one requirement i.e we have three different excel sheets in that when users update something based on the...

1 reply Last reply on 27 Feb 2011 by
rizvisa1

Copy some columns from one excel sheet to oth

Hello, I have got two excel files eg a.xls and b.xls i have to copy some column data from a.xls to b.xls . Both of these files have some common cl...

1 reply Last reply on 27 Feb 2011 by
rizvisa1

Copy rows and update cells macro

Hello, I wonder if anyone could help me with this particular problem. I have a spreadsheet with a column that has a name and another column tha...

1 reply Last reply on 27 Feb 2011 by
rizvisa1

Macro to delete rows with certain values

Hello, I am trying to delete rows that have specific values using a macro my problem is that I have several values that would mean that row needs...

7 replies Last reply on 27 Feb 2011 by
rizvisa1

Excel help

Hello, What is the formula for: If any cell in column B is in Column A, then display 0, if not 1, in C Thank you. Configuration: Windows ...

1 reply Last reply on 25 Feb 2011 by
TrowaD

Excell formula

Hello, i am trying to find a formula so that if i put a value in cell a2 and a valu e in cell a3 then i want in cell a1 it to produce a value eg a...

1 reply Last reply on 24 Feb 2011 by
TrowaD

Third column value from another table

Hi! Saw the other Q&A in this forum but somehow have not been able to get resolution on this. I have two tables as below Table A ...

1 reply Last reply on 24 Feb 2011 by
TrowaD

Excel opening error

C:\programme filesx86\excel phone number format software.xla' could not be found. Check the spelling of the file name, and verify that the file locati...

2 replies Last reply on 23 Feb 2011 by
Banti

Excel macro for comparing data

Hello, Here is my problem. See below for example. (Workbook A) First name Last name Score A1 = John B1 = Doe C1 = 4 A2 ...

4 replies Last reply on 22 Feb 2011 by
Sinn

Copy and paste information from a cell to ano

i am just wondering how to copy and paste information from a cell to another document. i have a formula to figure out the sum of total boxes and i...

1 reply Last reply on 22 Feb 2011 by
RayH

Macro to highlight a row if cells match value

 Solved

Hello, I sorry but I am very new to macros and trying to create one in Office 2003. I need to bold a row if for example column E is greater than a...

2 replies Last reply on 22 Feb 2011 by
sgriffis

Forgot memory card password

Hello, i have lost my Nokia 2 GB password, pls help!

1 reply Last reply on 22 Feb 2011 by
bionik

Count if macro on multiple criteria

 Solved

Hello, Could someone please help me out with a count-if macro on multiple criteria. I have attached a sample file in the below link http://ww1....

4 replies Last reply on 22 Feb 2011 by
Wasem

Number convert to word in excel which formula

 Solved

Dear Sir, Please help me number convert to word in excel which formula Hello, Configuration: Windows XP / Safari 534.13

1 reply Last reply on 21 Feb 2011 by
RWomanizer

Help with excel

 Solved

Hello, i have two speadsheets. the first sheet contains a total column EX: in C4 =SUM(E4+G4+I4+K4+M4) Value of C4 = (339816) on the ...

1 reply Last reply on 21 Feb 2011 by
RWomanizer

Macro not saving file in excel format

 Solved

Hello, I have a coding like this: filename = Range("B3").Value Workbooks.Add Set newwb = ActiveWorkbook ChDir "D:\P3\Jan-11\B2B" ...

4 replies Last reply on 21 Feb 2011 by
RWomanizer

New sd memory card password

Hello, I have purchased a new sd memory card it asking password i unable to found it. i tried puting it in many mobiles and computers. In mobiles i...

1 reply Last reply on 20 Feb 2011 by
Ambucias

Copy data from one sheet to a new workbook

Hello, I have a data in excel and from which i made 4 pivot table on 4 sheets naming sheet1, sheet2, sheet3 & Sheet4. now i have to copied thes...

1 reply Last reply on 18 Feb 2011 by
rizvisa1

Problem in excel

Hello, I have a problem in Excel to which i seeking a solution. I have imported some External data using the Query option and I am able to Refr...

1 reply Last reply on 18 Feb 2011 by
rizvisa1

If then excel entry

 Solved

Hello, In excel, I have a row where hours worked is entered. Directly underneath that row is another row where allotted break time needs to be ...

2 replies Last reply on 18 Feb 2011 by
Jen

Reconcile two columns

Sir I m a banker I have to reconcile the entries weekly. Suppose i have two columns A & B like this: Col-A Col-B 3456 789 2000 3000 789 ...

5 replies Last reply on 18 Feb 2011 by
rizvisa1

Repeat formula within cell

 Solved

Hello, im a newb with excel and I need to know how would you make this formula repeat within the same cell.. =IF((AND(E9="DOA",S9="Hardware")),...

5 replies Last reply on 17 Feb 2011 by
MoonMemo

I can't drag the formula

Hello, I have 30 sheets each sheet has a total in A3 and on my 31 sheet is the Grand total . How can i tell excell to copy my total from A3 an...

3 replies Last reply on 17 Feb 2011 by
rayh

Need help about vba excel

hi there.i am working with some vba code now.there are some ranges defined in vba but i cant find them in ranges defined in excel sheet.could u please...

1 reply Last reply on 17 Feb 2011 by
rizvisa1

Help with excel macro please

Hello, I have a list of names in column A, most rows contain only 1 name. However, there are also rows in column A that have multiple names sep...

1 reply Last reply on 17 Feb 2011 by
rizvisa1

Create a backup copy

 Solved

Hello, How do I create a backup copy of original file every time I run macro in excel? Thanks Configuration: Windows 2000 / Firefox 3.6.13

2 replies Last reply on 17 Feb 2011 by
may

Excel- add values between two dates

I have a spreadsheet on Excel in which there are dates of when contractors invoiced us and when they were paid. I need to work out the total days invo...

1 reply Last reply on 17 Feb 2011 by
rizvisa1

Copy and paste from paste link cell

Hello, I need your help with code to paste values from cells in a row with a paste link for data in each cell into a spread sheet as a data colle...

1 reply Last reply on 17 Feb 2011 by
rizvisa1

Add same value of a column

 Solved

I have two columns A & B like this A B 32 7000 33 8000 32 9000 33 6000 39 10000 and so on, I would like to get in column...

2 replies Last reply on 17 Feb 2011 by
Banti

Conditional formatting in excel 2007

 Solved

Hello, I am trying to apply conditional formatting to a calculated cell (For ex A). Criteria: If Cell A value = Cell B or " - " then ...

17 replies Last reply on 16 Feb 2011 by
Toast

Hide blank columns

Hello, I am writing a Macro that will hide blank columns, but leave columns with data in them alone. Here is my macro: Sub HideColumns() ...

1 reply Last reply on 16 Feb 2011 by
venkat1926

For got my yahoo password

 Solved

Hello, sir i forgot my yahoo password in 2 question i remember one and another i do not remember please help me iwill be obliged i am orgnly i...

1 reply Last reply on 15 Feb 2011 by
Ambucias

I forget my yahoo password

 Solved

Hello, my name is roshan i loss my yahoo account password. i remember only my alternet email and one secret question .pls hep me Configuratio...

1 reply Last reply on 15 Feb 2011 by
Ambucias

Select and copy only nonblank cells

 Solved

Hello, many thanks in advance for any responses I get here, I have toiled in vain on this for hours now. At first it was acceptable to simply c...

5 replies Last reply on 15 Feb 2011 by
Ambucias

Help with conditonal formatting

 Solved

Hello, On our work tracker we have a 10 business day turnaround to get work completed. Currently we have a formula that works out how long it...

2 replies Last reply on 15 Feb 2011 by
croppman

Data validation without a static named range

Hello, all: First time post-er. Thx, in advance, for any and all assistance. I'm working in MS Excel 2010. I am trying to create a drop-down l...

1 reply Last reply on 14 Feb 2011 by
venkat1926

Date diff in excel 2010

 Solved

Hello, So I want to figure out how to write a formula for a difference in days on a "visit log". I want excel to look in multiple cells. (basicall...

2 replies Last reply on 14 Feb 2011 by
Mark

Max value

Hello, What formula can I use in Excel to find the max value for POR, BAR and DAR? see below.. Thanks A B 1 POR 2 2 BAR 3 ...

1 reply Last reply on 14 Feb 2011 by
TrowaD

How to name excel sheets on values in columns

 Solved

Hello, I have a list of people names in a column in one sheet with additional cells in each row for adding data. I want to create separate excel s...

8 replies Last reply on 14 Feb 2011 by
eskagsms

Pasword recovery for memory card

 Solved

Hello, i have noika 5233 and i had put a password for the memory card and now i have fought the password so if u can help me ...... Plz

1 reply Last reply on 13 Feb 2011 by
Ambucias

Ms office 2010/2007 to 2003

Hello, I have some documents at MS word 2010. I could not open these files to MS Word 2003 in my office PC where installed the MS word 2003 only. I...

2 replies Last reply on 11 Feb 2011 by
rizvisa1

If formula currencies

Hello, I am trying to use if formula for a table where i have 4 currencies and if one of the currencies matches the one that i have on top to div...

1 reply Last reply on 11 Feb 2011 by
rizvisa1

Count distinct values where condition satisfy

Hello, I a trying to count distinct values of Column B for a given value of Column A. For example, if a number 000759BY5 (column A) had two diff...

1 reply Last reply on 11 Feb 2011 by
rizvisa1

Delete row with red font

Hello, I need to delete any rows that have a cell with red font in it. Can you please help me make a simple macro? Thanks! Configuration...

1 reply Last reply on 11 Feb 2011 by
rizvisa1

Repeat 'x' value in nth column for y times

Hi frds, i am doin a project in excel. in that i hav columns headin product, capacity, qty,customer, delivery date etc. i need to asign work to the...

1 reply Last reply on 11 Feb 2011 by
rizvisa1

Pdf's opening in photoshop 4.0 & not adobe!

 Closed

Hello, I recently installed Photoshop 4.0 and ever since I did, every time I try to open a PDF it no longer uses my Adobe 7.0, it now defaults to the...

Last reply on 10 Feb 2011 by
Masonmedia

Multi ranges to auto filter in one worksheet

Hello, Is it possible in Excel 2003 to use Auto Filter more than once (twice) on ONE worksheet? I have a worksheet containing two ranges of informat...

2 replies Last reply on 10 Feb 2011 by
Issa

Conditional formatting (> 3 conditions)

 Solved

Hello, I am creating a grade book in EXCEL (Office 2003) and need to have more than three conditions for colouring the cells. Very simply, I have x...

2 replies Last reply on 10 Feb 2011 by
yendor

Copy_search_copy_paste_macro

Hello, I am trying to create a macro. I am using a workbook with three separate pages I need the macro to copy the contents of a single c...

2 replies Last reply on 10 Feb 2011 by
Dave

Entering row value in excel formula from cell

Hello, I want to make an sheet that pulls text from Sheet1 into Sheet2. This is a simple use of the "=" key, but, I want to select the row this d...

1 reply Last reply on 9 Feb 2011 by
rizvisa1
Results 6651 - 6700 out of a total of 12,269