View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HUGO PIENAAR
 
Posts: n/a
Default I WANT DATA TO LINK WITH OTHER WORKBOOKS ACORDING TO CELL CONTENT.

I HAVE A WORKSHEET THAT I WANT DATA TO UPDATE ACORDING TO OTHER SHEETS IN
ANOTHER WORKBOOK ACORDING TO A NO.FOR EXAMPLE:IN ONE WORKBOOK IS MY STOCK ON
HAND ACORDING TO PART NO'S. IN ANOTHER WORKBOOK IS MY VEHICLE'S TO WITCH THE
PARTS ARE BOOKED. I WANT THE STOCK ON HAND TO CHANGE IF I BOOK OUT THE PARTS
ACORDING TO A PART NO. I AM USING MICROSOFT EXCEL 2003