The discussions
Compare two worksheets and remove duplicated data from one
SolvedHello everyone, I am struggling to find a solution and would value input from fellow users. The Problem: I have two separate worksheets "Customer...
Search for matches from columns on separate sheets.
SolvedHello, I've got a problem that is stumping me, and I hope you all can help. I have two sheets in my workbook and I would like to have a formula, ...
How to copy data between several sheets on vba
SolvedHi, I'm still a newbie on VBA, so I could use a little help on getting some code working. I have several client used for factoring. As such, each i...
Values from one workbook to another
SolvedHello, I need help - I have two worksheets one with costs and formulas I want to pull the answer from the formula block from the one worksheet to t...
Range of cells depending on a condition.
SolvedHello, I am trying to change part of a cell reference for a range of cells depending on a condition. For example, the formulas in column A & E: A...
Match cells in excel with all characters same except one
SolvedHi I was wondering if it was possible in excel to write a formula to perform the following task. I have two columns of data, col A and Col B . For eac...
Auto populate rows from master sheet to other sheets excel 2013
SolvedHello, I'm working on a sheet to autopopulate from data that I've downloaded in Excel format. Currently, I have to recreate the wheel (spreadshee...
Script which can check if a debit has a corresponding credit
SolvedHello, I am new to VBA, and I am searching for a script which can check if a debit has a corresponding credit (same value bue with -/+), and highl...
If functions with dates
SolvedHi, I have recently become part of a restaurant management team. Previously they have used excel very basically, just manually inputting every piece ...
Excel - compare data in two worksheets
Solved/ClosedHello, I need help with the best way to combine information in two worksheets and identify rows where data in colum B and column C has changed on...
Unable to convert date in excel
SolvedI am trying to change all of the dates in an excel spreadsheet to the mm/dd/yyyy format, but when I go to format the cells, it does not change, even w...
Using a comand button to open an external software?
SolvedHello. I'm using Excel and I need do create a comand button to open an external software, e.g. I need do order that button to open "Profis Anchor f...
How to populate a version # change to a text sentence
SolvedHello, Using Excel 2013 What I'm trying to do is I have for example a row that contains information about my software. And in 4 of those cells t...
Dynamic database
SolvedHello, i have a database sheet about spare parts in my store .. this spare pasrts are changed their counted daily , i need the formula that refreash...
Sum different alphabets in an excel range.
Solvedsome one please help me......how to sum different alphabets in an excel range..........example.....range is ...A!:Z1 and i want to sum "P" and C...
Convert mm/dd or mm/dd/yy or mm/dd/yyyy to excel internal format
SolvedI have looked at dozens of articles, but they all talk about converting different forms of mm/dd... etc. to other similar forms. I want to chart bloo...
=if(f21="ctf",i21*15,if(l21="ctf",o21*15,if(f21<>"
SolvedHello, I am at the crossroads with this functions string (doesn't work) any help will be much appreciated... =IF(F21="CTF",I21*15,IF(L21="CTF",O21*...
If function for "specific date" + 15 calendar days
SolvedHello, maybe you can help with the following... I am looking for an IF function that alerts me to "PAY NOW" or to "HOLD" as follows; PRODUCT ENTRY ...
My compliments, great altruism everybody! great forum!
SolvedHello, everybody in the forum! My compliments for your unselfishness and altruism. Your help is VERY MUCH appreciated! A big hello, especially t...
=if(f9:f46="ctf",i9,"")
SolvedHello, I would appreciate any help regarding the above formula - =IF(F9:F46="CTF",I9,"") - I am trying to compute a scheme where if any cell betwe...
Conditional cells filing
SolvedHello guys :), I use Excel 12. What I need help with is a conditional filling of cells, based on values in different cells/in the certain row. I l...
How to use a single part of a cell's date
SolvedSo that's the scenario, I've a date in a Cell (D4) in the format 02/02/2008. I need to compare only the year of the date (2008) and if it's true re...
Help in merging codes
SolvedHi I need help in the following VBA (Macro Codes) in Excel 2013 Code 1: Private Sub Worksheet_Change(ByVal Target As Range) Dim Inva...
Function has too many arguments...
SolvedWhy is excel telling me that this formula has too many arguments? =IF(TODAY()>=B9+15,"PAY NOW","HOLD",IF(u9="PAID","PAID")) I am stationed on ...
Search for multiple substrings and return different values
SolvedI have a cell I2 which contains long string. I want to find out the following: If string in I2 contains "month", then return "Monthly", If string ...
Clicking data in one sheet..saving all those clicked in another.
SolvedHello, I'm working on excel which has names(Col A) numbers (Col B). I'm looking to create a sheet, who by clicking on the number, stores the number ...
Same date in column a on mutiple lines in seperate worksheets
SolvedHi, Not using FILL with copy/paste....Is there a way to create a date range in Column A (IE: 9/1/15) from line 1 going downward when entering multi...
Please help in getting data clubbed in one cell
SolvedPlease inform how to get the following information clubbed in a row Data as follows Required data in a ...
Master sheet to work sheet,
SolvedI have been getting help at this site and I am not able to get into my messages to respond anymore. I am not sure if it is just a work computer issue ...
Accounts data requires automatic analysis
SolvedFive columns headed Value, Type, Food, Household, Medical. The data is in Value and Type listed alongside each other. I wish to have those transfer...
Custom sorting & calculating average based position
Solvedplease help me with this. i want to get the position based on average. but when i put all these in a table, all are getting jammed. please can u h...
Search word from list, match it copy values next to it
SolvedI have a list of product part numbers in one excel document. Now I need to pull the description and pricing from another document which is attached in...
Concatonating within commands???
SolvedOk - I know I said no more scripting, but ... Im still with Excel (VBA) macros and trying to find a way of inputting data from a html sheet (stored...
Comparing columns and returning value
SolvedHello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: C...
Word "false" kept on appearing? =if function
Solved=IF(ISNUMBER(A1),IF(ISNUMBER(B1),IF(ISNUMBER(C1),IF(AND(A1,B1,C1),SUM(A1,B1,C1),"Incomplete Data")))) How is it happen that I put "Incomplete Data"...
Sumproduct based on relative cell
SolvedHello, I can use sumproduct based on information contained in the same range of rows of a column adjacent to it, but I can't figure out how to do ...
Stack range of data to next empty row in other sheet
SolvedHello, I have a set of data in Sheet1 Range("D24:D50") and Range("AC24:AC50") would like to be copied and paste special value to Sheet2 Column A a...
Macro that kills a macro when a new workbook is opened.
SolvedHi All, I am still new at excel macros. I am using a command button to copy all work sheets in a workbook then pasting just the values into a new w...
Excel, how to use macros and conditioning.
SolvedHello, I have been looking up how to use excel to help sort data but ran into a few problems. First I have searched how to delete a row with certain...
Using 'rept' inside 'if'
SolvedHello, i want to do a rating..example.. Artist Rating(numerical) Rating(graphical) akon ...
Date formula
SolvedHello, Can someone please create a formula for these numbers to change to a date. 152030355A, the answer should be 7/22/2015. The first two nu...
Fetch data
Solvedfist sheet Leader id Brand Status product S001 Maruti complete Maruti 800 s002 Toyota complete xyz s003 Maruti complete swift desire s004 Nisha...
Need vba code to create loops please
SolvedI have done loops before but it has been a long time. I need to loop through rows of data and the rows of data changes. The value in column "N" is t...
Vba
SolvedI want to append the month name at the end of the tab names in my workbook I have 86 tabs which are named by employee name and every month I want to ...
Formatting cells
SolvedI'm stuck.... I am creating an invoice of sorts for a company who deals in different currencies. Q1. I have created a drop down list of all products ...
Cutting last 10 charecters of a cell and pasting to next cell
SolvedHi Guys - Im back again with another excel macro problem. I can find all sorts of advice when I google this, but none of it quite matches my needs so ...
Excel formula needed to count a list of names
SolvedHi This is probably an easy one for the pro's, basically I have a list of names that will change as reports are generated. The report will inclu...
Conditional formatting: find text and highlight from other cell
SolvedI have a table with names and number values alternating in a table. I add all the numerical values and highlight based on the total value for each nam...
Get data present in row1 of sheet1 copied into row1 of sheet2
SolvedHello, I need to get data present in Row1 of Sheet1(Central OPD) to be copied into row1 of Sheet2(Departmental OPD) based on Department Column of Sh...
Formula - if c2 is not blank, and b2 is blank, then copy c2 to
SolvedHi all - Am looking for help on formula - I want excel to look at cell C2, then if it has anything (text or numbers), then to look at cell b2. If ...