Karen has attended:
Excel Introduction course
Excel Intermediate course
Linking data from one worksheet to another
Hi, new to excel so will try and explain as best as possible ..... I am trying to link data from one worksheet to another. I want to do a count of promo codes on one worksheet and total them to give a value on another worksheet. The count of the promo codes is like this RetailSubCode32 (so there may be a total of 8 of these codes) and it is the total of 8 that I want to put in another worksheet. I have put in the formula as below but it doesn't work (everything is 0)
=COUNTIF('CustDataTemplate'!AN:AN,VLOOKUP(A3,'SDE Promo Codes'!B:C,2,0))
CustDataTemplate is the worksheet where the data is and it is column AN, SDE Promo Codes links the promo code to the person). If anyone understands this can they help ?
RE: Linking data from one worksheet to another
Hi Karen
Thanks for getting in touch. I can't quite follow your example written down. Can you email a sample file to me at gary@stl-training.co.uk ?
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
