Registration date
September 12, 2010
Last seen
November 14, 2019
Contributions
2,559
Gender
Male
Location
Haarlem, NETHERLANDS
Signature
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.

How to simply this Excel formula [Solved]

Is there a way to make this formula simpler? =IF($K9=0,"",SUM($L9*$L11)/R9+IF($K9=0,"",SUM($M9*$M11)/$R9+IF($K9=0,"",SUM($N9*$N11)/$R9+IF($K9=0,"",SUM($O9*$O11)/$R9+IF($K9=0,"",SUM($P9*$P11)/$R9+IF($K9=0,"",SUM($Q9*$Q11)/$R9))))))

VBA Copy/Paste fixed range a number of times [Solved]

Hello Team, I'm looking for a VBA code to copy the three rows and with input box paste based on the times, I entered in the input box. FOr example: I want to copy rows(A2 to A6) and paste all the rows from A7 and so on.. The header(A1) should not be copied. I need to copy all the formulas in the rows(A2 to A6) Please help Read more

How to drag a formula without changing color.

Hello, I have a spread sheet with different colored rows. I want to drag a formula down a column with about 500 cells through the alternating colors. Is there a way that I can copy the formula without copying the color and thus changing the colors of the other cells? Thanks! Configuration: Windows 7 / Internet Explorer 8.0 Read more

Excel 2013 to extract text in one cell

Hi, I want to extract in the right column, a part of the left column, for instance: see below 2 lines for each line at the right column I want to extract only Unit 3 and next line Unit 22..see cell: A1 and A2 below: Cell A1:Payment rcvd: John Doe, Unit 3 - Conf #23206689, Jul 30 to Aug 01, 2019, Inv #32484 XXXX XXXX XXXX 7028 Cell A2:P... Read more

Generate excel workbooks based on excel list [Solved]

Hello, I need to generate several hundred identical excel workbooks using a macro. I'd like to standardise the file names based on a list in Excel. So if column A says 'AC.334.997' and column B says 'Process improvement project', it would generate workbooks based on the template - in this case named 'AC.334.997_Process improvement pro... Read more

Insert picture in Excel macro which takes the file name refrence

Hello Friends, Kindly help me! I am trying to insert a picture in excel macro which takes the file name reference from the D5 cell and insert the picture in I7 cell. Example: if D5 cell is AAA2 then the picture which will be inserted in I7 would be F:\AAA2.jpg Note: 1. I7 cell is merged cell it cover I7 to I12 & J... Read more

How to find the latest time per name in a table with names and times [Solved]

Hello; I have a sheet with a list of "use name" and "time" (which is a login date). I need to find for each user the latest date . But users have several Time (dates). I need to get for each user only the newest date. How can I can do that? See screenshot. Read more

How to find the latest time per name in a table with names and times [Solved]

Hello; I have a sheet with a list of "use name" and "time" (which is a login date). I need to find for each user the latest date . But users have several Time (dates). I need to get for each user only the newest date. How can I can do that? See screenshot. Read more

Need to create linked sheets

Hello, I have an excel sheet this is for a list of unavailable items however I need to create another sheet for 1 specific team. So my sheet is like the list of unavailable items for every brands and deliveries but we deliver in some hotels and this is where we update and put some items that are unavailable but we need the other sheet ... Read more

Comparing Two Excel Sheets and copying like data to third sheet [Solved/Closed]

Hi, I'm trying to compare two sheets in excel and have matching column data copy the entire row into a new third sheet. Ex: Compare Sheet 1 column C to Sheet 2 column E, if the numbers match, copy the entire row of matching sheet 1 column C data to a third Sheet 3. Not sure if this is an "If, then" or "Match" function. Any hel... Read more

Comparing Two Excel Sheets and copying like data to third sheet [Solved/Closed]

Hi, I'm trying to compare two sheets in excel and have matching column data copy the entire row into a new third sheet. Ex: Compare Sheet 1 column C to Sheet 2 column E, if the numbers match, copy the entire row of matching sheet 1 column C data to a third Sheet 3. Not sure if this is an "If, then" or "Match" function. Any hel... Read more

Automatically update a cell with last modified date and time [Solved]

I am maintaining a Test Environment Catalogue, with various users editing it. It is change controlled in SharePoint, however, I'd like to insert a cell labelled "Last Updated" - and the cell should reflect the last date and time the excel sheet was edited. (Only edited... not viewed... ) Columns B:K have content that could be edited ... Read more

copy x rows from a worksheet and paste x rows into another worksheet n times [Solved]

Hi, I am struggling to create a macro that can copy an excel range of data (A1:B50) from sheet 1 and paste into sheet 2 for 4000 times. Currently, sheet 2 contains a column of data with 4000 rows. Hence, i am trying to insert and paste (A1:B50) from sheet 1 into each row in sheet 2. it should visually look like this: Sheet 1(A1:B50) ... Read more

Automatically data to another sheet by adding new rows [Solved]

Hello, I have created a "request form" - the form is not designed in VBA - it is simply a spreadsheet using Column B, only, and each row has either a "label" or a field to enter data: For example: Project Code: Reason for Change> Deployment Date This spreadsheet is called "Deployment Request" (Source of data) (A) ... Read more

Grey out an entire row in Excel 2010 depending on a cell's value

Hi all, I am trying to grey out an entire row in excel 2010 depending on a cell's value. Each cell has a drop down list: Yes, No, Maybe etc I want the entire row going forward, to only be greyed out if a cell indicates the value No. and the row remains active if other options are selected. I look forward to hearing your thoug... Read more

Excel - A macro to create new workbook and copy data [Solved/Closed]

In the example below, I want to copy Column A starting from row 2 ie: "Age" till the value available ie: "Code and column B starting from row 2 ie: "27" till the value available ie: "0001" and paste in a new sheet and save with the name as in the cell B2 ie: "Shridhar1". same should be repeated for column C then column D till the value av... Read more

INSERT ROW DATA INTO EVERY SECOND ROW [Solved]

Hi I have an excel sheet with blank rows every odd line (i.e rows 2,4,6,8...700 are empty). I have to paste a row of data (the same all the way through) into each of these blank rows. So I have paste the same data in every blank row (odd rows) from A1 - H1. Would appreciate any expert's help! thanks Read more