Office Software Forum
- Excel (9,851)
- Open Office (117)
- Outlook (652)
- PDF (334)
- PowerPoint (185)
- Word (2,189)
-
copy row from sheet 1 to sheet 2 Closed
Hello, Please help as this is doing my head in.... I Have two worksheets, for arguments sake "sheet 1" and "Sheet 2" within my workbook, I wish...
-
Copy Paste Data in Same column for multiple time Solved/Closed
Hello, i need following manipulation.... Data Before Column "A" 123456 123456 123456 123456 123456 ( After )Column "A" (After copy p...
-
macro Closed
hi friend, i have txt files in folders i want to cumulate all txt files in single file and import data to excel please provide macro for this
-
How to change text color dep.on the value of another cell. Closed
Hello, I have 2 questions: 1. I'd like to change one's name color to red if that is in debt. 2. want to count a. all names (number of all people); b...
-
multiple IF functions with dates Closed
Hello, I am rather new to creating Excel formula I want to create the following rule working with dates: IF date in A1date in A2, then date ...
-
compare a cell whit itself (conditional formating) Closed
Hello, i want to know is that possible to compare a value of a cell with itself. for example i enter "10" in cell B2 tomorrow i want to change it...
-
putting a password on memory card Closed
Hello, I want to put a password on my memory card that has an audio file, but i want to let it play on a mp3 player without typing the password. ...
-
due date reminder ahead of one month and mail that to customers? Closed
dear sir/madam Here there are 6 columns with 'n' number of rows. Column 'E' represents DUE DATE of particular 'Sol ID' and this date is common...
-
Replacing Duplicates Solved/Closed
My Excel spreadsheet is set out as follows: A B C D E F 1 2 14 0 14 14 2 1 13 0 13 13 3 4 4 1 4 4 4 3 3 1 3 17 ...
-
compare and copy in column Closed
I want to copy data in column 'B' when column 'A' is not blank. 'A' column has some blank rows. please give me solution!
-
Excel - Macro to highlight Rows with Duplicate values in a cell Solved/Closed
Geetings, Kindly help us in creating a macro that highlight rows based on duplicate values in a cell [this cell may contain Alphabets, Numbers or ...
-
KEY BOARD SHORTCUTS TO NAVIGATE ALONG AN EXCEL SHEET Closed
Hi all, I would like to know if there is a keyboard shortcut to navigate from, for example sheet 1 to sheet 2 on the same excel file without using th...
-
Macro for copying data from multiple woorkboks in to single wrkb Closed
Hi All, I need to copy data from 20 workbooks and save in the single workbook, by using condition like, " Date " so if run the macro all the workbo...
-
IF function with DATE in Excel Solved/Closed
Hi, hope someone can assit. I need to create a sheet where I must take the current date and add a fulle week or two weeks to the date by selecting an ...
-
How can I create worksheet as date from 1 Jan 15 to 31 Dec 15 Closed
Hello, I would like to create 365 worksheets with sheet name as date. Could anyone help me. Many thanks in advance. :))
-
Highlight duplicate rows based on selected columns - excel macro Closed
Hello All, Require a macro which could highlight the duplicate rows in excel. Duplicate is identified based on the selected columns. Table: C...
-
function in excel that auto identify the words from the other s Closed
I would like to know if there is any function in excel that auto identify the words from the other sheets and apply the formula on that specific cell ...
-
Unprotect sheet greyed out Closed
Hello, i cannot unprotected my Excel sheet please help me with this problem. i appreciate your answers and thank you. Configuration: Wind...
-
How can I convert Tunga font to Baraha Kannada font Closed
How can I convert Tunga font to Baraha Kannada font
-
unprotect sheet greyed out Closed
Hello, i cannot unprotected my Excel sheet :( Configuration: Windows 7 / Firefox 38.0
-
copying data from multiple worksheets to a summary worksheet Closed
I have data in 2 cell ranges (A1:D1) and (Q103:S103) from each of about 150 worksheets to copy to a summary worksheet in the same workbook. In the sum...
-
Excel Macro - Insert Rows between existing cells and copy them Closed
I'm trying to create a macro that inserts 49 blank rows then fills them with the first row, but I need this to be on a loop because I have 800 entries...
-
repeating a list of data x number of times Closed
Hello, I'm working on an agent daily activity sheet and need to put together a sheet that will grab a list of ID#s then repeat for the number of w...
-
Please: worksheet comparison Closed
Hello, Please. I have two worksheets, each with the same 10 or so columns. In the newer one, a few rows have been added, a few deleted. In the man...
-
vba macro entry transfer automaticallly another sheet Closed
Hello sir, four or more entry transfer automaticallly another sheet like name,address,code,qty,in vba base so please help me Configuration: Wi...
-
Corrupt word file - says to use text converter Solved/Closed
Hello, I have been reading some posts about you to repair a file and it says to use the text converter. I dont see how to use it though. I want to ...
-
Macro for copying data from different sheets Solved/Closed
Hello, I am trying to copy data from different sheets to master sheet under the following criteria 1. Master sheet should be generated when ev...
-
IF / AND function and Date range Closed
I am trying to create a spreadsheet that tracks when jobs commence and complete. I have been working with the IF and AND functions but can't quite see...
-
Excel 2007 : Conditional Formatting issue concerning colors Closed
Dears, I've successfully put a conditional format in my document, but I would like to have the whole row in color in stead of only 1 cell. Does ...
-
useing (='sheet'!cell) if the sheet name is depending on cell Closed
Hello, how to use (='sheetname'!targetcell) if the sheetname is in cell A2(sheet1) and the target is C3 ='sheet1'!C3 is working, but the sheet ...
-
Worksheet comparison Closed
I have two worksheets, each with the same 10 or so columns. In the newer one, a few rows have been added, a few deleted. In the many (1000 or so, henc...
-
Batch printing results Closed
We were provided with an Excel spreadsheet that will display data for a case number, which we are then instructed to print. This came with a list of 6...
-
Trying to sum a column that contains various text Solved/Closed
I'm a novice when it comes to excel and I'm hoping someone can help me with a formula. I'm trying to give a value to various text in columns and then ...
-
Trying to add a value if a test result is positive or negative Closed
Hello, I have been asked to build a spreadsheet to calculate patients follow up depending on their blood test result. I will only know if the ...
-
Excel 2007 : Change collor if date today is < given date -30days Closed
Dears, Does anyone know how I can highlight a date in red or green when a given date passes the last 30 days cf date today? ex 1 Today : 15/01/...
-
Excel Query Urgent Please. Solved/Closed
Hello, I have the below data in sheet 1, where as in column A its the activity and column b its the name of person who has done it. and the names ...
-
Is there a FORMULA for this issue? THANK YOU IN ADVANCE Closed
Hello, Please help, the issue goes like this, I want to find a NAME within a RANGE of CELLS and the result would be the LATEST DATE they have i...
-
Text cell text cell Closed
Hello, I need help with the following in Excel, I would like to have text then enter cell form another page then enter more text then another ce...
-
I need a text wildcard in IF Function Closed
I would like to use a formula that does this... I placed the cursor in I20 If G20 is a number, multiply it by $I$4. and put in a in I20 If G20 is a...
-
Excel list item automatically generates a new list Closed
Hi! Hoping someone can help ;D In Cell A1 there is a list called "clothing" (a drop down box). In the list you can choose "T-shirt" or "Sweats...
-
Autopopulate a templated spreadsheet with another spreadsheet Closed
Hello, We use Salesforce.com as our CRM and database, with regular use of reports. Naturally, we use those reports for sales and business developm...
-
Conditional Formatting comparing dates Closed
I have two columns, that each have dates in them. I want to take Column A, subtract 100 days, then compare it to Column B. If Column B is less than C...
-
moving complete lines Closed
i have a workbook with a number of sheets, i would like to have the data on a complete line from one worksheet move to another when i insert data in t...
-
How to copy data from multiple tabs in excel into one single tab Closed
Hi , I need help in excel macros where i need to copy selected data from different tabs in excel to another tab in the excel. What i want: I wan...
-
hot to read a cell value in remote file Closed
PLS. INFORM ME "HOW TO READ A CELL VALUE IN REMOTE FILE" REGARDS M.SELVAKUMARAN
-
Auto Filter Based On Cell Value Closed
Hello, I have a huge database and ever growing. I need to filter based on a cell value Summary!C2 this value is selected from a drop down list....
-
calculation of number of months Closed
Hello, number of months between 1/7/2013 and 26/1/2015 Configuration: Mac OS X Lion (10.7.5) / Chrome 39.0.2171.95
-
Excel file do not open normally. Closed
I have Office 2010 and Windows 7. I have one Excel file which has very abnormal behavior. First I opened it, drafted it a little, then closed. Next da...
-
trying to set up a payroll system for 1 or 2 casual employees Closed
I'm trying to set up a payroll system for 1 or 2 casual employees. Most forums recommend a manual system. Can excel add up a year to date column acros...
-
Copy select columns from a row given a criteria was met Closed
I have been working for quite a while on a spread sheet for a productivity tracker. I have tried to copy and past several codes and editing them, but ...
