Consulting

Results 1 to 5 of 5

Thread: VBA Code to copy data from two sheet ,paste into corresponding sheet

  1. #1

    VBA Code to copy data from two sheet ,paste into corresponding sheet

    Hi experts

    I have set of data in two sheet, i want copy data from 2 sheet , paste into corresponding value sheet name, through multiple command buttons

    for e.g
    Condition 1 : Rawsheet1 Column B have data south and Rawsheet2 Column B have data south, from both sheet all data south copy to south sheet, 1st range(A30:G30) 2ND RANGE(I30:O30)
    Condition 2 : In sheet south In column C have states data when i click state wise command button corresponded states data will be in both range
    please find the attachment
    Attached Files Attached Files

  2. #2
    Knowledge Base Approver VBAX Wizard
    Joined
    Apr 2012
    Posts
    5,619
    Store the data as a database (do not split them into several worksheets/files/folders.
    Create a separate representation worksheet to filter and show (pivottable, slicers, graphs, charts, etc ) selected data.

  3. #3
    Brother can u help me with slicers ? atleast

  4. #4
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    4,241
    Location
    As snb has suggested
    Store the data as a database
    your data is clearly more suited to a database rather than excel. However since you seem persistent then have you considered using the filter command?

    All of the data could reside in one sheet, then using Filter you could display the requested data within table.

    example: =Filter( named table, ((Filter 1 )* (Filter 2)* (Filter3)) etc where the filter conditions could represent Id's, Region, State.Address, Phone, Mobile, Email.
    only problem I initially see is that you have identical ID's for one or more people ( that's a No No in anyones language)
    Remember To Do the Following....
    Use tags when posting code to the thread,
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  5. #5
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,416
    Location
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

Tags for this Thread

Posting Permissions

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