Results 1 to 9 of 9

Formula to copy and data found in every fourth column on another sheet

Threaded View

  1. #1
    Registered User
    Join Date
    12-04-2010
    Location
    Jamaica
    MS-Off Ver
    Excel 2003
    Posts
    92

    Formula to copy and data found in every fourth column on another sheet

    Hello Experts,
    On the attached file. I need help to write a formula on the sheet name "Score" that will look for the meat name and the corresponding month on the sheet name "Data" and return the number that is in the TKT Avg column. Note that the TKT Avg column is found at every 4th column Please see example i have done for the month Jan-10. The formula i use cannot copy across to the other months. So the formula i need should be able to copy across to the other months

    Thanks,
    Teddy
    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] vba to copy numerical data only in first column ,if found copy whole row to another sheet
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-15-2017, 01:34 PM
  2. Loop to go down column and copy every fourth row
    By ammartino44 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-04-2015, 02:31 PM
  3. VBA to searc column for a value and copy the row(s) to another sheet when found
    By brockj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-23-2014, 03:27 PM
  4. [SOLVED] Copy row from one sheet and paste to another if a key word is found in 1 column of sheet 1
    By killdozer in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-17-2014, 02:27 PM
  5. Replies: 0
    Last Post: 06-14-2013, 01:36 PM
  6. Replies: 16
    Last Post: 01-20-2013, 09:40 AM
  7. Replies: 5
    Last Post: 09-24-2009, 03:46 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