Excel Forum
-
Counting Number For Similar Value [Closed]
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...
-
Use Macros to copy worksheet and rename using a list of names [Solved/Closed]
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...
-
How to generate a STATIC unique identifier for each Excel row [Solved/Closed]
Hello, How can generate a unique identifier for each Excel row that WILL NOT change when I delete or add rows? System Configuration: Windows /...
-
Two IF forumlas inside an IF formula [Solved/Closed]
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! ...
-
Formula with varying information need pasted multiple times [Closed]
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 =...
-
Master Sheet to affect multiple sheets [Closed]
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 to find grade [Closed]
How find grade in excel, old tell me about the formula
-
Autopopulating multiple sheets from one main sheet [Solved/Closed]
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"...
-
How to sum a number from a range of cells, based on value [Solved/Closed]
Hello, I'm trying to update a spreadsheet that contains our wedding mailing list. The rows contain the invitee name, address and email address....
-
Excel [Closed]
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...
-
Subtracting numbers based on data in another cell [Closed]
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...
-
Name check [Closed]
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?
-
Change the date format in Excel [Closed]
Hello, how I can chnage the format of 12-07-2003 to 2/22/2017 in excel 2010. Give the exact route inder
-
Self-generating sequenced number each time a sheet is opened [Closed]
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...
-
Rank of numbers between specified range [Solved/Closed]
Hello, Dear Sir, I have following data Marks Desired Rank 91.3 2 91.4 2 91.5 1 91.7 ...
-
Paste x Times with Multiple Conditions [Closed]
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...
-
Formatting cells based on certain criteria [Solved/Closed]
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...
-
New Tab Copy Paste [Closed]
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...
-
save as in a macro [Closed]
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...
-
How to use AutoFilter Macro in Excel [Closed]
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...
-
Creating Macro for Auto Updating Multiple Workbooks [Closed]
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...
-
Need help with a Macro that can copy and paste last 10 active da [Closed]
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...
-
Attendance log help [Closed]
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...
-
Copy paste rows from one sheet to another n times. [Closed]
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 ...
-
How to compare excel sheets [Closed]
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...
-
Find matching data in two worksheets and copy entire row [Closed]
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 ...
-
SUM IFS function [Solved/Closed]
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...
-
Excel Macro: Copy formulas across worksheets [Solved/Closed]
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...
-
Rajbha [Closed]
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...
-
How To Get B Column Value Against A Column [Closed]
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...
-
formula search keywords in multiple columns [Closed]
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...
-
Help : Copy Paste to end of list without formatting [Closed]
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 ...
-
Enter value in cell, have range of cells copied to another sheet [Closed]
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. ...
-
Help with comparing and merging 2 spreadsheets [Closed]
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...
-
How to do a macro in Excel with random pics? [Closed]
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...
-
Arrow keys scrolling in Excel [Solved/Closed]
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...
-
Excel work sheet not copy to another sheet [Solved/Closed]
Hello, System Configuration: Windows / Firefox 52.0 I am =DGET(Sheet1!1:156,"NAME",$A$1:E$2) but it is not work
-
Filters will not include cells beyond the first blank? [Closed]
Hello, its not working for i checked into other system System Configuration: Windows / Chrome 60.0.3112.90
-
Help with formula please [Solved/Closed]
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 ...
-
Criteria dependent data transfer. [Closed]
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 ...
-
Subtract last column from first column [Solved/Closed]
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...
-
merge 3 general cells to one date cell [Closed]
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...
-
Bank reference changed format help [Closed]
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...
-
Need help with data sorting & updation [Closed]
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...
-
Cut and paste using vba script [Closed]
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) (...
-
if then else [Closed]
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...
-
Filters for Rows label coming as (blank) [Closed]
Hello, I ran a Pivot on office2013 and some reason my filters for Rows label coming as (blank) Any idea?please? System Configuration: Windows /...
-
Need to calculate monthly avg and yearly miles from odometer [Solved/Closed]
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...
-
Auto-populate info. from master sheet to multiple sheets [Solved/Closed]
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 ...
-
Conditional formatting on multiple rows with different names [Closed]
Hello, I have 4 names in column A SEGMENT - ADULT ORG SEGMENT - CORE SEGMENT - LIGHT SEGMENT - PROACTIVE HEALTH I want to use a conditi...
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover a Disabled Facebook Account
- How to Recover Your Yahoo Account
- How to Create a Gmail Account
- How to Install a VPN
- Facebook Code Not Received
- How to Fix a Blurry Snapchat Video
- How to Get Free Diamonds in Free Fire
- How to Get More Followers on Instagram
- Computer Boots to Black Screen
- How to Upload High Quality Photos to Instagram
- How to Disabled Write Protection on a USB