Forum
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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. ...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
combine of column [Solved/Closed]
Hello, 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 [Solved/Closed]
please, I need a macro code that can actually compare two worksheets and flag up the differences using same color to show the dissimilar...
-
conditonal format a because of values in another cell [Solved/Closed]
Hello, 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...
-
Function Formula Date and Text [Solved/Closed]
Good day I am looking for help with a function formula PLEASE. Example Decleration Start Date 2016.02.17 Last inv_ Inventory_ Decl...
-
SPELLNUMBER VBA IN EXCEL [Solved/Closed]
Hello, I alreadly use spellnunber but the problem is it does not convert incorrect for my currency. Present Situation...
-
Conditional formatting on an entire row [Solved/Closed]
Hello, I want an entire row to turn red, only when one cell in that row is less than 0. I tried highlighting the whole row with the formula =A12
-
Copy rows from sheet 1 to sheet 2 if rule is met [Solved/Closed]
Hi I have a contact list I need to extract data from. Full contact list is sheet 1 Names are in A2:A12948 Internal phone numbers in...
-
formula [Solved/Closed]
Hi please I am looking for a formula to get difference between 2 sheets example sheet 1 sheet 2 ndc quantity ...
-
Need cell value copy to defferent -2 work sheets within a Excel [Solved/Closed]
Hello, hi all i need to maintain a MIS on daily basis. in this, i need to enter same values multiple times on individual worksheet within a...
-
excel function to Check neighbour cells match for all [Solved/Closed]
Hi, I need to check if (each) cell in column A is having a match in column B, Example as below: Column A is phone numbers list, column B is...