Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 18
Default VLOOK-pivot table expanding want to update vlook automatically

Hello...

I have a file that tracks Order # and the receipts that have been
completed... The receiving details is generated from our system and dumped
into a file which i just copy into Tab#2....I then summarize with pivot
table....New Order # are constantly being added to Tab #1 and I need to have
the vlookup formula to expand with the pivot table expanding.... eg today
pivot table starts at A2 and ends on line A10 and tommorow ends on A20 (how
can the vlookup in qty received column be adjusted without manually changing
and then coping all the way down chart

TAB #1 (main tab all user acess)
ORDER # Material Order QTY Outstanding QTy QTY Received
123 a 100 75
25
234 b 50 0
50
345 a 20 5
15

TAB # 2 (receiving history )
ORDER # Material QTY Received Date
123 a 15 7/21
234 b 25 7/21
123 a 10 7/31
345 a 15 8/1
234 b 25 8/1

TAB #3 (PIVOT TABLE of Tab #2)
ORDER # QTY Received
123 25
234 50
345 15

Hope not too confusing...
Thanks
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOK-pivot table expanding want to update vlook automatically CrimsonPlague29 Excel Worksheet Functions 0 August 8th 07 09:44 PM
VLOOK UP Biruzz Excel Discussion (Misc queries) 1 December 8th 06 10:16 AM
vlook Wanna Learn Excel Worksheet Functions 6 October 20th 06 07:54 PM
#N/A with Vlook up Guy Wates Excel Discussion (Misc queries) 1 October 14th 05 02:02 PM
"Vlook up + IF" paula smith Excel Worksheet Functions 2 November 28th 04 04:20 PM


All times are GMT +1. The time now is 07:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"