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...
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...
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...
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...
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 ...
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...
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 ...
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...
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 ...
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...
Macro to highlight a row if cells match value
SolvedHello, 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...
Forgot memory card password
Hello, i have lost my Nokia 2 GB password, pls help!
Count if macro on multiple criteria
SolvedHello, 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....
Number convert to word in excel which formula
SolvedDear Sir, Please help me number convert to word in excel which formula Hello, Configuration: Windows XP / Safari 534.13
Help with excel
SolvedHello, 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 ...
Macro not saving file in excel format
SolvedHello, I have a coding like this: filename = Range("B3").Value Workbooks.Add Set newwb = ActiveWorkbook ChDir "D:\P3\Jan-11\B2B" ...
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...
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...
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...
If then excel entry
SolvedHello, 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 ...
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 ...
Repeat formula within cell
SolvedHello, 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")),...
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...
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...
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...
Create a backup copy
SolvedHello, 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
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...
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...
Add same value of a column
SolvedI 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...
Conditional formatting in excel 2007
SolvedHello, I am trying to apply conditional formatting to a calculated cell (For ex A). Criteria: If Cell A value = Cell B or " - " then ...
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() ...
For got my yahoo password
SolvedHello, 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...
I forget my yahoo password
SolvedHello, my name is roshan i loss my yahoo account password. i remember only my alternet email and one secret question .pls hep me Configuratio...
Select and copy only nonblank cells
SolvedHello, 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...
Help with conditonal formatting
SolvedHello, 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...
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...
Date diff in excel 2010
SolvedHello, 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...
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 ...
How to name excel sheets on values in columns
SolvedHello, 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...
Pasword recovery for memory card
SolvedHello, 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
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...
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...
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...
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...
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...
Pdf's opening in photoshop 4.0 & not adobe!
ClosedHello, 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...
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...
Conditional formatting (> 3 conditions)
SolvedHello, 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...
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...
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...
