+ Reply to Thread
Results 1 to 2 of 2

Update Diffrent worksheets from Dashboard

  1. #1
    Registered User
    Join Date
    01-29-2010
    Location
    Scotland
    MS-Off Ver
    Excel 2010
    Posts
    94

    Update Diffrent worksheets from Dashboard

    Hi I would like to know how I can update three diffrent tabs from the first Dashboard?
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-29-2010
    Location
    Scotland
    MS-Off Ver
    Excel 2010
    Posts
    94

    Re: Update Diffrent worksheets from Dashboard

    Hi I think I need to have a loop that steps down columns C, D and E, to check if the person has a Delete or an amend and if they do copy it to the appropriate tab.
    I have no idea how to start I have been through the forum and dont understand loops.

    You can have nested loops ...
    For i = 1 to 100
    For j = 1 to 50
    Cells(i,j) = ....
    Next j
    Next i
    Am I going in the right direction?
    Attached Files Attached Files

+ 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