Registration date
September 12, 2010
Last seen
January 20, 2020
Contributions
2,583
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.

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

Copy x rows y times and then insert customer ID on each set of x rows [Solved]

Hello, I have a set of criteria, 56 criteria as of now, and I have to check how many criteria each customer meets. In one tab I have the list of the 56 criteria in reach row plus the heading row In another tab I have a download list of rows where each customer has a row for every criteria they currently have I plan to have an additiona... Read more

Date Am and PM but need the date to change [Solved]

Hello, I have 12 workbooks, what I am trying to figure out is I have the date and time in one cell. But I has it 1/1/2020 00:00 then them next line is 1/1/2020 12:00. Is there a way to have this auto populate to for the month? If not is there a way to change the month change. So if I put in 01/01/2020 and the next workbook is 02/01/... Read more

Punching Time

Hi again! I have this task ofcalculating the punching time of our agents. I have 4 sheets in one excel. "Deliveroo Data" This is where the orders are coming from, "Order Details" and "Delivery Data" tabs are coming from our system, and "Data" where we would put in all the details needed . So basically, in order to get the punch time, ... Read more

Transferring data autonomously to another sheet with certain text

Hello, I want to copy the words "Pending" and "Candidates" from my main sheet called 'Test Project' to my new sheet called 'Pending Test'. Both pending and candidates are located on column F and are within a mix of other text. Is there a way to automatically cross it over everytime I type the two words on the main sheet to the new... Read more

Populate data from a column in one worksheet to a cell in multiple other sheets [Solved]

In a workbook, I want to be able to copy all the cells in column B of sheet "Raw Data" into multiple copies of an existing template sheet corresponding to each value. (note: not all cells have values). Column B in the "Raw Data" sheet has about 800 cells/values. I want the workbook to be able to: 1. Pick up the 1st value from colum... Read more

Saving Papers [Solved]

Hello Everyone, I hope someone could help... I have list of Check Numbers on Column A and Their Amount on Column B and it runs on almost a thousand of Pages. what I am doing, to save papers on my printouts is cutting the content of Column A & B of page 2 and Paste it on column C & D of page 1. And, Cutting the content of Col... Read more

Using IF to compare time values [Solved]

Hello, So basically I have a huge column of time values (00-00-00 format) and I am trying to write a code that takes the time in one cell (B) and compares it to the time in the cell before (A). If the time in B is more than 1 second later than the time in A, I want it to return the number 1 in the adjacent column. If the time in B i... Read more

Extracting images from a database but named with a specific cell content.

Hi there people! I could use some help... I'm currently importing product images from a database into Excel using the Visual Basic code below: Sub URLPictureInsert() 'Updateby Extendoffice 20161116 Dim Pshp As Shape Dim xRg As Range Dim xCol As Long On Error Resume Next Application.ScreenUpdating = False... Read more

Seperating time from text [Solved]

Hello, I have a task in my office that i can't get done and it is very impossible to finish within 1 week as these are 14,000+ orders. The sheet looks like this. The underline time are the pick up time which I have to extract and put on the last row of the sheet that is under "pick up time" Please tell me how i can extract th... Read more

How to hide text in a Excel cell and display it when needed [Solved]

Hi friends I have doubt in excel. I have a column called 'Status' and want to show the text either as 'Pending' or 'Completed' depending on the result received when two other columns (Total Fees $ Total Paid) gets added. I have added the formula and applied to the entire column. The formula works. But the text 'Pending' is showing... Read more

Disable a cell in excel using VB code [Solved]

Hello, I am looking for a VB code to disable a cell based on the value of another cell in excel. Example:- Need to disable Cell B1/C1/D1 based on the value selected from the dropdown in cell A1. Suppose value selected in cell A1 =xyz, then disable cell B1.But keep the other cell enabled. If value selected in cell A1= abc then disa... Read more

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

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

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

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

Copy paste special into last row of another worksheet [Solved]

Hello, Thank you for taking your time to read my questions. My question is the following any form of help will be greatly appreciated. I am trying to use check boxes in order to copy and paste values over to another worksheet automatically. This means multiple items need to append onto the other worksheet leaving a row betwe... Read more

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