Excel Forum
-
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...
-
How to transfer data automatically in Excel? Closed
Hello, I have a work sheet called installment chart, I want to transfer data of different cells from installment chart to an other work sheet call...
-
How to remove all duplicates found in Sheet 1 and Sheet 2 Closed
Hello, I have an excel sheet and I need some help in writing formula. The excel has Sheet 1 with old data, Sheet 2 with new data and contains s...
-
Copy cells entered in sheets to form a single list in another Closed
Hello, I have a cells in sheets in Excel that I wish, as data is entered, to copy to another sheet and build a list from these entries. i.e. as data...
-
Macro record doesn't paste on the next row Closed
Hi, how to copy data from one sheet to a table on an other sheet using macro records , i faced a problem when i click the button it's working good but...
-
Enter Data into main worksheet and have it update separate WS Closed
I have a workbook that I would like to enter all my data into one main worksheet "2017 Job Cost Analysis" and have that data automatically populate al...
-
WHAT WILL BE THE FORMULA Closed
Hello, if A1>A2 THEN C1+C2 AND IF A1
-
Excel for Mac 15.37 copy row to another sheet Closed
Hi, Im sure this question has been asked before but I can see it anywhere, please accept my apologies if this has already been answered. I have o...
-
Lock a cell based on another Cell in the entire sheet Closed
Hello, I have drop down selection (Yes/No) in Column A, and I need to lock corresponding cell in Column B if the result is "No" in Column A. Please ...
-
How to get the yearly mileage and monthly avg from odometer only Closed
How can I get excel to calculate the yearly mileage and monthly avg by just monthly odometer readings? I Here is my worksheet: https://www.dropb...
-
Conditional formatting depending on another cell Closed
Hi! I have an excelsheet with a namelist in e.g. cell A2:A10 and next to it are numbers. I am looking for a way to format the namelist if B2:B10 >0. I...
-
About Excel. Closed
Hello, Total number of 5 sheets in Excel should be counted on automatic 6th sheet.
-
Date of brith in words 05/06/2016 Closed
Hello, date of brith in words 05/06/2016
-
Update data from one sheet to the next. Solved/Closed
The macro I want just takes data from one tab and adds it to another like an update. i suspect that the macro will take some time to make as the updat...
-
Transferring data into separate work books Closed
Hello, I was hoping to get some advice on the best way to transfer data from one work book to another. Both works books are collecting the same da...
-
Inserted 5 cells in one sheet, automate it in 10 differen sheets Closed
Dear, I am a very beginner in Macros. Could you please help to automate my task. I have inserted 5 different cells in a sheet and would like to...
-
Transfer activity data to new sheet with yes/no criteria. Closed
Hello, I need to prepare the excel summary with the help of Master sheet. If the drop down in master sheet is yes, than that option should be copy...
-
Want the coding to paste some data to another sheet Closed
Hello, I want to copy one data to another sheet. But I want the data to be pasted one after another as many time I submit it System Configurati...
-
Locate 7 digits after 'dell#' in one column and have it replicat Closed
Hi I am trying to locate 7 digits after 'dell#' in one column and have it replicate those digits to another cell.
-
How to look up a value within only a subset of another column? Closed
Hello, Thanks in advance for any help! This is my data: X 1 3 X 2 4 Y 1 5 Y 5 4 Y 3 2 And I want to know, does the value in C1 ('3') ...
-
How to use X or Y as variable in particular cells Closed
Hello, i want use X or Y as variable or unknown, such that when i varies the value of X or Y it should automatically be updated in cells where it is p...
-
Google Sheets to keep up with High School Football Scores Closed
Hello, Ok I am creating a google spreadsheet to keep up with High School Football Scores. I would like help with a formula that allows me to color...
-
Arrow keys not working on spreadsheet Closed
I have unlocked the scroll lock, but no movement on arrows. I tried a Word Document, the arrow keys worked perfectly..Any ideas??
-
Conditional formating - apply on more cells Solved/Closed
Hello, i'm not so familiar with conditional formatting, so I would like to ask something: I'm making a doc where Column A has number values, column ...