Databases
StackOverflow2013
Postsdbo
POUsing excel formula to copy a column between workbooks if first cell contains any info
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUsing excel formula to copy a column between workbooks if first cell contains any info
    primarykey
    data
    text
    <p>I'm tyring to look for a way to return a range of cells with just the lookup function. Is this really possible?</p> <p>Basically like this: =LOOKUP([MasterBook.xlsm]Sheet3!$A:$A,?)</p> <p>I just want the function to look in the main workbook through all of Column A and return all cells for Column A that have something in them.</p> <p><strong>EDIT</strong> for poster below: Sure. I have two workbooks; one workbook is essentially a local product that has a "master" sheet on top and then individual worksheets following it that have all of their information extracted from the master sheet. The second workbook is a local copy of a product that I send to a non-local entity higher up the food chain. Basically I need to pull information from the individual sheets in my first workbook and put it in the appropriate columns in the second workbook. I have a macro that gets the info from my sheets in the one workbook over to the other, but the second workbook is formatted differently. I was looking for a way to use a formula if possible.</p> <p>The macro I am referring to is:</p> <pre><code>Sub CopyTest() Dim sourceColumn As Range, targetColumn As Range Set sourceColumn = Workbooks("Local Workbook.xlsm").Worksheets("Sheet3").Columns("A") Set targetColumn = Workbooks("Nonlocal Workbook.xlsm").Worksheets("Sheet1").Columns("A") sourceColumn.Copy Destination:=targetColumn End Sub </code></pre> <p>All this does is pull the specified column from one sheet and put it in the column on the second book; but it just pastes it starting in the first block. Since the non-local book is formatted differently, the column I need to transfer to doesn't start until Row 9. <em>shrug</em> I have ideas abuot what I'm trying to do with this, but my ideas tend to exceed my technical ability (which occasionally makes it difficult to explain). :)</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJon
    1. USJon
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COBasically, you cannot return a `Range` with a formula (actually, some like `OFFSET` may but are uneasy to use except in a named range). Would you tell us more so we could help you?
      singulars
      1. POUsing excel formula to copy a column between workbooks if first cell contains any info
      1. USJMax
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload