Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Select data from another sheet

  1. #1
    New Member
    Join Date
    Mar 2017
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Select data from another sheet

    Hello,

    I have a template for the items that generate based on formulas. Based on each item, the the template will generate calculation given by if formulas, and index match etc from selected worksheets. The trigger is located in cell C4 of template workbook.

    I currently have say, band iron maiden in cell C4 in template worksheet. However, I want to go to next or loop, not sure which one is the best option, for a list of other selections in CON worksheet. Which values starts in A4:A, being that I want to add new bands in the near future.

    I'm sure the VBA code is probably very simple. Can someone help me? And also, since the template's other dependant cells are based on cell C4, does the formula needs to be calculated after every selection? I have a code to parse out template and save them onto a designated folder, I just pretty much need a code that allows selection of data from another tab, using next, etc. Until the next cell is blank.

  2. #2
    New Member
    Join Date
    Apr 2017
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Select data from another sheet

    Hi

    I'm not sure whether I understand what you require. You could use a "Do Until" statement to move over each cell until an empty cell is found, or alternatively, find the first empty cell in a row (LastCell=Range("A" & Columns.Count).End(xltoright).Column+1). Perhaps if you could supply some of your code, or examples?

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com