-
Fix data position
Hi
My data in worksheet "Volume Summary" keeping on shiftinig down when a new supply customer is add to worksheet "Deal Selection", if you follow the following routine you well undertsdand...........
and also if just click the update data field macro button on it own it deletes the data in column F and shifts it upwards
when you add say shell to worksheet "Deal Selection" and click the macro button in work Sheet "Volume Summary" and then re delete and re click the update macro button in Volume Summary and you'll see..........
this happen to all the table with heading supply in them ONLY...
what the macro should do is only remove the enteries that are not matching with worksheet "Deal Selection" column b ...
and not shift the data around that should remain fixed to that particular client...
SEE NEW WORKBOOK
-
Sorry, I can't see the problem. Can you post another copy highlighting the error situation?
Regards
MD
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules