Office Software Forum
- Excel (9,765)
- Open Office (113)
- Outlook (641)
- PDF (334)
- PowerPoint (176)
- Word (2,186)
-
DUE DATE REMINDER IN EXCEL TO NEW SHEET? Solved/Closed
Hello, I Have a problem in this code =INDEX(Master!$B$3:Master!$B$1067,MATCH(TODAY()+30,Master!$H$3:Master!$H$1067,0)) HERE I HAVE COLUM...
-
Compare two sheets and copy cell if match found. Closed
Hi guys. I have two sheets and would like to compare sheet2 with data in sheet1 and copy a cell data from sheet1 to sheet2. Eg: SHEET1 A ...
-
Copying a row to another sheet with a trigger Closed
Hi All, I was preparing an excel workbook, based on the sales pipeline. To simpify, The first sheet has company name and contact column. Titled "...
-
To create new sheet every time new information is added Closed
I am currently creating a wage calculation template in excel. There are 3 sheets currently in my file. First is "employee information". Second is "emp...
-
Excel transfer of comments Closed
from excel file to excel file, how can I get comments updated automatically, similar to vlookup or hlookup? i.e. comment in cell c4 of file abc.xls...
-
different colour for each formula result obtain in one cell Closed
Hello, In Excel , I want different format for formula result in one cell. A1=0 & A2 = THANKYOU =if(A1=0,"OK","NOT OK")&RIGHT(A2,5) ----...
-
Format based on another cell with a letter. Closed
Hello, I would like to know if there is a way to apply a format formula to a cell but to use a letter as criteria instead of a number? Example:...
-
Copy the whole column on to the another column master sheet Closed
Please help. I want to make an excel sheet in which i can copy one whole column onto the another column in all my sheets of master sheet. For exampl...
-
Regarding Pivot Solved/Closed
Hi I am doing Pivot for multplie data . In the Value field ( bottom right ) , I need SUM as default instead of count . I have to drag multiple ...
-
Colouring the rows if some conditions are meeting Closed
I am trying to create a macro of some sort to do some checks to make sure everything is populated correctly. Here is an example of the spreadsheet... ...
-
Paste at end of data Closed
Hello, I'm trying to write something that will copy and paste cells AC10:AQ15 from a sheet called "Format" to the end of column AC on the sheet ca...
-
Need macro code Closed
Hi, I have a data in sheet1 with ID, name ,area, amount,January amt,February amt.....(below month column particular dates are mentioned) Anybod...
-
Counting Words, Names as Number Values Closed
Hi, Ive been searching for a way to count a list of names as a number. I currently have to place a 1 in a column next to the list of names. And have ...
-
Find the first available (empty) cell on a worksheet. Solved/Closed
As a newbee to VBA, my boss has given me an impossible task ... Basically I need to be able to enter one cell worth of data from one sheet of a wor...
-
function for finding unique data in one spreadsheet to a second Closed
Hello, I have a spreadsheet of 500 rows. Each row contains on unique "item Number". I am looking for function that will locate the unique number i...
-
Trying to see if I can even create a Macro! Please help! Closed
I want to know if its even possible to create a Macro whenever I copy/paste information that is provided to me weekly, which in this case is in th...
-
Lookup problem. Solved/Closed
I have a column of 20 dates in col. B spaced by 2 or 3 weeks, and a number beside each one in col. C. In cell C24 I need a formula that returns the v...
-
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 ...
