The discussions
How to concanate two cells "line by line"
SolvedHello, I have one cell that has names separated with alt + enter. On the other cell, I have additional information on those names (also separate...
Text to n rows + copy row and insert n times
SolvedHello, I would appreciate your help with a macro I am trying to create in Excel 2007. My data is as follows: Column1 Column2 Column3 Column4 D...
Excel macro - set and autofill a range?
SolvedHello, I recorded a macro for excel and part of the code is to create an index column that fills the cell with a row count (i.e. A2=1, A3=2, etc.)...
Transferring data from one worksheet to anoth
Hello, I have data compiled in different tabs - i have one sheet that is a sum of the data. There is text and numbers. How do I set it up that the...
Show date when amend excel sheet
Hello, How to set a formula, so that everytime I do a change in a cell or a cell range - todays date appear in a different cell. In other words...
Excel macro - set and autofill a range?
ClosedHello, I recorded a macro for excel and part of the code is to create an index column that fills the cell with a row count (i.e. A2=1, A3=2, e...
Request for default password - reg.
Hello, I am Vijay, I am using Samsung Metro gt-s3310i mobile, My SMS service is not working in my mobile. I would like to reset the the Master Set...
Cherry mobile q3tv phonelock lost password
SolvedHow Can I Recover my Password Please Really Need Replies
How to copy informations from excel to ees
SolvedHello, I wanna know if anybody can help me to copy 2 columns (supply) from Excel to EES (another program if anyone used it before) and then copy the...
Removing apostrophe (') from the beginning
SolvedHello, I have an excel sheet where I have formulas with an apostrophe in the beginning. Example: '+34+54+56+22 '+34+222+224+556 '+92+922...
Need formula for unique pass/fail rate
Hello Experts, Can someone please help me with this? I need a formula that will allow me to find the unique pass/unique fail rate. (Sorry about...
Copy a1 cell and auto-fill into a column c
Hello, How can I copy A1 cell and auto fill into a column C until the last row same as column A? Thank you! Best Regards, YT Configurati...
Excel - join date and text
Hello, Below formula is returning date with numbers. can you please give me a solution where I can get date and text. =IF(F2="FIBSMSAPTREM"...
Copy the row and paste in a sheet w/ new col
Hello, I am using Excel 2007. I am trying to figure out how to copy a row from one worksheet (in workbookA) and paste to a new row in a differe...
Excel 2007 activex option button default?
SolvedHello, I have two activex option buttons, Yes and No. How do I get it to display "No" as marked as a default? I have created a process that c...
Convert indian currency numeric to words
Solved/ClosedHello, I have one requirement where I need to convert Indian currency numeric to words. Like 100.90 it should convert to Hundred rupees and Ninety...
Help please on excel search
Hello, Need your expert opinion on what formula i should use. Quite new using excel. Scenario: A | B | C | D ...
Printing sequencial numbers in excel
Hello, I am wanting to print out purchase order forms with numbers on them in a order from 1-... If you know how i can do this please let me know as...
How to create a count down formula
SolvedHello all I'd be grateful if anyone could advise on a formula to highlight a cell which would change colour 30 days before the expiry date. I belie...
Copy entire data immediately when entered
SolvedHello, I have a spreadsheet in which I maintain sale records of a no. of polymers. For every polymer (For eg. Adflex Q 100 F), I have a table show...
Moving one excel column to new excel column
Hello, I am a newbie in excel macro stuff. Would appreciate if someone plz help me to get a routine task automated. Let me explain what actually i...
Auto emailing from excell based on cell date
Hello, I have a new query here! I want to be able to send an email alert from to an email address based on date criteria: Example: Today's Da...
Excel date formatting into another column
SolvedHello, I want to check using IF function in one column and change the date format to another column from MM/DD/YYYY to has DD/MM/YYYY in excel 2010....
Count time entries between different hours
Hello, I am trying to count time entries between different hours. I've tried a couple of formulas but so far every formula i've tried does not see...
Activation code difficulty - won't re-enter
ClosedI have been running Office 7 pro for years. I have it on my Windows 7 computer, and I had a system crash, probably a downloaded virus. I needed to...
Excel
ClosedHello, GUYZ I NID HELP WITH THIS HUGE THING OVER HERE AS IT FOLLOWS 1. 1. Enter the following Data into the Spread sheet (marks 12) Aphache ...
Excel - transfer information from file
SolvedHi there! I have run into some problems when transferring information from one Excel file to another. I have a big Excel file with a lot of informa...
Add when multiple criteria is met in rows
SolvedHello, I'm trying to add numebrs when multiple criteria is met! I want to add numbers in B115:BF115, but only the ones that have an "A" in row B8...
How can copy data to bank cells only...
Hello, I need to copy column A to column B, but only copy contain from cells a on column A to cells on column B only when cells on B are blank and l...
Forget my password of n2690
SolvedHello, i forget my password of n2690. Plz suggest some ideas quickly. Configuration: / Opera 9.80
Referencing data from a new worksheet
Hello, I am working with Excel 2007. I know how to fill in a worksheet based on information from another worksheet. This is a simple enough ta...
If fuction
SolvedHello, I would like to right this formula =IF(d5677="Maromix","RESIN-1925",IF(D5677="Marble" or "onyx" or "matamix" or "decoration","RESIN-1600","...
If time take is equal to...
Hello, Here is the situation I would like a formula that will tell me if the truck left on time or not. If truck dose leave on time then it ...
My browsers wont work
ClosedHello, my computer is a hp elitebook but is blocked by my school. the iternet works but when i pull up google chrome and internet expleror they come u...
Sumifs in excel 2003
SolvedSir I was using System with office 2010 and deriving some values by using "Sumifs" function. Now i am using Office 2003 system. When i copied the wo...
Matching/copying data across worksheets
Hello, I hope someone can help me with a little Excel problem I'm struggling with regarding some reports I am trying to pull together, here is a b...
Comparing/matching data across in excel works
ClosedHello, I have manually combined 4 separate reports into 1 workbook with 4 worksheets (1 for each report). Each row represents a separate job. T...
Cannot access all office 2003 file
SolvedHello, after i scanned my computer with eset nod32 i cant open/copy/move the encrypted(green font color) ms office file such as excel and word. ...
Macro for excel values to new sheet/new row
Hello, I have an Excel worksheet with drop down menus for selecting 10 colours which links to a source sheet to show the pigments needed for produ...
Create new worksheet & copy the based on date
SolvedHello, Can any one help me to copy the excel sheet data from one sheet to another sheet? -> I have one excel sheet (name: Test.xls, sheet name: S...
Save tab-delimited as semi-colon delimited
I see multiple postings on this issue all over the web with no solutions other than to write/use a macro... I am looking to save an excel workbook wit...
Copy worksheet to another workbook (unopened)
SolvedHello, I want to copy a portion (A1:F54) of my current worksheet that I am working on, over to another workbook, that is not open. I want to use ...
Custom number format including text
Hello, I'm really sorry if this is a 'silly' question, but I'd really appreciate any help that any of you great volunteers may be able to give me. ...
Unable sending mails from outlook
Hello, I am suddenly unable to send mails from outlook. Can receive, however. It's urgent! Any help is appreciated! Thanks, Katerina Conf...
Delete from first sheet and copying to other
Dear Friends, i have problem with excel sheet. i have two excel sheet that have lots of data. i want to delete from first excel sheet then nee...
Autorun a macro in excel based on sheet name
Hello, I use the personal.xls which has many macros incorporated into it with shortcut names. The application I use that opens Excel names the sh...
Pdf attachment cant open in outlook2007
Hello, i cant open pdf attachment throw my outlook2007 but i can open same pdf attachment throw my iphone plz help me give solution.. Confi...
Formulas not copying from worksheet to sheet
Hi There, my excel has been doing some funny things lately. 1. When I copy a formula from one worksheet to another, the actual formula does not ...
Create inquiry for quotation
SolvedHello, I'm Mike, I'm a mechanical engineer, in my company we send inquiries for quotations. I have two Excel file the first is a table where all t...
