I have a worksheet on a server called "PO Log 2019.xlsx" In that workbook I have a sheet named "PO Log" that I enter data into when creating Purchase Orders. I would like to create a VBA to extract data from certain cells in that work book based on the date they were entered. The workbook I want to copy the data to is called "PO Search.xlsm" and the sheet is "Sheet1".
Columns where data is to be coppied from on sheet "PO Log"
A = PO#
B = DATE (this column has the dates I want to search for)
D = VENDOR
E = GLACCOUNT
H = AMOUNT
Columns where to paste data in the workbook "PO Search.xlsm" on "Sheet1" starting on line 2
A = VENDOR
B = AMOUNT
C = GLACCOUNT
D = PO#
I want the VBA to search for the data to be coppied using a date range that you can enter in a cell(s) E1,F1 on sheet1
Any help would be greatly appreciated.
Columns where data is to be coppied from on sheet "PO Log"
A = PO#
B = DATE (this column has the dates I want to search for)
D = VENDOR
E = GLACCOUNT
H = AMOUNT
Columns where to paste data in the workbook "PO Search.xlsm" on "Sheet1" starting on line 2
A = VENDOR
B = AMOUNT
C = GLACCOUNT
D = PO#
I want the VBA to search for the data to be coppied using a date range that you can enter in a cell(s) E1,F1 on sheet1
Any help would be greatly appreciated.
