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...
Column A and B both contain numeric values. I want Excel to look at both and give me the numeric difference between the two in a new column C. I reali...
B2=Supermarket , C2=30$ B3=Fuel, C3=20$ B4=Fuel, C4=50$ if Bs="Fuel", i want to add the numbers in the adjacents cells together. but only if they c...
Hello, I have used 602 Office suite for several years and now I have 10 years of spread sheets that I cannot open with windows 10. Do I have to purch...
Hello, I want to transfer formulas only from one spreadsheet to another but I get all the data I even specify paste formulas
Hi All, I have very basic skills in excel - I'm trying to work through some data, and I have a long string of text - which has a common word "Naam:" ...
Hello, if cell contains text and date also for e.g 02-01-2017_Address Verified / 30/12/2016-Number busy / 28/12 Number busy. like this their no pro...
Hello, I hope someone could help me. Working with graphics in excel, I generate dispersion plots from some datas, later I add the trendline, display...
Hello, I'm trying to create a formula which would give me the total amount sold. So for example I'm trying to get a formula which would say if column...
how do I link text information from one worksheet to another?
desktop reminder with excel sheet and formula need please support.
Hello, I am trying to copy the color formatting along with the formulas across the entire row but the colors don't change based on the formula. Exam...
Hello, Would please help me to find the proper formula for this below if R6 is Action date if S6 is Target date T6 is Number of days to close the...
I cannot change the text colour in a spreadsheet and the cell borders do not print out although they are there on screen. I have the CD for Office Ho...
Hello, I am trying to find the sum of some numbers in a column in a maxro book. I make the formula of sum and the sum appears 0. In fakt, althout th...
Hello, Please anyone can assist me on the below issue. that if I want to have a result as per the below if 1=Biju , 2=Daisy, 3=Mahmoud.... Cell...
My VBA is a bit rusty so hopefully I can get a little help. There is a report I need to create every week that I want to automate a bit. I have a ...
Hello, I have a spreadsheet with columns that have targets and results next to each other. If the target is reached (=) or exceeded (>) I want the r...
Hello, I am trying to collect budget request from different departments and if all approvals fields are Approved, I want all data to be collected in...
Hello, Would please help me to find the proper formula for this below if R6 is Action date if S6 is Target date T6 is Number of days to close the...
Hello, I want to copy data of 2nd columns from all the sheets to different columns of single excel sheet. Is there any macro code available for per...
Hi, I want to combine dates from multiple cells into a single cell in the same row, with the result displayed in the format: dd/mmmm/yyyyy, dd/mmm...
Hello, I am trying to find out a formula to use. I have a lot of names and dates. and another tap has names with days worked. I am trying to find ...
Hello, how to convert Date to words in excell in large for Tc use e.g 05/01/1992 To change five January,Ninteen Ninty Two System Configuration: Win...
I want to have a result as per the below if 1=Biju , 2=Daisy, 3=Mahmoud.... Cell A - i will enter 123 cell B - will have result of Biju, Daisy, Mah...