Excel Forum
-
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...
-
Need help copying a row [Closed]
Hello, i have a number of rows starting at row B which give details of projects. E.g. ProjectID, END Date, Number of Hours to complete, Number of ...
-
How to create auto sheets and give same headings for all [Closed]
Hello, I have created one macro, by clicking on a button there are multiple sheets created automatically and naming the sheets with the calendar day...
-
VBA Inserting Picture From File with Loops [Closed]
Help please? I am using the below code to insert a picture from a file based on the value of a cell. I just need it to repeat this for every row. Als...
-
Lookup across whole workbook (muliple sheets) [Solved/Closed]
Hello, I would need your help with my problem in MS Excel. Here is the description: 1. I have an Excel workbook containing multiple sheets (ca. ...
-
Macro for follow-up [Closed]
Hello, I receives file every week for an error message from integrations , I would like to build some macro or function which can help me to Identif...
-
Consolidate multiple rows of information into one row [Closed]
Hello, I am hoping someone will be able to help with a VBA Macro or formulas or something. I'm generally at my wits end trying to figure this out. ...
-
Data in Cells Appearing in other Pages [Solved/Closed]
Hello, I am having a problem with entering data into a cell on one page (tab) of a spreadsheet, and having that data show up in the same cell(s) on ...
-
Consolidate multiple rows into one [Closed]
I have a commission file that shows a Customer name in cell D2, customer address in J2 and then the commission details in a changing number of rows be...
-
Autofill Master sheet [Solved/Closed]
I am trying to automatically fill in a table (with whole rows from A-N) on a master sheet (sheet 1) based on whether the data in column H of the table...
-
Macros write a macro from sheet 1 to copy data when selected [Closed]
Good Afternoon- I am new to writing Macros, and would appreciate some help. I want to write a macro from sheet 1 to copy data when selected to shee...
-
Macro in excel [Closed]
Hello, How to copy the following set of data via macro,say, A2 70 times A3 1288 times and so forth on to another sheet with a macro Thanks Syst...
-
Moving of data [Closed]
Hello Team, I am working on a data and I need help. I have 3 sheets namely: FTE;TS;EXIT and this is what I want to do. When I delete someone from F...
-
Deleting data in 7 different sheets before I update workbook. [Closed]
Sub Delete() ' ' Macro4 Macro ' Delete contents in attorney tabs ' ' Keyboard Shortcut: Option+Cmd+Shift+D ' Dim lRow As Long Dim i As L...
-
If cell has text then go to sheet x and insert [Closed]
Hello, I need a formula that can insert text on another sheet. So sheet 1 A1 has text then take that text insert it into Sheet 2 line "to be determ...
