Excel Forum
- Solved
-
match cells in excel with all characters same except one [Solved/Closed]
Hi 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...
-
Auto populate rows from master sheet to other sheets Excel 2013 [Solved/Closed]
Hello, I'm working on a sheet to autopopulate from data that I've downloaded in Excel format. Currently, I have to recreate the wheel...
-
script which can check if a debit has a corresponding credit [Solved/Closed]
Hello, 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...
-
IF functions with dates [Solved/Closed]
Hi, I have recently become part of a restaurant management team. Previously they have used excel very basically, just manually inputting every...
-
Excel - Compare data in two worksheets [Solved/Closed]
Hello, 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...
-
Unable to Convert Date in Excel [Solved/Closed]
I 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,...
-
Using a comand button to open an external software? [Solved/Closed]
Hello. 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...
-
How to populate a version # change to a text sentence [Solved/Closed]
Hello, 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...
-
Dynamic database [Solved/Closed]
Hello, i have a database sheet about spare parts in my store .. this spare pasrts are changed their counted daily , i need the formula that...
-
sum different alphabets in an excel range. [Solved/Closed]
some one please help me......how to sum different alphabets in an excel range..........example.....range is ...A!:Z1 and i want to sum "P"...
-
Convert mm/dd or mm/dd/yy or mm/dd/yyyy to Excel internal format [Solved/Closed]
I 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...
-
=IF(F21="CTF",I21*15,IF(L21="CTF",O21*15,IF(F21<>" [Solved/Closed]
Hello, I am at the crossroads with this functions string (doesn't work) any help will be much...
-
IF function for "specific date" + 15 calendar days [Solved/Closed]
Hello, 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...
-
My compliments, great altruism everybody! Great forum! [Solved/Closed]
Hello, everybody in the forum! My compliments for your unselfishness and altruism. Your help is VERY MUCH appreciated! A big hello,...
-
=IF(F9:F46="CTF",I9,"") [Solved/Closed]
Hello, 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...
-
Conditional Cells Filing [Solved/Closed]
Hello 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...
-
how to use a single part of a cell's date [Solved/Closed]
So 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...
-
Help in Merging Codes [Solved/Closed]
Hi I need help in the following VBA (Macro Codes) in Excel 2013 Code 1: Private Sub Worksheet_Change(ByVal Target As Range) Dim...
-
Function has too many arguments... [Solved/Closed]
Why 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...
-
Search for multiple substrings and return different values [Solved/Closed]
I 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...
-
Clicking data in one sheet..Saving all those clicked in another. [Solved/Closed]
Hello, 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...
-
Same Date in Column A on Mutiple Lines in seperate worksheets [Solved/Closed]
Hi, 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...
-
Please help in getting data clubbed in one cell [Solved/Closed]
Please inform how to get the following information clubbed in a row Data as follows Required data in a ...
-
master sheet to work sheet, [Solved/Closed]
I 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...
-
Accounts data requires automatic analysis [Solved/Closed]
Five columns headed Value, Type, Food, Household, Medical. The data is in Value and Type listed alongside each other. I wish to have those...
-
custom sorting & calculating average based position [Solved/Closed]
please 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...
-
search word from list, match it copy values next to it [Solved/Closed]
I 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...
-
Concatonating within commands??? [Solved/Closed]
Ok - 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...
-
Comparing columns and returning value [Solved/Closed]
Hello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: ...
-
Word "False" kept on Appearing? =IF function [Solved/Closed]
=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...
-
sumproduct based on relative cell [Solved/Closed]
Hello, 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...
-
stack range of data to next empty row in other sheet [Solved/Closed]
Hello, 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...
-
Macro that kills a macro when a new workbook is opened. [Solved/Closed]
Hi 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...
-
Excel, how to use macros and conditioning. [Solved/Closed]
Hello, 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...
-
Using 'rept' inside 'If' [Solved/Closed]
Hello, i want to do a rating..example.. Artist Rating(numerical) Rating(graphical) akon ...
-
date formula [Solved/Closed]
Hello, Can someone please create a formula for these numbers to change to a date. 152030355A, the answer should be 7/22/2015. The first...
-
fetch data [Solved/Closed]
fist sheet Leader id Brand Status product S001 Maruti complete Maruti 800 s002 Toyota complete xyz s003 Maruti complete swift...
-
Need VBA code to create loops Please [Solved/Closed]
I 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"...
-
vba [Solved/Closed]
I 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...
-
Formatting cells [Solved/Closed]
I'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...
-
Cutting last 10 charecters of a cell and pasting to next cell [Solved/Closed]
Hi 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...
-
Excel formula needed to count a list of names [Solved/Closed]
Hi 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...
-
Conditional formatting: Find text and highlight from other cell [Solved/Closed]
I 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...
-
get data present in Row1 of Sheet1 copied into row1 of Sheet2 [Solved/Closed]
Hello, 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...
-
formula - If C2 is not blank, and b2 Is blank, then copy c2 to [Solved/Closed]
Hi 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....
-
how to sort data according to shift [Solved/Closed]
i want to sort according to person shiht
-
Transfer data and then apply formula [Solved/Closed]
Hello, I have a rather large spreadsheet which records the data from a number of different branches on each separate worksheet (labelled as...
-
Macro to copy/paste specific range every 3 rows [Solved/Closed]
Hello, I am beginner in VBA and now have an Excel sheet with about 4000 rows, where I could need a macro. I already recorded a macro for...
-
Need urgently to find a macro in excel report across sheets [Solved/Closed]
Hi, Anyone a solution? I need a macro that will do the following: 1. Search for a word, a number, ... across all the worksheets in the...
-
Error trying to populate new worksheet using macro [Solved/Closed]
Hey everyone, I've been working on a macro to create a new worksheet based on the information entered into a column of a "data" worksheet which...
