Excel Forum
- Solved
-
comparing 2 columns from 2 different spreadsheets [Solved/Closed]
Hello, Here is what i am trying to do. Spreadsheet 1 column B has customer numbers Spreadsheet 2 column A also has customer...
-
compare two columns input value from another [Solved/Closed]
Hello, Here is what I am trying to do, can some one please help me. In my Excel Workbook I have 2 spreadsheets. The first spreadsheet we...
-
Highlight cell if another cell contains any text [Solved/Closed]
Hello, I have been searching and found several discussions similar to this. However none have them were exactly the same and I haven't found...
-
EXCEL VBA: Application.FileSearch Error in Running Excel 2013 [Solved/Closed]
Hello everyone, I encountered error "Object doesn't support this action" when i run the macro program after upgrade of excel (from 2003 to...
-
Copy paste special into last row of another worksheet [Solved/Closed]
Hello, Thank you for taking your time to read my questions. My question is the following any form of help will be greatly appreciated. I...
-
Roster Management Spread Sheet. [Solved/Closed]
Hello, Can anyone help with a spreadsheet to manage fatigue management. I have a work project where I need 20 people and for both day and...
-
If certain 'type' is in col. K have whole row copy to new sheet [Solved/Closed]
Hello, I am wondering if it is possible to have a whole row copy to a designated sheet based off of the value in a column. So for example if...
-
Finding MAX value with criteria list [Solved/Closed]
Hello Chaps I don't often ask for help here but this one has stumped me. For a dashboard of sorts... I have a list of values in column S....
-
Convert Single Column to Rows, into Matching Rows [Solved/Closed]
Hi, I would really appreciate any help with an issue I currently have. I have a file which downloads as ASCII (text), and when opened in excel...
-
Need help with counting value formula [Solved/Closed]
Hello, I am brand new. I am trying to figure out a score based counting formula. I have columns with Name, Status, Rank and Value I want...
-
Extract data from one sheet to another [Solved/Closed]
Hello, I have two sheets of data with almost same columns but sheet 2 has an extra column. How to match the data of sheet 2 with the data in...
-
Copy a row from one worksheet to another, based on criteria [Solved/Closed]
Hi Im a new user and im trying to make a roster sheet and really need some help any help is absolutely appreciated. I have some good formulas...
-
Write text in adjacent cells if one cell value is ___? [Solved/Closed]
Hello, 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...
-
Help! Need to copy only some columns in rows that have X condtn [Solved/Closed]
OK, 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...
-
Use of '@' in formulae [Solved/Closed]
Hi, I have received a spreadsheet with cells in column E containing the following formula [@[Retail Price]]/[@[Pack Size]]*100 Where the...
-
conditional Formating question [Solved/Closed]
Hi 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...
-
IF formula with dates [Solved/Closed]
Hi, 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...
-
Creating master spreadsheet for mailing information [Solved/Closed]
Hi 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...
-
Macro only for Alphabetic Sheets [Solved/Closed]
Hello, 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 &...
-
Excel VBA to open a EULA script when opening a spesific workbook [Solved/Closed]
Hi Everyone I am busy designing a training pack with formulas in a excel workbook using MS Excel 2013 and have it already password protected...
-
Copy all Rows with specific Name to new Sheet [Solved/Closed]
Dear Friend, Am having a Excel Timesheet with following columns SITE - EMP NAME - EMP ID - EMP JOB TITLE - DATE - TIME IN -TIME OUT - TOTAL ...
-
macro that will allow tab 1 's information to be copy to tab 2 [Solved/Closed]
Hello, Please help. My Excel Workbook has two tabs. Tab 1 contains all project information such as project number, customer name, project...
-
transfer a row of data from one sheet to another same workbook [Solved/Closed]
Hello, 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...
-
Convert number to letters in Excel [Solved/Closed]
Hello, I have to define the numbers to their associated letters and based on the combination of numbers the next cell should show the...
-
Convert date of birth into words [Solved/Closed]
Sir, Kindly help me in changing date of birth into words. Example:20.03.2001 as twenty march two thousand one
-
Automatically moving data [Solved/Closed]
Hello, 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...
-
location master file in excel [Solved/Closed]
I 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...
-
If Statements [Solved/Closed]
Hello, 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...
-
Verifing-Vin Numbers [Solved/Closed]
Good Afternoon, I have two Excel Worksheets, Mobile Equipment List, and USDOTALLBasics. Both contain the Vehicle Id Numbers. Is there a way to...
-
formula that searches in a row for a cell/column that contains [Solved/Closed]
Hi. It would be greatly appreciated if someone could assist me with the following formula in excel: I would like a formula that searches in...
-
Error in VBA [Solved/Closed]
Hey, So I Have the following code: Sub GesamtlisteAenderung(ByVal Target As Range) Dim x As Integer If Intersect(Target,...
-
Replace function in Macro [Solved/Closed]
Hello, 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...
-
Securing a Excel Workbook [Solved/Closed]
Hey! 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...
-
Copying function using VBA [Solved/Closed]
Hello, 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...
-
copy formulas from one sheet to another all at once [Solved/Closed]
Is 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...
-
Excel Doubt - IF Formula [Solved/Closed]
Hi, 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...
-
add worksheets to excel workbook using count defined name [Solved/Closed]
Hello, 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...
-
Changing font color in one cell when % in another cell changes [Solved/Closed]
Hello, I have a balance in B1 of what's owed on my credit card. I have the % of use on that card in D1, IE 35%. I want the font color to...
-
Text format to date/month/year on excel [Solved/Closed]
Hello, 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...
-
I want to retrieve value from multiple sheets of same workbook [Solved/Closed]
Hello Everybody,.. I have a situation where I request your support, My active workbook has 4 working sheets (sheet1- Master, sheet2, sheet3,...
-
Copy range data in a column to new column. [Solved/Closed]
Need help here please !!! Data available : A range of data in a column. Some of the cells are blank. My requirement : Is there any formula...
-
Compare two columns [Solved/Closed]
Hello, 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...
-
Transfer an entire row from one sheet to another [Solved/Closed]
Good Evening, I seriously need major help. Please!! Please!! Please!! I have an inventory of over 600+ items (rows) each row has 12 columns...
-
Add to Excel Macros [Solved/Closed]
Hello, 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...
-
Protected worksheet [Solved/Closed]
Hello, I would appreciate advice as to whether it is possible to unprotect an excel worksheet if the password is forgotten? If it is possible...
-
Copy row only if one cell's value is not 0 [Solved/Closed]
I 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 [Solved/Closed]
Guys - 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...
-
How to change word in cell using another word in another cell [Solved/Closed]
Hello, 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...
-
IF Function Time [Solved/Closed]
Hello, 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...
-
Check if there is a match to a cell in the rest of the workbook [Solved/Closed]
Hello, I've got a workbook that has divided a list between 10 different worksheets (based upon their categorization), unfortunately, the list...
DON'T MISS
- No Sound from Headphone Jack
- How to Block Private Numbers
- Get the Transcript of a YouTube Video
- GTA Vice City Cheat Codes
- How to Download Instagram Videos
- Writing Professional Emails in English
- Credit Score
- Reverse Image Search with Google
- Facebook Confirmation Code Text Not Received
- Sign Up for a Free Netflix Trial
-
Grammarly Keyboard
-
Amazon Fire TV
-
OnLog
-
Tricount
-
Citymapper
-
YAZIO
-
Candy Crush for PC
-
CallApp
-
Garena Free Fire: Spooky Night
-
30 Day Fitness Challenge-Workout at Home
-
Pokémon Masters