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...
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 ...
Hello, My arrow key move only nearest few cells even in new worksheet My computer HP probook Please help System Configuration: Windows / Chrome...
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...
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...
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...
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...
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...
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 ...
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...
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 ...
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...
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...
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...
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...
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. ...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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 ...
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...
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...
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. ...
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...
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. ...
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 ...
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...
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...
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...
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...
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...
Sub Delete() ' ' Macro4 Macro ' Delete contents in attorney tabs ' ' Keyboard Shortcut: Option+Cmd+Shift+D ' Dim lRow As Long Dim i As L...
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...
Hello, I have a problem that is: Firstly i have to copy the same cell (value, anything or blank) from two different Excel and concatenate them a...
Hello, Iam having a bad time, I want to use =COUNTA but I hate the look of all the zeros when in all the empty rows that I didn't use yet, anyway, i...
GOod am, i just want to ask how will i create a formula as follows on the same excel, 1. subtracting the date of admission to the current date 2....
Hello, please convert 12.01.2015 into words System Configuration: System Configuration: Windows / Chrome 55.0.2883.87
Hi All, Am new to macro, i have an excell file in which column A is having dates with formula....for example cell A1 is stored with 01/1/2017 and c...
Hello, I am trying to do my finances in an easier way, and would appreciate it if anyone can help me with the below question: B2=Supermarket , C2=30$...
Hello, I have a holiday home that I rent out and I am making a spreadsheet to control bookings, I have it set up so that the entry date and departur...
DON'T MISS