Excel Forum
-
Conditional Formatting [Solved/Closed]
I am trying to format column 'O' if the value is greater than zero but where column 'P' does not include "SBNAS735" or "SBTDP443". Help! System Conf...
-
Update cells in a particular column from one sheet to another [Closed]
How do I update cells in a particular column from sheet to sheet. I have a payroll worksheet and occasionally our employees borrow money, I need to co...
-
CountIf statement driven by spesific date and text criteria [Closed]
Hello, Employee Work Code Report I need to summarize every occurrence in column C within each of the same dates in column D (1/1-1/31) and based ...
-
Formula to completed fields [Closed]
Hello, I need a formula to look up values that if it shows all false it's a green light and if it contains at least 1 true value, it's red light. I...
-
Timesheet adding rows [Closed]
Hello, I'm trying to work out a formula so that I can hand off my timesheet to a new manager and have it work correctly. Right not I sum a row of to...
-
Unable to display pic [Closed]
Already Macro enable,picture display issue message is "The Linked image cannot be displayed. The file may have been moved, renamed or deleted. Verif...
-
Copy data from 1 excel list to another excel list [Closed]
How to copy info from 1 excel spreadsheet to another excel spreadsheet. For example, need to copy identification numbers from master list to monthly ...
-
Conditional formatting in googlesheets [Closed]
Hello, I'm using Google Sheets, not sure how big of a difference will be. I'm trying to use conditional formatting between two columns, and I'm not...
-
Need some programming in excel [Closed]
Hello Sir, I am A basic user & new to excel & coding. I will explain what I am looking for , than you can let me know weather it's possible or not. ...
-
copy and paste from workbook to another workbook [Closed]
Hi, I have a master workbook that has various tables on several worksheets. The information carries forward to the master page. I copy lines from thi...
-
Need urgent help with spltng the data copied in another workbook [Closed]
Sub Copy_Script() 'Finds the last non-blank cell in a single row or column Dim myFile As String, cellValue As Variant, i As Integer, j As Integer, a...
-
Transfer data from one sheet to another [Solved/Closed]
Hello, I require some assistance please. I looked at a few answers on this forum, but I am stuck as my VB keeps on giving errors. I wish to automa...
-
Look up a word within a sentence and copy into a next column [Closed]
Hello, I have an excel file with over 10 000 entries, each entry contains a city within the sentence - I also have a database (another sheet) with a...
-
How to transfer data to another work book in excel [Closed]
Hello, I would like to automatically transfer the data to another work book but I do not want to transfer the rows that have blank data. could you ...
-
Date formats [Solved/Closed]
Hello, Can you tell me how to change the format from Sep-01-2015 to the format 2015-09-01? I have tried the format tab under the Date section and Cu...
-
Adding number of days in filtered excel sheet [Solved/Closed]
how to add number of days to columns in a filtered excel sheet
-
complicated auto populate possible or not and if so how. [Solved/Closed]
Hello, I'm using excel to schedule for my business, I have all the customer information on the first sheet and would like to auto populate the other s...
-
Compare columns in two sheets and copy info across [Closed]
Hello, I have two sheets open. Sheet 1 has two columns of data (PO number, Value) Sheet 2 has two columns of data (PO number and supplier) What ...
-
excel formual help [Closed]
Hello, I need a formula, hope someone can help! If i add a date in to cell A2, i want the number 1 to appear in cell A1
-
Making Labels [Closed]
Hello, I want to make some labels for products. i have a sheet with info in columns A-F. Column F contains quantities. I need to make a sheet that ...
-
Transfering information from one worksheet to another [Closed]
Hello, I am trying to transfer information from one worksheet to another, but only if the name shows up on the second worksheet. For example, I h...
-
Formula for assigning numerical value to text [Closed]
Hello, I have a very large excel sheet with names. Some of the rows of names duplicate, sometimes more than once. In each row next to the name is a...
-
code to check if a work centre on sheet 1 appears on sheet 2 [Closed]
Hi, Please help me write a code that will check if a work centre on sheet 1 appears on sheet 2. If it appears in sheet 2 the work centres in sheet 1 ...
-
My arrow key move only four cells [Closed]
Hello, My arrow key move only nearest few cells even in new worksheet My computer HP probook Please help System Configuration: Windows / Chrome...
-
iso 27005 Risk Value [Solved/Closed]
Hi All, I have the following problem: I have two cells that have a text value which can either X or M or H X value is 0, M value is 1 and H value i...
-
Macro for repetation [Closed]
Hello, I have a query how can I repeat the name by using the macro. I have data in one sheet where name are written in this format A 10 B 20 C 30...
-
index & match [Closed]
Hello, I would appreciate help on the following:- I have 2 excel sheets both set out as Tables (Table 2 and Table 3). Table 2 has 4 columns A B C D...
-
excel problem [Closed]
Hello, when im entering something in one sheet it is automatically coming in other sheet, when im deleting something in that sheet same happening p...
-
copy a row from one worksheet to another, based on criteria [Solved/Closed]
Hello, I'm trying to copy rows from my "master" worksheet to another sheet based on criteria in column A. Can I do this? Please help, thanks...
-
Automatic update. [Closed]
Hello, Please help me on this. Is there a formula in which TODAY will not auto update. Let's say I want "2/20/2017" to stay as "2/20/2017" and the ...
-
Automatic Update. [Closed]
Hello, Is there a formula in which TODAY will not auto update. Let's say I want "2/20/2017" to stay as "2/20/2017" and the following day it wont cha...
-
I want to send 120 e-mail with 120 attachments [Solved/Closed]
Hello, I have excel file for salaries. In this file I have all the data for each employee (120 employees) including their e-mails as well. I want ...
-
How to populate multiple rows from one row [Closed]
Thank you for accepting me into the forum & my apologies for asking for help with something that may be too basic or impossible (I hope not). I woul...
-
Animated gifs when saved as HTML [Closed]
I can enter an animated gif into my Excel worksheet, no problem. But I would like to save that worksheet as an HTML file. When I do so, the animated...
-
Formatting Dates [Closed]
Hello, Can you tell me how to change the format from Sep-01-2015 to the format 2015-09-01? I have tried the format tab under the Date section and Cus...
-
Totaling Hours by Code [Solved/Closed]
I'm looking for some excel help please :) I have an excel sheet that I would like to have totals for employee hours, sorted by the code that is enter...
-
change data status in one same column [Solved/Closed]
Hello, i am looking for a command that can use to change data status in one same column. Example : 'Activated' change to 'Expired' when it due. ...
-
link the data to another worksheet.. with specific names [Closed]
Hello, good day. i want to ask how can i use macro to make one click button to transfer data to another form like payslip.. i manually copy p...
-
Conditional Formatting colour cells [Closed]
Hi All, Its my First topic, am looking forward for help me. In my Excel file columns : 1. Sending letter Date 2. duration time 3. expected date...
-
Copy A row from one tab to another based on condition [Closed]
Hello, I have a excel sheet containing several tabs all containing similar data with same column names one for reach month. There is one tab by name...
-
IF statement - [Solved/Closed]
Hello, I'm attempting to create an IF statement. IF a type = 1 then add the total of a corresponding cell to the total amount. =SUM(IF(B24:B51="1...
-
Conditional Copying [Closed]
Hello, I'm wondering how to create a formula where if the value in row H is blank, it will copy the values in rows A:G into another sheet. Help! S...
-
Automatically move data to a new sheet based on a value [Closed]
Hello, I have a spreadsheet that is being used to update a project list on a weekly basis. Every week, the header is changed from Week 1 to Week 2 to...
-
Finding Partial Name Matches in One Column [Closed]
I have a list of names (~20,000) in column A, with address info in columns B-D. Names are stored "LAST, FIRST M" and all exact matches have already b...
-
Total Hours [Closed]
I have an excel sheet that I would like to have totals for employee hours, sorted by the code that is entered. Example: for employee 1 there are ho...
-
Copy a cell based another result [Closed]
Hi, I need some help here.... I need to copy Cell B2 & B3 to another work sheet if cell H2 = "text" and create a list. What I have is a list of em...
-
Copy Column name & row name if cell contains certain date [Closed]
Hello, I am trying to create a new worksheet based on the information in a previous worksheet. It is a training document and need it to pull out who...
-
Need Format [Closed]
Hello, Please advice me the correct format of the formula, IF Sheet1 has a code MRT in cell K9, copy whole K9 Column from A-Z cells in Sheet2 firs...
-
How to compare two excel sheets with varying data - need diff [Closed]
Hello, I am looking for a solution for below scenario. I have 2 sheets with same columns. Every week the data (rows) gets updated , deleted or adde...
-
A:A = B Count C:C [Closed]
Hello, I am trying to figure out how to calculate the value. best example I can think of is if A:A = value of typed in value at Q10 than count numb...
Subscribe To Our Newsletter!
