Results 1 to 2 of 2

Copy a group of cells based upon the value of another cell

Threaded View

  1. #1
    Registered User
    Join Date
    01-18-2023
    Location
    Lincoln, England
    MS-Off Ver
    Office 365 Excel 2012
    Posts
    1

    Copy a group of cells based upon the value of another cell

    Hello,

    I have a group of cells for each week of the year. I would like to be able to copy that group of cells into another area on the same sheet depending on the week selected in a particular cell. In A74, week one is selected so the black outline is filled with the values from week 1. If I then choose to process the data in week 2, I change the one to a 2 and this replaces all the cells in the black box with the contents of week 2 etc.
    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. Copy value of cell with given group ID to cells in different rows with same group ID
    By missingvalue in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-01-2023, 10:30 AM
  2. [SOLVED] Copy group of cells to another location based on cell content
    By irose_57 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-30-2022, 09:58 AM
  3. Copy paste Data based on Group Name and Group Head
    By tigarman in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-24-2022, 06:07 AM
  4. Replies: 7
    Last Post: 06-09-2016, 09:48 PM
  5. Replies: 0
    Last Post: 06-17-2013, 07:25 PM
  6. [SOLVED] copy cell info to another group of cells
    By dalerdd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-11-2012, 07:35 AM
  7. [SOLVED] Macro to copy,paste and group information based on value in a cell
    By gullit in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-14-2012, 05:32 PM

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