Results 1 to 24 of 24

macro to put data in relevant groups

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-18-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    356

    macro to put data in relevant groups

    hi guys

    im looking for some help please to auto fill data into specific areas of spreadsheet based on the day

    please note i have attached spreadsheet

    the data in columns h:n are auto populated and sorted from another spreadhseet

    so what i would like to do with a button is this ( if possible )
    in h11:n16 there are 2 days that correspond to MONDAY
    what i need the macro to do is move that data ( as per heading ) to mondays range which is b13:f22

    column a can be ignored as this looks up column b and returns the account code

    and also to do the same for corresponding days

    can anyone help please?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to display data from the last 7 days only and to move relevant comments
    By Brumbot in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 12-31-2021, 12:41 AM
  2. Macro button to move data to relevant worksheets
    By Tigger118 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-29-2013, 04:54 PM
  3. macro for Extracting relevant data from an excel database
    By cbhawsar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2011, 11:50 AM
  4. Macro to sort data,match and paste in to relevant sheets on same workbook
    By Benjamin2008 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-08-2009, 07:58 AM
  5. Macro Help:summary of the relevant data
    By H.S in forum Excel General
    Replies: 1
    Last Post: 03-12-2005, 05:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1