Results 1 to 7 of 7

How to move certain range between worksheets with Indirect function?

Threaded View

  1. #1
    Registered User
    Join Date
    05-24-2018
    Location
    Dublin
    MS-Off Ver
    office 2013
    Posts
    4

    How to move certain range between worksheets with Indirect function?

    Hi there Excel pros!

    I am currently working on a social media marketing plan and one of the tasks is to create working timeline/schedule of all the future activities on our social channels.
    I've build something that is working fine, but I missed one important detail that actually kinda ruined my plan.
    I am attaching an example of the schedule. and here is the explanation and more about what I want to achieve.
    So, the plan contains one global worksheet with a 2018 calendar, you can see broad picture there. Then, there are additional worksheets, one for each month that contain all the key details about each social media activity.
    The problem is, that the environment that I am working in is quite dynamic and dates can change on a weekly/daily basis, and for that I just wanted to get something that would be easier to move. The idea is, that I want to move the dates in Global worksheet, and when I move some date it would be also reflected in the month worksheet. For now, it is working partially, I can move the date in global tab, but then only one cell in a month worksheet moves as well. What I need is to move certain cells range (cells in columns D-J).

    Here is the formula that moves one cell only:
    =INDIRECT("year!"&CELL("address",A12))

    Is there a way so I can actually move certain range?

    thanks!
    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. Replies: 6
    Last Post: 01-09-2018, 10:18 AM
  2. INDIRECT function for other worksheets
    By AdiK in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-18-2017, 10:59 AM
  3. Replies: 8
    Last Post: 01-04-2016, 05:46 AM
  4. Indirect function not refreshing between worksheets
    By lbobrien in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-18-2013, 07:21 PM
  5. Replies: 15
    Last Post: 09-10-2013, 05:31 AM
  6. [SOLVED] INDIRECT Function with various worksheets
    By bigmantitus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-21-2012, 04:37 AM
  7. indirect function in different worksheets, losing my hair!
    By Alexander Banz in forum Excel General
    Replies: 3
    Last Post: 02-16-2005, 11:59 AM

Tags for this Thread

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