software

I am trying to set up a table in the #2 worksheet to get the data from
the table in the #1 worksheet. I have it set up so that a user will
enter data into #1 worksheet and it will automatically transfer to #2
worksheet.

I have attached a Word document of what the tables look like. I need to
get the data from #1 worksheet to transfer to #2 worksheet and not have
blank rows in between. I also don't want to run a VB script that will
delete blank rows because the users of the Excel document will be
confused on how to run it.

I set up an IF statement on the cells to transfer the data from #1
worksheet to #2 worksheet, but #2 worksheet looks exactly like #1. Does
anybody know how I can get #1 worksheet to transfer over to #2 worksheet
and look like how I have it set in the 2nd table in the attached
document? -------------------------------------------------------------------
|Filename: Excel Question.doc |
|Download: www.excelforum.com/attachment.php?postid=4504 |
-------------------------------------------------------------------

--
nickae77
------------------------------------------------------------------------
nickae77's Profile: www.excelforum.com/member.php...oamp;userid=32701
View this thread: www.excelforum.com/showthread...hreadid=525283You can use Datagt;Filtergt;Advanced Filter, but this does not allow copying to
another worksheet.

HTH
--
AP

quot;nickae77quot; gt; a écrit
dans le message de
...
gt;
gt; I am trying to set up a table in the #2 worksheet to get the data from
gt; the table in the #1 worksheet. I have it set up so that a user will
gt; enter data into #1 worksheet and it will automatically transfer to #2
gt; worksheet.
gt;
gt; I have attached a Word document of what the tables look like. I need to
gt; get the data from #1 worksheet to transfer to #2 worksheet and not have
gt; blank rows in between. I also don't want to run a VB script that will
gt; delete blank rows because the users of the Excel document will be
gt; confused on how to run it.
gt;
gt; I set up an IF statement on the cells to transfer the data from #1
gt; worksheet to #2 worksheet, but #2 worksheet looks exactly like #1. Does
gt; anybody know how I can get #1 worksheet to transfer over to #2 worksheet
gt; and look like how I have it set in the 2nd table in the attached
gt; document?
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: Excel Question.doc |
gt; |Download: www.excelforum.com/attachment.php?postid=4504 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; nickae77
gt; ------------------------------------------------------------------------
gt; nickae77's Profile:
www.excelforum.com/member.php...oamp;userid=32701
gt; View this thread: www.excelforum.com/showthread...hreadid=525283
gt;
Will you always have a block of 4 rows for each Part Number with a
blank row between blocks, or could the number of rows per block vary?

I would suggest that you copy the Part Number column to another sheet
and then sort this column, so that the blanks drop to the bottom and
you have a contiguous range of Part Numbers. This forms the basis of
your second table. You could then use the MATCH( ) function to get the
relative position (row) of a part number in the main table and use this
within an INDEX( ) formula in order to return the first line of the
Description, the Quantity, Unit Price and Sub-total columns - I would
suggest that you put the columns in this order. These four formulae can
then be copied down to complete the second table.

Hope this helps.

PeteUse this formula .

=Sheet1!D11 it means =(the name of your first sheet)!(cell you wish to copy
to the next page).

quot;nickae77quot; wrote:

gt;
gt; I am trying to set up a table in the #2 worksheet to get the data from
gt; the table in the #1 worksheet. I have it set up so that a user will
gt; enter data into #1 worksheet and it will automatically transfer to #2
gt; worksheet.
gt;
gt; I have attached a Word document of what the tables look like. I need to
gt; get the data from #1 worksheet to transfer to #2 worksheet and not have
gt; blank rows in between. I also don't want to run a VB script that will
gt; delete blank rows because the users of the Excel document will be
gt; confused on how to run it.
gt;
gt; I set up an IF statement on the cells to transfer the data from #1
gt; worksheet to #2 worksheet, but #2 worksheet looks exactly like #1. Does
gt; anybody know how I can get #1 worksheet to transfer over to #2 worksheet
gt; and look like how I have it set in the 2nd table in the attached
gt; document?
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: Excel Question.doc |
gt; |Download: www.excelforum.com/attachment.php?postid=4504 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; nickae77
gt; ------------------------------------------------------------------------
gt; nickae77's Profile: www.excelforum.com/member.php...oamp;userid=32701
gt; View this thread: www.excelforum.com/showthread...hreadid=525283
gt;
gt;