Excel Forum
-
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...
-
Copy , concatenate and finally paste [Closed]
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...
-
How to show an empty cell if =COUNTA counts 0? [Closed]
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...
-
subtracting the date of admission to the current date [Closed]
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....
-
convert 12.01.2015 into words [Closed]
Hello, please convert 12.01.2015 into words System Configuration: System Configuration: Windows / Chrome 55.0.2883.87
-
macro to paste special values [Closed]
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...
-
If cell contains a certain text, add the numbers of another cell [Solved/Closed]
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$...
-
stop duplicated with multiple cells [Closed]
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...
-
Need formula for comparing differences of two columns. [Solved/Closed]
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...
-
if cell contains a certain text, add the numbers of another cell [Closed]
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...
-
Opening 602 spreadsheets with window 10 excel. help [Closed]
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...
-
Transfer formulas only from one spreadsheet to another [Closed]
Hello, I want to transfer formulas only from one spreadsheet to another but I get all the data I even specify paste formulas
-
Stripping out some text form a larger string [Closed]
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:" ...
-
need help for excel formula [Closed]
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...
-
Copy ActiveChart properties to cell (from graphics) [Solved/Closed]
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...
-
Formula Help - IF FUNCTION [Closed]
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...
-
link info [Closed]
how do I link text information from one worksheet to another?
-
desktop reminder with excel sheet and VBA formula need. please s [Closed]
desktop reminder with excel sheet and formula need please support.
-
Copying Conditional Formatting with Formulas Accross Rows [Solved/Closed]
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...
-
Multiple IF formula in one cell, date comparison [Solved/Closed]
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...
-
Text colour doesn't change and cell borders don't print [Closed]
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...
-
Why sum of some numbers is 0 [Closed]
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...
-
Convert number to assigned names and joined with another names [Solved/Closed]
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...
-
Excel VBA scripting - Changing a cell color based on contents [Closed]
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 ...
-
Conditional Formatting Excel 2013 based on content in other cell [Closed]
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...
-
Excel Sheets automatic updates [Solved/Closed]
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...
-
If Date [Closed]
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...
-
Macro for merging data from multiple sheets [Solved/Closed]
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...
-
Display dates from multiple cells in one cell [Closed]
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...
-
a lot of names and dates [Closed]
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 ...
-
how to convert Date into text. [Solved/Closed]
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...
-
convert number to assigned names and joined with another names [Closed]
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...
Subscribe To Our Newsletter!
