The discussions
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...
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...
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 ...
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...
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...
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...
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...
Hiding rows when validation list is changed
SolvedHello, 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
SolvedHello 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
SolvedHello, 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=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
SolvedI 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
SolvedHello 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
SolvedHello, 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
SolvedHello, 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
SolvedHello, 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/ClosedHello, 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
SolvedGood 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
SolvedHello , 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/ClosedHello, 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...
Combine of column
SolvedHello, How can we show value of more than two column in a single column but in two rows. please reply at the urgent.
Comparing two excel worksheets
Solvedplease, I need a macro code that can actually compare two worksheets and flag up the differences using same color to show the dissimilar rows. Be...
Conditonal format a because of values in another cell
SolvedHello, i am trying to figure out how i can format a cell to show green when above a figure and red when below the figure simple i know but here co...
