+ Reply to Thread
Results 1 to 3 of 3

wall stickers on worksheets based on a dynamic table

  1. #1
    Registered User
    Join Date
    05-05-2011
    Location
    Norway
    MS-Off Ver
    Excel 2007
    Posts
    2

    wall stickers on worksheets based on a dynamic table

    I have 7 worksheets (monday to sunday). On the top corner i want a kind of wall sticker based on a table in the 8. sheets. Ex on the 3. of may i type in: -Empty trash- in the table. The wallsticker on every other sheets says: Empty trash. On the 5.of may i type in: clean windows. Then the wall sticker says the same. The problem is that i want to have the previous actions in the 8.sheet as a historylog.

    The wallsticker needs to check ex column B and pick the last cell that has been written in.

    Hope you understand, my english is not the best.

    Any input will be appriciated.

    Thanks

  2. #2
    Valued Forum Contributor
    Join Date
    11-11-2008
    Location
    Euro
    MS-Off Ver
    2007, 2010
    Posts
    470

    Re: wall stickers on worksheets based on a dynamic table

    Quote Originally Posted by Jonnykanon View Post

    Hope you understand, my english is not the best.

    Any input will be appriciated.

    Thanks
    It is difficult to understand for me, Plz post a sample file and give more clear question, thanks

  3. #3
    Registered User
    Join Date
    05-05-2011
    Location
    Norway
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: wall stickers on worksheets based on a dynamic table

    Quote Originally Posted by tigertiger View Post
    It is difficult to understand for me, Plz post a sample file and give more clear question, thanks
    Sorry no sample file, have none

    It's really a simple loop. It needs to pick the last row/column thats been written in and return this to another sheet. If I write in row 4 column B, this text will be shown in worksheet A. If tomorrow i write in row4 5 column B, this text will be shown(in a different worksheet).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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