Results 1 to 2 of 2

Thread: Transfer data from one sheet to another sheet based on criteria

  1. #1

    Transfer data from one sheet to another sheet based on criteria



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Friends,

    While working on attached sheet i get an error. Can any one help me out in this:

    I have two sheet (Working & October 2015). In Working sheet i have table and button. In October 2015 sheet i have a table, date wise in same format with some changes.

    Now what i done is if any user press a button EAD-AP in Working sheet it will transfer a data on the basis of date, B:B column, and the names (Vijay, Jaffar, Aniket, Sheela etc). to October 2015, but i get an error stating "Type Mismatch". I tried lot to resolve the thing but didnt get it.

    Can anyone please help me in this

    Regards,
    HD
    Attached Files Attached Files

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    751
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Nandukumar on the Working sheet isn't found on the October 2015 sheet. It's Nandakumar.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •