Results 1 to 2 of 2

Select data from another sheet

This is a discussion on Select data from another sheet within the Excel Questions forums, part of the Question Forums category; Hello, I have a template for the items that generate based on formulas. Based on each item, the the template ...

  1. #1
    New Member
    Join Date
    Mar 2017
    Posts
    31

    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
    22

    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?

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