hey i need to make a tool that extracts data from different workbooks and paste it in the current workbook.
Right now i am using vlookup function
VLOOKUP(A5,[workbook1.xlsx]$B$8:$AN$319,26,False) but it extracts data from workbook1 only one time. My job requires me to replace the old workbook1 with the new one daily so i want the cells to update themselves
whenever the workbook1 is updated or replaced with new1
need help asap
Right now i am using vlookup function
VLOOKUP(A5,[workbook1.xlsx]$B$8:$AN$319,26,False) but it extracts data from workbook1 only one time. My job requires me to replace the old workbook1 with the new one daily so i want the cells to update themselves
whenever the workbook1 is updated or replaced with new1
need help asap