Simple link to Worksheet rows problem

  • Thread starter Thread starter James B
  • Start date Start date
J

James B

I have a multiple page or sheet spreadsheet where I am pulling data into one
sheet from another. Everything works fine except on one link where I am
pulling text from some 30 colums however when it pulls the data (text) all I
get is one entry pretty much from the center of the entire formula.

Formula from the report sheet, =('Installed Software'!A2:A96)

On the installed software sheet there is a list, one row each, of software
titles but the formula above seems to bring over only something from near
the middle of that list.
 
If you want the range to do something then =sum(yourfomula) else just one
cell please.
 
James

Either of these should work for you.

1. Enter ='Installed Software'!A2 then drag/copy down.

2. Select 95 cells in a column then in formula bar enter the formula you have
used in your post then hit CTRL + SHIFT + ENTER.


Gord Dibben Excel MVP
 
Not sure how you're going about this, but your formula:
=('Installed Software'!A2:A96)

would be looking at 95 rows, but would only be able to display one of them.

This may be an instance where you'd want to use an Advanced Filter to get
your data.
Rules (when not using VBA to do this):
1)You must START on the DESTINATION sheet

2)If you only want specific columns copied in: type, or copy, those column
headings.

3)Then select those column heading cells and the next row of cells below them.

4)Data>Filter>Advanced Filter
List Range: Select the data range on the SOURCE sheet
Select: Copy to Another Location
Copy To: Select the top row of destination cells (the column headings that
you entered on the DESTINATION sheet)

5)Click [OK]

Note:
A)If you want to re-pull the data, you'll need to reselect the source data
each time. For on-going data pulls, you'll probably want to record a macro
to do that for you.
B)You can also set a criteria range to only pull a subset of the source data.
(Check Excel Help on "Advanced Filtering")

Am I on the right track here? Does that help?
 
Ron Coderre said:
Not sure how you're going about this, but your formula:
=('Installed Software'!A2:A96)

would be looking at 95 rows, but would only be able to display one of them.

This may be an instance where you'd want to use an Advanced Filter to get
your data.
Rules (when not using VBA to do this):
1)You must START on the DESTINATION sheet

2)If you only want specific columns copied in: type, or copy, those column
headings.

3)Then select those column heading cells and the next row of cells below them.

4)Data>Filter>Advanced Filter
List Range: Select the data range on the SOURCE sheet
Select: Copy to Another Location
Copy To: Select the top row of destination cells (the column headings that
you entered on the DESTINATION sheet)

5)Click [OK]

Note:
A)If you want to re-pull the data, you'll need to reselect the source data
each time. For on-going data pulls, you'll probably want to record a macro
to do that for you.
B)You can also set a criteria range to only pull a subset of the source data.
(Check Excel Help on "Advanced Filtering")

Am I on the right track here? Does that help?
Click to expand...

Gave that a try but I'm not getting it. On the destination sheet I want to
copy the data found on the "Installed Software" sheet but I think the
problem is I don't want to copy it as another 95 rows but rather all into
one cell that I'll either merge with others or resize as needed.

The above was on track I just don't think it will work trying to take rows
of data and place them into one giant cell.
 
Back
Top