The discussions
Write text in adjacent cells if one cell value is ___?
SolvedHello, My knowledge of excel is very basic, but I am interested to know if I can find an easier way to enter information. I'm a tea manufacture...
Help! need to copy only some columns in rows that have x condtn
SolvedOK, Full disclosure, I am a Novice Excel user at best.....I have a Google Sheet Workbook that contains Google Form Responses (the Sheet name that thes...
Use of '@' in formulae
SolvedHi, I have received a spreadsheet with cells in column E containing the following formula [@[Retail Price]]/[@[Pack Size]]*100 Where the "Reta...
How do i change date format in (dd.mm.yyyy)
SolvedHello, How do I change the date format from (dd/mm/yyyy) format to (dd.mm.yyyy) format? And how can I get today's date in dot format (dd.mm.yyy...
Conditional formating question
SolvedHi I need help with changing the color of a cell based on the Text values in the cells below it. So say B1 is the cell i want to change. B2-B7 has ...
If formula with dates
SolvedHi, I would like to set an IF formula which flags me if someone has been working with us as temp for more than 12 weeks... so I have start date and en...
Creating master spreadsheet for mailing information
SolvedHi there, So I am creating a workbook, for work, for our marketing, and I need help. We are completely revamping what has been done before and I wa...
Macro only for alphabetic sheets
SolvedHello, I would like to request for a Macro which will run only for those sheets where Names started with Alphabets from A to Z Thanks & Regards...
Excel vba to open a eula script when opening a spesific workbook
SolvedHi Everyone I am busy designing a training pack with formulas in a excel workbook using MS Excel 2013 and have it already password protected using vb...
Copy all rows with specific name to new sheet
SolvedDear Friend, Am having a Excel Timesheet with following columns SITE - EMP NAME - EMP ID - EMP JOB TITLE - DATE - TIME IN -TIME OUT - TOTAL - NOR...
Converter for pdf to word document
SolvedHello, I would like to know how to get the software for converting PDF documents to Word documents.
Macro that will allow tab 1 's information to be copy to tab 2
SolvedHello, Please help. My Excel Workbook has two tabs. Tab 1 contains all project information such as project number, customer name, project name, co...
Transfer a row of data from one sheet to another same workbook
SolvedHello, I am trying to transfer a row of data from one sheet to another in the same workbook but my code is not working could anyone help me thanks...
Convert number to letters in excel
SolvedHello, I have to define the numbers to their associated letters and based on the combination of numbers the next cell should show the letters. ...
Convert date of birth into words
SolvedSir, Kindly help me in changing date of birth into words. Example:20.03.2001 as twenty march two thousand one
Automatically moving data
SolvedHello, I have a master data sheet that one column in the sheet that represents a sub set of the data. When I add information to the master sheet, I ...
Location master file in excel
SolvedI have location master file in excel. 1) I have another file in A2 column there is a address like 422, Ashok Vihar, New Delhi, 2) i want to brin...
If statements
SolvedHello, I have a scenario working with a time sheet. So basically the way payments work is from 30 minutes to 5 hours is automatically 5 hours of w...
Memory card password recovery
SolvedHello, i have nokia 5130 expressmusic mobile phone with 2 GB micro sd memory card .ihave forgot the password of memory card can any body tell me the...
Verifing-vin numbers
SolvedGood Afternoon, I have two Excel Worksheets, Mobile Equipment List, and USDOTALLBasics. Both contain the Vehicle Id Numbers. Is there a way to comp...
Formula that searches in a row for a cell/column that contains
SolvedHi. It would be greatly appreciated if someone could assist me with the following formula in excel: I would like a formula that searches in a ro...
Error in vba
SolvedHey, So I Have the following code: Sub GesamtlisteAenderung(ByVal Target As Range) Dim x As Integer If Intersect(Target, Columns("B:...
Replace function in macro
SolvedHello, I would like to request that in the range D11 to D510 if "-" or " -" or "- " this found then it would be replace with " ". Please do it ...
Securing a excel workbook
SolvedHey! I Need to save a Workbook strictly as a Template where the peolple at work can't screw it up. I'd like to have it so that they can open my...
Copying function using vba
SolvedHello, I have a Problem that desperately Needs to be fixed: I am trying to create a Participant List, and in order to Keep it "clean", am using ...
Dell inspiron 1545 system/admin. password
Solved/ClosedHello, my friend bought a Dell Inspiron 1545 at an estate sale.It has the system/administrator password enabled. I'm hoping someone can try to generat...
Copy formulas from one sheet to another all at once
SolvedIs it possible to copy formulas from one sheet to another all at once? I have a worksheet that I would like to use as a template and I'm having to cop...
Excel doubt - if formula
SolvedHi, Im stuck in an if question. I have 3 colums. In the first one I have a number, in the second column a have "yes" and in the third column I w...
Add worksheets to excel workbook using count defined name
SolvedHello, I need to add worksheets based on a count which I defined as ADDTABS located in cell B4 on a worksheet called QRY-CMW. The worksheets ne...
Publisher?
SolvedHi, just joined looking for Publisher, which I thought I had found. The only problem is it ask for a key code and it is all in French. Advice please?
Pdf e-mail attchmnts open to word by default
SolvedHello, When I receive an e-mail with a pdf attachment it opens as a word encoded document (e.g. garbage). I need to change the default settings f...
Text format to date/month/year on excel
SolvedHello, I have a huge list of data that has multiple dates/year along with different time format. I want to delete the time and obtain only the d...
I want to retrieve value from multiple sheets of same workbook
SolvedHello Everybody,.. I have a situation where I request your support, My active workbook has 4 working sheets (sheet1- Master, sheet2, sheet3, sheet4...
Copy range data in a column to new column.
SolvedNeed help here please !!! Data available : A range of data in a column. Some of the cells are blank. My requirement : Is there any formula where...
Compare two columns
SolvedHello, In the excel, I need to compare Only portion of text in two different columns and return the value in third columns. say example One column...
Counting number of times a value appears if..
SolvedHello, I conducted a survey in which some questions allowed more than one response. Using Excel - I'm trying to count the number of times a cert...
Transfer an entire row from one sheet to another
SolvedGood Evening, I seriously need major help. Please!! Please!! Please!! I have an inventory of over 600+ items (rows) each row has 12 columns with...
Add to excel macros
Solved/ClosedHello, I'm looking to edit a macros code and I'm having some issues. Right now our workbook includes a growing amount of days on a project (day 1, d...
Protected worksheet
SolvedHello, I would appreciate advice as to whether it is possible to unprotect an excel worksheet if the password is forgotten? If it is possible plea...
Copy row only if one cell's value is not 0
SolvedI would like to copy from a sheet to another only the rows in wich a cell ex.A1 has a value different from zero or blank. Thanks a lot!
A variation on the compare 2 columns in excel
SolvedGuys - Please advise and give me a few hints (or if you are generous write a macro for me [only joking ... a bit - please feel free to write it for me...
How to change word in cell using another word in another cell
SolvedHello, I have 2 qns 1) Everytime i enter "Sells" in a cell i want another cell to appear "to" and in the same cell if i key "Buys" i want the o...
Outlook 2010 configuration for mail.com
SolvedHello, I am not able to configure outlook 2010 for mail.com. OS- window 7 64 bit Could you please provide me the server, port details.. Thank y...
If function time
SolvedHello, I am trying to make a rota and I need help with a formula. A1 B1 C1 07:00:00 14:30:00 =b1-a1 The person st...
Reminder
SolvedFriends Hi can anyone please help me? I need to set up a reminder in excel. I have a workbook containing a sheet that contains all our permits and in...
Stupefying differential result!
SolvedHello, in the attached picture you can see that in cell E23 I inserted my budget and in cell E23 I inserted what I actually spent (the same amount) sh...
Dates written in different ways
SolvedHello, I have a spreadsheet with dates written in different ways. August 2010 is written both August-10 and August 2010. How can I change this so ...
Count all cells containing a particular text
SolvedI am using Microsoft Office 2016, and I am trying to make an autimated numerical count of all cells which contains a certain phrase for a table. An e...
Removing "false" from an if statement with a vlookup
SolvedHello, I would like to remove the "FALSE" result I get when using my IF formula. The formula is a VLOOKUP that is looking at 2 different cells. ...
Transfer data
SolvedHello, Is it possible to transfer data for sheet 1 to another sheet i select form a drop down box that contains all the sheet's name in that wor...
