Office Software Forum
- Excel (9,724)
- Open Office (111)
- Outlook (635)
- PDF (334)
- PowerPoint (174)
- Word (2,181)
-
Excel macro for comparing data [Closed]
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 [Closed]
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 [Solved/Closed]
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...
-
Forgot memory card password [Closed]
Hello, i have lost my Nokia 2 GB password, pls help!
-
Count if macro on multiple criteria [Solved/Closed]
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....
-
Number convert to word in excel which formula [Solved/Closed]
Dear Sir, Please help me number convert to word in excel which formula Hello, Configuration: Windows XP / Safari 534.13
-
help with excel [Solved/Closed]
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 ...
-
macro not saving file in excel format [Solved/Closed]
Hello, 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 [Closed]
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 [Closed]
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 [Closed]
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 [Solved/Closed]
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 ...
-
Reconcile two columns [Closed]
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 [Solved/Closed]
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")),...
-
I Can't drag the formula [Closed]
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 [Closed]
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 [Closed]
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 [Solved/Closed]
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
-
Excel- Add values between two dates [Closed]
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 [Closed]
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 [Solved/Closed]
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...
-
Conditional formatting in excel 2007 [Solved/Closed]
Hello, 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 [Closed]
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 [Solved/Closed]
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...
-
i forget my yahoo password [Solved/Closed]
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...
-
Select and copy only nonblank cells [Solved/Closed]
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...
-
Help with conditonal formatting [Solved/Closed]
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...
-
Data validation without a static named range [Closed]
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 [Solved/Closed]
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...
-
Max value [Closed]
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 [Solved/Closed]
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...
-
Pasword Recovery for memory card [Solved/Closed]
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
-
MS Office 2010/2007 to 2003 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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! [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...
-
Multi ranges to Auto filter in one worksheet [Closed]
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) [Solved/Closed]
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...
-
Copy_search_copy_paste_macro [Closed]
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 [Closed]
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 [Solved/Closed]
Hi, 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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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...
