It worked perfectly. Thank you royUK so much! I spent hours thinking about it, and you solved the problem in a few steps.
I actually will move these items to another archive sheet. The sheet I called "archive" is really just a summary.
Thanks again for your prompt response. As a beginner, I have learnt a lot about from this forum. All the best to you royUK and everyone!
Hi everyone,
I am working on the worksheet as attached. I have been trying to delete the rows in the "Archive" sheet based on what are selected in the list box on the "Packing Slip" userform. Any help will greatly be appreciated.
Thank you so much!
Chi Nguyen
thank you so much! I tried both codes and the third one that you suggested in the last post. I kept getting error messages. The one I got with the third code is 'Compile error: Sub or Function not defined". Please see attached [ATTACH]n1224097[/ATTACH]
Thank you [USER="28486"]kenneth[/USER] Hobson. I copied and pasted your code into a new module. An error message came up "The code in this module must be updated for use on 64-bit system."
What should I do? Many thanks.
Hi all,
I was trying to print my userform named frmQualityControl to PDF (please see file attached) [ATTACH]n1223947[/ATTACH] . I found some codes in this forum and tried to plug them in with my module, but none of them seemed to work. Any help please! I would really appreciate it.
Thank you all in advance!
Hi Carim,
I was away for the last couple of days. Thank you for your prompt response. I tried putting the formula directly into the cells on the spreadsheet. But somehow they get manipulated automatically after some time. For instance, I referred to another workbook located on my server Z: drive. After a while, the path turned to C:/ Drive where no such file is there. And hence the formula does not work.
Any idea why this happened? It would really be appreciated.
Thank you
Hi Ozgrid experts,
I am trying to use Vlookup function across workbooks, but it does not seem to work. I have one mastersheet called "Packing Slips", in which there is worksheet "WORK ORDER" where I keep track of the status of all the orders. I also have another workbook called "Inspection Report", in which there is a worksheet called 'InspectionReportSummary" .Please kindly see files uploaded below:
https://drive.google.com/drive…PF9oWGCLk7kKZ?usp=sharing
I tried to use Vlookup function embedded into the button "Update W/O Status" on the Work Order sheet to update column "FINISHED" if the order has been entered on the "InspectionReportSummary" sheet. But it did not work.
Can anyone please help? I would really appreciate it.
[VBA]Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim lsttrw As Integer
Dim j As Integer
Workbooks("PACKING SLIPS.xlsm").Worksheets("WORK ORDER").Activate
With ActiveSheet
lsttrw = Range("A" & Rows.Count).End(xlUp).Row
For j = 2 To lsttrw
Cells(j, 10).Activate
'ActiveCell.Formula = "=IF(ISERROR(MATCH([@TRAVELER],'Z:\Production\AVP-Shop\2019\INSPECTION REPORT.xlsm'!Table333[Traveler],0)),1,2)"
ActiveCell.Formula = "=vlookup(" & ActiveCell.Offset(0, -9).Address(False, False) & ",INSPECTION REPORT.xlsm!Table333[#Data],15,False)"
Next j
End With
Application.ScreenUpdating = True
Application.DisplayAlerts = True
End Sub[/VBA]
