The discussions
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...
How to insert rows dynamically with in group
SolvedHi, currently I am creating a macro, in to that I have data for row and columns. now I want to count the product in column A, with formula =counta (...
Import data from web page to excel
Hi, Whenever i run the report the report data will be stored in web page.I want to import to excel from web page.when i am doing so,the data wi...
Comparing rows of data
Hello, I am trying to compare two sheets of data, column A has the company common key code to compare. Sheet1 ColA - Company Code: 1234 ColB ...
Copy and paste rows based on criteria
Hello, i have used the below macro...it is pasting the rows that match criteria but at the end getting stuck.....when i debug it is highlighting End I...
Macro to search excel
Hello, I'm trying to write a macro so when a number is scanned into Excel (using a bar-code scanner) it searches the sheet to check if that number...
Copy rows from one sheet to another
Hello, I have two workbooks; Workbook 1 has 12 rows Workbook 2 has 12 worksheets that contains the pasted weekly results from worksheet 1. I am...
Macro to design a screen
Hello, I need a macro that will create a screen from data from three excel sheets which contain data like the field with its positon and len...
Needed coding in vbscript
Hello Sir/Madam, It will be helpful for me, if u give coding for "comparing Two XLSheet in different workbook on the basis of th...
Comparing 3 columns of numbers
Hello, have 3 columns of numbers in excel (A,B,C), where B=A+25. What I am trying to determine is if a value found ANYWHERE in column C falls between...
