Pulling Data from Another Worksheet

A

AntnyMI

I have a SOURCE DATA worksheet with 10 columns. I would like to
automatically pull data from columns B, F, G and J and place it onto a
SUMMARY sheet as columns A, B, C and D (the other 6 columns do not need
to be included on this second sheet).

Currently, I'm using the following formulas in cells A4, B4, C4 and D4
of the summary sheet, respectively:
"='Source Data'!B4" , "='Source Data'!F4" , "='Source Data'!G4" ,
"='Source Data'!J4"

What is the best way to automatically add additional rows of formulas
on the summary sheet as the source data sheet continues to grow? I
tried simply copying the formulas to the first 100 rows of the summary
sheet. However, this creates a problem when I sort. The sort includes
any rows with the formula (placing all blank rows before the rows with
data).

I need a way to add the formula to a new row on the summary sheet ONLY
when there is data on the corresponding row of the source data sheet.

BTW, "=IF('Source Data'!B8="",,'Source Data'!B8)" doesn't work. The
sort still processes this as a value of zero (therefore, placing these
rows before the rows with data).

Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell data entering slow! 0
Consolidation Table from Different Excel Tabs with Different Format 1
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Formula for transferring data in rows to columns on two different Worksheets 1
Need Help with a VBA subroutine 0
Mail Merge Directory Conditional Page Break 0
how to copy and paste value from one sheet to another 4
Linking Rows Between Sheets When Sorting 1

Top