That appears to be correct, but I do not have a button for the macro in my original workbook and the would macro remove the original column with the duplicate values.
Sorry for the confusion. The the sample file is the "Daily Update" sheet.
'Sheet 7' is a single sheet with this formula in cell B23: =IF(AND(M1="Production Recorded",N1>0),P1,0)
The macro goes to 'Sheet 7' and copies the formula and pastes it into cell Q1 on the 'Daily Update' sheet and then...
Thanks for your work on the code. I tried it and it stopped working at line with Count (see below):
LastRow = .Cells(.Rows.Count, "B").End(xlUp).Row
I have added a sample of the data download I am working with. The ERP we use duplicates the values in Column N (see highlighted values). The...
I recorded this macro in an excel workbook I use at my place of work. The number of rows will vary from day to day. The recorded number of rows was 200. I want the code to fill down to the last cell in the column Q based on the number of cells with values in column B. Appreciate any help.
>>...
Thanks for your help. I realized that I was asking one thing and the sample spreadsheet was indicating another. I finally figured out how to solve the problem and appreciate your help. I spurred me on to find the solution.
Hi Marc L, thanks for the reply. I do not know what you mean by TBTO rule. Also, as for the code you provided, where would I add it into the current recorded macro?
I recorded a macro for updating and formatting a spreadsheet. I run an update on this spreadsheet everyday. Currently, I have to change the row values in the recorded macro to match the number of rows in the daily data download from an ERP database. I would like to have the macro perform the...
vietm. thanks for the feedback. I did not think about combining the time and date into one cell. It works perfectly. I truly appreciate your help and support to solve my problem.
I am using a formula to look at a table and sum all production hours from the previous day or 24 hours. Column B is the date in the table. Cells F2 and F3 have the formula =Today()-1 to sum all hours for the previous days date (i.e. yesterday).
=SUMIFS('Molding WC Log'!$F:$F,'Molding WC...
I am trying to find a macro that will help me cut down the amount of time I spend adding machine numbers in a report. I run production and downtime numbers every month.
The data from the database does not populate all the cells with the machine names. I have to go and manually copy and paste...
Hi Chihiro, thanks for the reply. I appreciate your help.
What would I do with the clear content range? How would the macro be able to read Cell D1 value to clear the content?
Thank you for your feedback. I was hoping to basically keep the same macro but instead of defining the range as highlighted in red
PrivateSub Worksheet_Change(ByVal Target As Range)
If Application.Count([A1:B30]) = 60 Then
Application.Wait (Now + TimeValue("0:00:03"))...
I did originally have a button to activate the macro but this required someone to press the button. The worksheet is used for quality inspection to measure the size of a part. It requires a specific number of units to be measured based on the sample size for each production quantity. This is why...
I am using a macro to allow data to be entered into a spreadsheet in Columns A and B down 30 rows. I am trying to find a way to define the number of cells based on specific needs. Some times I will need 20 rows of data, other times I will need 30 rows populating, etc. There is a delay in the...
p45cal, Thank you for your time and feedback. I incorporated the improvements and my workbook is working much better and now achieving what I wanted it to do
Thank you for your help and wonderful feedback.
p45cal - The Master Downtime Analysis 2018 is a table that pulls data from the OEE Report. I have pivot tables pulling and sorting values from this Master Downtime Analysis 2018 table for yesterday, past 7 days and overall totals.
Narayank991 -...
I inserted the formula that Narayan provided and it gave me the part numbers for each molder, however I want to ensure that I am seeing the latest part numbers in Column B in the Master Downtime Analysis 2018 based on yesterday's date in the same worksheet in cells D1 and D2. I have tried amend...
I have a trying to create a formula using the INDEX and MATCH functions to do a daily update of a worksheet.
I want the formula to INDEX the most recent Part Numbers in Column C being run on a specific Molder in Column B in the OEE Report worksheet and to MATCH them with the Molders in Column...
I am trying to get the cells D3 to D13 to sum the total hours for each downtime reason between the date ranges entered in cells C1 and D1.
I want to look at the downtime log sheet and match and sum all the hours for a specific downtime reason and enter the hours into cells D3 to D13 in the...
Chihiro, I thought about what you said in your reply and I came up with these additions to the macro. I added a delay and a return to cell A1.
Private Sub Worksheet_Change(ByVal Target As Range)
If Application.Count([A1:B30]) = 60 Then
Application.Wait (Now + TimeValue("0:00:03"))...
Chihiro, Thank you for the macro code. It works perfectly. I am not sure how you would use another layer of logic to trigger the process. I did think about trying to see if I could add a delay of 2 or 3 seconds after entering the value into cell B30, which is enough time to see the result in C30...
Thanks for the quick reply. I have attached a sample workbook to demonstrate how the current worksheet operates. I inserted some sample data in columns N and 0. This sample data would not be there in the actual worksheet.