I have 2 Excel Sheets where i want to Use data from one Column from one sheet and compare those values in Other Sheet Colum to know how Many types the...
Hi all, I'm an excel novice and hoping for help. I need to write a macro to 1. Copy worksheet "Alstromeria" and 2. Rename worksheet to the name...
Hello, How can generate a unique identifier for each Excel row that WILL NOT change when I delete or add rows? System Configuration: Windows /...
Hello, I am very new to using excel but somehow have managed to bluster my way around so please let me know if I am barking up the wrong tree! ...
Hello, I have what may be a simple issue. I have a spreadsheet that I need to apply a formula to in certain fields. One formula may need to be =...
Hello, I am not sure how to explain this... I have a master sheet that has a list of all the names and grades for each row alphabetically. I have ...
How find grade in excel, old tell me about the formula
Hello, I'm making an accounting workbook for an organization I am the treasurer for, and I've run into a problem. On the first sheet "Account"...
Hello, I'm trying to update a spreadsheet that contains our wedding mailing list. The rows contain the invitee name, address and email address....
Hello, i have 5 numerical values in 5 columns but in same row and these 5 values need to be compare(e.g whether the five values lies between the t...
I use a cell to show that a number has been deducted from an account. How can I make a subtraction of that amount form a total amount based on the inp...
Hello, How to check the name with two cells. if any part name matched with second cell, it have to be show as TRUE. What formula for this?
Hello, how I can chnage the format of 12-07-2003 to 2/22/2017 in excel 2010. Give the exact route inder
How do you create a ( for example an invoice) self-generating sequencing number so every time an excel sheet is opened it will generate the new number...
Hello, Dear Sir, I have following data Marks Desired Rank 91.3 2 91.4 2 91.5 1 91.7 ...
Hello, I have no real knowledge of macro, but I think macro has a solution to my question I have data in Sheet1 and would like output in Shee...
I want to make a cell change colour based on a number of different criteria: Cell A1 Has an incident date B1 Displays the date 14 days after the inc...
Hello, Being extremely new to VBA I am trying to create a macro that Creates a new worksheet and then have it copy and paste data into the new works...
Hi i am trying to save a copy of my workbook ie p&l report plus the date so i can save it each week, so far the macro i have will print all info and c...
Complete Macro Newb, so I apologize for my ignorance. I know what the problem is, I am just not sure how to fix it. I am filtering one spreadsheet...
Hello, I have been assigned a daunting task to create multiple reports(5) for specific clients in one workbook. This project is large as there ar...
Hey Guys, I am a newbie to these Macros. I need desperate help from the EXPERTs. A few things I need for my macro are: 1. I have multiple d...
Hello, I have an attendance workbook I am working on and need to make different worksheets according to age. I have everything entered into the fi...
Hello, I need help with Macros. I have my primary data(seeking production schedule) on sheet 1. I will have 100-120 rows Of data. Column A(no of ...
Hello, Hi I'm stopping by to know if any one could help me to compare between to sheets in excel with some conditions. Like it finds somethin...
I have one sheet that has about 350k rows and columns A-AW. Column Z contains phone numbers. I have a second sheet that only has phone numbers (about ...
Hello, I need a formula to sum the values in a range of cells if the content in another range of cells equals the text currently in a cell in a co...
So first off, I have no Idea how to program, but I can kind of understand simple programs. Either way, I'm trying to figure out a macro in MS Excel...
I have some columns like this A. B. C. D 8 66 1 86 1 86 1 79 3 78 1 16 99 2 14 8. 10 3. 78 4 11 4 11 1 79 8 66...
Hello I have 3 columns like A B C D 1 2 5 2 5 4 3 9 2 4 8 1 5 7 3 Now I Will Compare A And C Column...How To Get B Column Value...
Hello, I need to find a excel formula (column A) to track keywords in a table with multiple columns. the key words are for example Accor F...
Hello everyone :) System Configuration: Macintosh / Chrome 60.0.3112.113 I'm new to Macros in Excel so I really need some help. Basically I ...
Hello, I have an materials list spread sheet that when I order a line/row, I'd like that row with the amount ordered to transfer to blank sheet 2. ...
Hi, I have 2 spreadsheets; each contain an employee number, but 1 contains the department of the business and the other contains the employee's hom...
I need to do a macro with random pics. When in column "K" in scheet "SHEE4" find word "OK" then replace or paste in next cell random image from folde...
Hello, I'm working in Excel and my arrow keys are moving the entire spreadsheet and are not moving cell by cell up, down, right or left. I do not...
Hello, System Configuration: Windows / Firefox 52.0 I am =DGET(Sheet1!1:156,"NAME",$A$1:E$2) but it is not work
Hello, its not working for i checked into other system System Configuration: Windows / Chrome 60.0.3112.90
Hi, please could someone help me with a formula to add up cells that have data in them. My spreadsheet has data in columns B-N - some of them have ...
Good Morning, I would really appreciate some assistance with regards to a workbook I am creating in Excel 2010 to track equipment movements. I have ...
Hello, I am having a problem i have a excel sheet there are the data for various employees timing. first of all i want to search the last colu...
Hello, I made a mistake formatting my HUGE tour schedule. I thought I was so smart using 3 cells for dates a1= 10 (for 2010), a2= month 1-12, and a...
Hello, I am trying to reconcile some standing order income at work, we have changed bank account and the reference has changed format! The process...
Hello, I have a sheet with 6 coulmns each with (ABC & DEF) some value and different data Column A & D have same values. e.g. A B C D E F I want...
Hello, I'm looking for a VBA script for the following scenario, kind request to suggest a method. Ques: I've a series of columns Range (A:HZ) (...
Hello, Please help me with a formula for Excel(?) in Open Office. I want to say....If =IF(G59=date;then_date;otherwise_0) I am trying to say i...
Hello, I ran a Pivot on office2013 and some reason my filters for Rows label coming as (blank) Any idea?please? System Configuration: Windows /...
Good afternoon, I am having an issue figuring out how to get excel to calculate the yearly mileage and monthly avg by just monthly odometer reading...
Hi, I have been working on an excel sheet for the past month and have not found a solution that would do what I need it to do. I'm sure there have ...
Hello, I have 4 names in column A SEGMENT - ADULT ORG SEGMENT - CORE SEGMENT - LIGHT SEGMENT - PROACTIVE HEALTH I want to use a conditi...
DON'T MISS