Excel Forum - solved topics
- Solved
-
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 using vb...
-
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 - NOR...
-
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 name, co...
-
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 thanks...
-
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 letters. ...
-
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 sheet, I ...
-
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 brin...
-
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 of w...
-
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 comp...
-
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 a ro...
-
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, Columns("B:...
-
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 it ...
-
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 open my...
-
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 using ...
-
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 cop...
-
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 I w...
-
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 worksheets ne...
-
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 change ...
-
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 the d...
-
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, sheet4...
-
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 where...
-
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 column...
-
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 with...
-
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 1, d...
-
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 plea...
-
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 for me...
-
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 the o...
-
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 person st...
-
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 that...
-
Reminder Solved/Closed
Friends 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! Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
I 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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...
-
Hiding rows when validation list is changed Solved/Closed
Hello, I have a excel sheet where have two sets of product line. I would need only details for one set of product line visible if i select it in ...
-
Userform to export data to another sheet Solved/Closed
Hello everybody, Please could anyone spare his/her scares time to help me, I'm new in this forum and I hope to be an expert in excel. Your contribu...
-
counting and stop counting days in a cell Solved/Closed
Hello, I need to create a formula for a cell involving number of days between dates. First cell - counts the number of days before and after du...
-
vlookup formula help please Solved/Closed
=IF(PaymentDetails!$B22="","",VLOOKUP(PaymentDetails!$B22,AppMember,4,FALSE))*E22 Please everybody, how do I write this formula so as not to return...
-
Need a formula to sum a column with #Value error Solved/Closed
I need a formula that will sum column i8 to i65536 in cell m7 ignoring #value error. Any help? Thanks.
-
auto copy/paste data if criteria (same value in 2 cells) is met Solved/Closed
Hello from Barcelona, just signed up ... my first question ... excited :) I have 2 tabs. Tab 1 shows in column B the employee number and in col...
-
Duplicating data from one line on sheet 1 to sheet 2 Solved/Closed
Hello, I'm looking for help, I have data in one box on sheet1 one that when I update that data I would like for it to automatically change in a bo...
-
colour changing in rows determined by text in 2 different cells Solved/Closed
Hello, i would like to change the colour of a number of cells in a row if column P contains any text, however the colour it changes to depends on the...
-
transfer data between sheets in excel Solved/Closed
Hello, This involves an attendance sheet. A tab for each month with columns for weekly attedance and a total for the month and a summary tab contai...
-
Compare values of two separate sheets and returning value Solved/Closed
Hello, Configuration: Windows 7 / Chrome 43.0.2357.81 I'm currently working a spreadsheet trying to match values from Sheet 1 Column B with...
-
Recording Macro To Duplicate Page And Rename To Numeric Value Solved/Closed
Good day I am trying to record a macro that duplicates a page and renaming it to another file name but need to follow in numeric order. I have a...
-
Need to find a data in a column and copy below cell data or add Solved/Closed
Hello , Please help me to solve this, it will be very grateful column A column B column c 1......................... .........2 2.................
-
count days in excel Solved/Closed
Hello, How can count dates between 2 cells in excel, 1jan - 2jan to count as 2 days. with =NETWORKDAYS(A1,A2) not count the weekends. Thanks F...
