Hi and Welcome to the Forum 
You could test the following macro to delete rows where 'ShipTo' appears ...
Code
Hope this will help
Posts by Carim
-
Display More
-
Quote
FORUM ETIQUETTE
4a.
4b.
4c. Please take the time to thank those who took their time to help you..Why? Because every single person that helps out at Ozgrid does so on their own free time. This is a free to post forum so show some gratitude. Besides, its nice to be nice and you will find that people will help you, if you help them by being a good responsible forum citizen.
-
Hi,
Based on Mumps ' proposal ... a couple of tiny adjustments should do the job ...
Display MoreCode- Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
- Application.ScreenUpdating = False
- Dim srcWS As Worksheet, desWS As Worksheet
- Set srcWS = ThisWorkbook.Sheets("DataFeed")
- Set desWS = Workbooks("QuoteLog1.xlsm").Sheets("QuoteLog")
- With desWS
- .Cells(.Rows.Count, "A").End(xlUp).Offset(1).Resize(3, 3).Value = srcWS.Range("A2:C4").Value
- .Cells(.Rows.Count, "E").End(xlUp).Offset(1).Resize(3, 5).Value = srcWS.Range("E2:I4").Value
- End With
- Application.ScreenUpdating = True
- End Sub
Hope this will help
-
-
Thanks for your Thanks
Do not hesitate to give your feedback tomorrow
Cheers
-
As shown in your test file, a User Defined Function stands on its own ...
Your Array Formula is fine ... but with 1'000 records for 4 questions ... it will drain on your Excel RAM memory ...
and the whole workbook will become extremely slow ...
You can test your Array Formula with your real-life data ... and you will quickly find out ...
Meanwhile ... have you tested your UDF ...???
Is it producing the expected result ... or not ...???
-
Attached is your test file
Hope this will help
-
Display MoreHi Carim,
My apologies - the result should be all the individuals with results below the highest score for each section (3 for Q1, 4 for Q2 etc.).
Normally there is no more than 1000 records per sheet.
The second sheet is what I'd be looking for! (without duplicates if possible, as sometimes individuals appear twice for not getting full points on a section).
Is it possible to create a VBA macro that does this?
Thank you again for all of your help!
Thanks for your all your clarifications ...
For 1'000 records, the best solution is a UDF ...
-
Hi,
Sadly you are not indicating ... the most important : your expected result ...!!!
Is the second sheet Results what you might be looking for ...???
An Array formula like yours is fine ... up until a certain number of records ... afterwards it slows down the whole workbook ..
-
Re,
To be totally honest ... your macro is quite confusing ...
-
Hello And Welcome to the Forum
You seem to be truly over-complicating your own life ...
Attaching a sample would for sure clarify your ultimate objective ...
-
Hi and Welcome to the Forum
Attaching a sample file would allow to illustrate your ultimate objective ...
Do not hesitate to show the exact final result ...
-
Quote
FORUM ETIQUETTE
4a.
4b.
4c. Please take the time to thank those who took their time to help you..Why? Because every single person that helps out at Ozgrid does so on their own free time. This is a free to post forum so show some gratitude. Besides, its nice to be nice and you will find that people will help you, if you help them by being a good responsible forum citizen.
-
Once you have tested the macro ... feel free to share your comments
-
Thanks for your Thanks
-
Once you have tested the macro ... feel free to share your comments ...
-
You are welcome
-
I haven't posted a sample of the data as I am not sure how useful that would be now ...
Re,
With a sample file ... you can illustrate your Before vs After worksheet ...
Guess what ... it speeds up the whole process of getting your adequate solution ...
-
Hello Debbie,
Let me tell you it was ' fun ' to try to fix all your issues ...
Hope the last version is in line with your expectations
-
Hi and Welcome to the Forum
You could test following