How to populate a summary page ????????????????????????????????????????

[George]

Dear All:

I have a excel workbook which contains two worksheets. Sheet 1 is my
input page. Sheet 2 is my summary page.


When my BINARY input numbers in any row under column A which is under
sheet 1 are equal to 1, I would like the whole row to be copied to
sheet 2.
When my input numbers in any row under column A which is under sheet 1
are equal to 0, the whole row will NOT be copied to sheet 2.


However, I don't like any gaps in sheet 2 AND I would like to keep the
same order in sheet 2 as in sheet 1. In addition, I would like this to
be done in an automatic procedure. No autofilter or any other manual
efforts. The following is an illustration of what I would like to see:


Under sheet 1


Column A ColumnB Column C ......


row1 1 Text1 1
row2 0 Text2 2
row3 0 Text3 3
row4 1 Text4 4


Since there are inputs in cell A1 and A2, the whole row 1 and row 2
will be copied AUTOMATICALLY to sheet 2 in the same order WITHOUT any
gap as follows:


Under sheet 2


ColumnA Column B Column C
row1 1 Text1 1
row2 1 Text4 4


Anybody knows how to achieve this? It is my headache. I really
appreciate your help! Thank you so much and I am looking forward to
hearing from you soon!


George

 

[Guest]

You can do this with array formulas.

If you want a sample formula, send me a sample workbook at (e-mail address removed)
and i will show you how.

 

[Niek Otten]

Hi George,

Explained here:

http://office.microsoft.com/en-us/assistance/HA012260381033.aspx


You'll be lookig up 1 in Column A and reurn multiple rows

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Dear All:
|
| I have a excel workbook which contains two worksheets. Sheet 1 is my
| input page. Sheet 2 is my summary page.
|
|
| When my BINARY input numbers in any row under column A which is under
| sheet 1 are equal to 1, I would like the whole row to be copied to
| sheet 2.
| When my input numbers in any row under column A which is under sheet 1
| are equal to 0, the whole row will NOT be copied to sheet 2.
|
|
| However, I don't like any gaps in sheet 2 AND I would like to keep the
| same order in sheet 2 as in sheet 1. In addition, I would like this to
| be done in an automatic procedure. No autofilter or any other manual
| efforts. The following is an illustration of what I would like to see:
|
|
| Under sheet 1
|
|
| Column A ColumnB Column C ......
|
|
| row1 1 Text1 1
| row2 0 Text2 2
| row3 0 Text3 3
| row4 1 Text4 4
|
|
| Since there are inputs in cell A1 and A2, the whole row 1 and row 2
| will be copied AUTOMATICALLY to sheet 2 in the same order WITHOUT any
| gap as follows:
|
|
| Under sheet 2
|
|
| ColumnA Column B Column C
| row1 1 Text1 1
| row2 1 Text4 4
|
|
| Anybody knows how to achieve this? It is my headache. I really
| appreciate your help! Thank you so much and I am looking forward to
| hearing from you soon!
|
|
| George
|

 

[George]

Hi, Niek:

Thanks for the response. I read your links but I do not fully
understand. Could you please show me in details? Anyway, I woul like
this to be an AUTOMATIC procedure.

Thanks again,

George

***************************************************************************************************************************

 

[George]

Hi, Tom:

I do not like to use an array since I do NOT know how many rows the
sheet 1 will have. The only thing I am sure is that the input is either
0 or 1.

I will highly appreciate your efforts if you have another way to do it.


Thanks again for your time and efforts in helping me out.

George
***************************************************************************************************************

 

[Niek Otten]

Hi George,

This is rather precise work!

Here we go.

Select A1:C4 on Sheet1.
Insert>Name>Define, type "LookupTab" without the quotes. OK.

Select A1 on Sheet2.

The following formula must be entered with CTRL-SHIFT-ENTER, that is, press and hold down SHIFT and CTRL, press ENTER and release
all.
You can copy the formula from here and paste it IN THE FORMULA BAR, Do not press ENTER yet,

Press CTRL-SHIFT-ENTER

Here's the formula:

=IF(ISERROR(SMALL(IF(LookupTab=1,ROW(LookupTab)),ROW(1:1))),"",INDEX(LookupTab,SMALL(IF(LookupTab=1,ROW(LookupTab)),ROW(1:1)),COLUMN(A1)))

After you entered it the way described above, it will show between curly brackets because it is an array formula.

Now you can copy down let's say 10 rows, and then copy right A1:A10 to columns B and C

Please let us know whether you succeded.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| Hi, Niek:
|
| Thanks for the response. I read your links but I do not fully
| understand. Could you please show me in details? Anyway, I woul like
| this to be an AUTOMATIC procedure.
|
| Thanks again,
|
| George
|
| ***************************************************************************************************************************
|
| Niek Otten wrote:
| > Hi George,
| >
| > Explained here:
| >
| > http://office.microsoft.com/en-us/assistance/HA012260381033.aspx
| >
| >
| > You'll be lookig up 1 in Column A and reurn multiple rows
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | Dear All:
| > |
| > | I have a excel workbook which contains two worksheets. Sheet 1 is my
| > | input page. Sheet 2 is my summary page.
| > |
| > |
| > | When my BINARY input numbers in any row under column A which is under
| > | sheet 1 are equal to 1, I would like the whole row to be copied to
| > | sheet 2.
| > | When my input numbers in any row under column A which is under sheet 1
| > | are equal to 0, the whole row will NOT be copied to sheet 2.
| > |
| > |
| > | However, I don't like any gaps in sheet 2 AND I would like to keep the
| > | same order in sheet 2 as in sheet 1. In addition, I would like this to
| > | be done in an automatic procedure. No autofilter or any other manual
| > | efforts. The following is an illustration of what I would like to see:
| > |
| > |
| > | Under sheet 1
| > |
| > |
| > | Column A ColumnB Column C ......
| > |
| > |
| > | row1 1 Text1 1
| > | row2 0 Text2 2
| > | row3 0 Text3 3
| > | row4 1 Text4 4
| > |
| > |
| > | Since there are inputs in cell A1 and A2, the whole row 1 and row 2
| > | will be copied AUTOMATICALLY to sheet 2 in the same order WITHOUT any
| > | gap as follows:
| > |
| > |
| > | Under sheet 2
| > |
| > |
| > | ColumnA Column B Column C
| > | row1 1 Text1 1
| > | row2 1 Text4 4
| > |
| > |
| > | Anybody knows how to achieve this? It is my headache. I really
| > | appreciate your help! Thank you so much and I am looking forward to
| > | hearing from you soon!
| > |
| > |
| > | George
| > |
|

 

[Ömer Ayzan]

Hi George
If I were you I would have filtered the rows that contain 1 and copy the
filtered range and paste it to the second sheet. The follovin code might do
the job:
Sub Test
dim rngCur as range ' Current range

Sheets("Sheet 1").activate
' assuming that you have data starting from A1
Range("A1").AutoFilter Field:=1, Criteria1:="1", Operator:=xlAnd
Set rngCur= range("A1").CurrentRegion
rngCur.Copy
Sheets("Sheet 2").activate
range("A1").Select
Selection.PasteSpecial Paste:= xlPasteAll
end sub

Ömer Ayzan

 

[Niek Otten]

You can make the array the maximum size you can expect: it will show nothing in the lower area if there are no matching records.

If you absolutely don't want array formulas, it can't be done with formulas.
Look at Filters.

The example I gave you (next post maybe) and probably Tom's solution too, are completely AUTOMATC, just like you asked.

| Hi, Tom:
|
| I do not like to use an array since I do NOT know how many rows the
| sheet 1 will have. The only thing I am sure is that the input is either
| 0 or 1.
|
| I will highly appreciate your efforts if you have another way to do it.
|
|
| Thanks again for your time and efforts in helping me out.
|
| George
| ***************************************************************************************************************
| George wrote:
| > Hi, Niek:
| >
| > Thanks for the response. I read your links but I do not fully
| > understand. Could you please show me in details? Anyway, I woul like
| > this to be an AUTOMATIC procedure.
| >
| > Thanks again,
| >
| > George
| >
| > ***************************************************************************************************************************
| >
| > Niek Otten wrote:
| > > Hi George,
| > >
| > > Explained here:
| > >
| > > http://office.microsoft.com/en-us/assistance/HA012260381033.aspx
| > >
| > >
| > > You'll be lookig up 1 in Column A and reurn multiple rows
| > >
| > > --
| > > Kind regards,
| > >
| > > Niek Otten
| > > Microsoft MVP - Excel
| > >
| > > | Dear All:
| > > |
| > > | I have a excel workbook which contains two worksheets. Sheet 1 is my
| > > | input page. Sheet 2 is my summary page.
| > > |
| > > |
| > > | When my BINARY input numbers in any row under column A which is under
| > > | sheet 1 are equal to 1, I would like the whole row to be copied to
| > > | sheet 2.
| > > | When my input numbers in any row under column A which is under sheet 1
| > > | are equal to 0, the whole row will NOT be copied to sheet 2.
| > > |
| > > |
| > > | However, I don't like any gaps in sheet 2 AND I would like to keep the
| > > | same order in sheet 2 as in sheet 1. In addition, I would like this to
| > > | be done in an automatic procedure. No autofilter or any other manual
| > > | efforts. The following is an illustration of what I would like to see:
| > > |
| > > |
| > > | Under sheet 1
| > > |
| > > |
| > > | Column A ColumnB Column C ......
| > > |
| > > |
| > > | row1 1 Text1 1
| > > | row2 0 Text2 2
| > > | row3 0 Text3 3
| > > | row4 1 Text4 4
| > > |
| > > |
| > > | Since there are inputs in cell A1 and A2, the whole row 1 and row 2
| > > | will be copied AUTOMATICALLY to sheet 2 in the same order WITHOUT any
| > > | gap as follows:
| > > |
| > > |
| > > | Under sheet 2
| > > |
| > > |
| > > | ColumnA Column B Column C
| > > | row1 1 Text1 1
| > > | row2 1 Text4 4
| > > |
| > > |
| > > | Anybody knows how to achieve this? It is my headache. I really
| > > | appreciate your help! Thank you so much and I am looking forward to
| > > | hearing from you soon!
| > > |
| > > |
| > > | George
| > > |
|

 

[George]

Hi, Niek:

Thanks for the help! Maybe I am stupid enough and I did not get it.
Here is what I did. Please tell me where I made a mistake.

Under sheet 1:
Select A1:C4
Insert>Name>Define, type "LookupTab"

Under sheet 2:
Select A1
Press and hold CTRL-SHIFT-ENTER, release all buttons,
Go to your webpage, select your formula, copy your formula by "CTRL+C",
Go back to sheet 2, paste your formula into A1 by "CTRL + V", position
my cursor on the small "+" sign located in the right bottom corner of
cell A1 and drag it down to A10, then extend it to colum B, C, D and so
on.

It looks like it give me rows with 0 input under column A in sheet 1.
That's not what I want. I only need rows with input of "1" under column
A in sheet 1 IN THE SAME ORDER.

Please point out where I made a mistake. I really appreciate your help.

Thanks,

George

 

[Niek Otten]

Hi George,

I didn't explain very well and, as I said, it is a very precise job!

But it works for me, so don't lose courage.

From your post:

<Press and hold CTRL-SHIFT-ENTER, release all buttons,
| Go to your webpage, select your formula, copy your formula by "CTRL+C",
| Go back to sheet 2, paste your formula into A1 by "CTRL + V>

here is where it goes wrong.

First copy the formula from my post,

Then select A1 on Sheet2, Click in the formula bar, Paste the formula there and then press CTRL-SHIFT-ENTER

The rest seems OK to me

Good luck and do let us know your results!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi, Niek:
|
| Thanks for the help! Maybe I am stupid enough and I did not get it.
| Here is what I did. Please tell me where I made a mistake.
|
| Under sheet 1:
| Select A1:C4
| Insert>Name>Define, type "LookupTab"
|
| Under sheet 2:
| Select A1
| Press and hold CTRL-SHIFT-ENTER, release all buttons,
| Go to your webpage, select your formula, copy your formula by "CTRL+C",
| Go back to sheet 2, paste your formula into A1 by "CTRL + V", position
| my cursor on the small "+" sign located in the right bottom corner of
| cell A1 and drag it down to A10, then extend it to colum B, C, D and so
| on.
|
| It looks like it give me rows with 0 input under column A in sheet 1.
| That's not what I want. I only need rows with input of "1" under column
| A in sheet 1 IN THE SAME ORDER.
|
| Please point out where I made a mistake. I really appreciate your help.
|
| Thanks,
|
| George
| Niek Otten wrote:
| > Hi George,
| >
| > This is rather precise work!
| >
| > Here we go.
| >
| > Select A1:C4 on Sheet1.
| > Insert>Name>Define, type "LookupTab" without the quotes. OK.
| >
| > Select A1 on Sheet2.
| >
| > The following formula must be entered with CTRL-SHIFT-ENTER, that is, press and hold down SHIFT and CTRL, press ENTER and
release
| > all.
| > You can copy the formula from here and paste it IN THE FORMULA BAR, Do not press ENTER yet,
| >
| > Press CTRL-SHIFT-ENTER
| >
| > Here's the formula:
| >
| >
=IF(ISERROR(SMALL(IF(LookupTab=1,ROW(LookupTab)),ROW(1:1))),"",INDEX(LookupTab,SMALL(IF(LookupTab=1,ROW(LookupTab)),ROW(1:1)),COLUMN(A1)))
| >
| > After you entered it the way described above, it will show between curly brackets because it is an array formula.
| >
| > Now you can copy down let's say 10 rows, and then copy right A1:A10 to columns B and C
| >
| > Please let us know whether you succeded.
| >
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| >
| > | Hi, Niek:
| > |
| > | Thanks for the response. I read your links but I do not fully
| > | understand. Could you please show me in details? Anyway, I woul like
| > | this to be an AUTOMATIC procedure.
| > |
| > | Thanks again,
| > |
| > | George
| > |
| > | ***************************************************************************************************************************
| > |
| > | Niek Otten wrote:
| > | > Hi George,
| > | >
| > | > Explained here:
| > | >
| > | > http://office.microsoft.com/en-us/assistance/HA012260381033.aspx
| > | >
| > | >
| > | > You'll be lookig up 1 in Column A and reurn multiple rows
| > | >
| > | > --
| > | > Kind regards,
| > | >
| > | > Niek Otten
| > | > Microsoft MVP - Excel
| > | >
| > | > | Dear All:
| > | > |
| > | > | I have a excel workbook which contains two worksheets. Sheet 1 is my
| > | > | input page. Sheet 2 is my summary page.
| > | > |
| > | > |
| > | > | When my BINARY input numbers in any row under column A which is under
| > | > | sheet 1 are equal to 1, I would like the whole row to be copied to
| > | > | sheet 2.
| > | > | When my input numbers in any row under column A which is under sheet 1
| > | > | are equal to 0, the whole row will NOT be copied to sheet 2.
| > | > |
| > | > |
| > | > | However, I don't like any gaps in sheet 2 AND I would like to keep the
| > | > | same order in sheet 2 as in sheet 1. In addition, I would like this to
| > | > | be done in an automatic procedure. No autofilter or any other manual
| > | > | efforts. The following is an illustration of what I would like to see:
| > | > |
| > | > |
| > | > | Under sheet 1
| > | > |
| > | > |
| > | > | Column A ColumnB Column C ......
| > | > |
| > | > |
| > | > | row1 1 Text1 1
| > | > | row2 0 Text2 2
| > | > | row3 0 Text3 3
| > | > | row4 1 Text4 4
| > | > |
| > | > |
| > | > | Since there are inputs in cell A1 and A2, the whole row 1 and row 2
| > | > | will be copied AUTOMATICALLY to sheet 2 in the same order WITHOUT any
| > | > | gap as follows:
| > | > |
| > | > |
| > | > | Under sheet 2
| > | > |
| > | > |
| > | > | ColumnA Column B Column C
| > | > | row1 1 Text1 1
| > | > | row2 1 Text4 4
| > | > |
| > | > |
| > | > | Anybody knows how to achieve this? It is my headache. I really
| > | > | appreciate your help! Thank you so much and I am looking forward to
| > | > | hearing from you soon!
| > | > |
| > | > |
| > | > | George
| > | > |
| > |
|

 

[George]

Hi, Omer:

Thanks for your help! What I need is an automatic process. I do not
like to do it manually. The only thing I would like to see is whenever
I input 0 or 1 under column A on sheet 1, all rows with input 1 will go
to sheet 2 IN THE SAME ORDER.

I would appricate your efforts if you have an alternative to achieve
this.

George

 

[George]

Hi, Niek:

I am sure it is a precise work. I am so sorry that I did not get it
yet. Could you please show me the whole process in more detail
including which keys to use? I apologize to give you a lot of troubles.

Thanks,

George

 

[Niek Otten]

Hi George,

<I apologize to give you a lot of troubles>

Don't!

I'll try again! I started with a blank workbook (except for the input table on Sheet1) and followed my own recipe and it worked.

Select A1:C4 on Sheet1.
Define a name for this range, like LookupTab. Defining a name can be done via the Insert>Name>Define menu or by clicking in the
Name box, that is the box to the left of the Formula bar.
Select the following formula and copy it:

=IF(ISERROR(SMALL(IF(LookupTab=1,ROW(LookupTab)),ROW(1:1))),"",INDEX(LookupTab,SMALL(IF(LookupTab=1,ROW(LookupTab)),ROW(1:1)),COLUMN(A1)))

Select A1 on Sheet2.
Click in the formula bar and paste (do not press ENTER yet), then press-and-hold CTRL and SHIFT, press ENTER (you have now 3 keys
pressed) and release the 3 keys. The formula should now show between curly brackets in the formula bar.

Now you can copy down as many rows as you like, and then copy right to columns B and C

Later on you can change the definition of LookupTab to accommodate your input rows.
--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi, Niek:
|
| I am sure it is a precise work. I am so sorry that I did not get it
| yet. Could you please show me the whole process in more detail
| including which keys to use? I apologize to give you a lot of troubles.
|
| Thanks,
|
| George
|
|
|

 

[Niek Otten]

<my own recipe >

That's unfair. It is mostly Ashish Mathur's recipe

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi George,
|
| <I apologize to give you a lot of troubles>
|
| Don't!
|
| I'll try again! I started with a blank workbook (except for the input table on Sheet1) and followed my own recipe and it worked.
|
| Select A1:C4 on Sheet1.
| Define a name for this range, like LookupTab. Defining a name can be done via the Insert>Name>Define menu or by clicking in the
| Name box, that is the box to the left of the Formula bar.
| Select the following formula and copy it:
|
|
=IF(ISERROR(SMALL(IF(LookupTab=1,ROW(LookupTab)),ROW(1:1))),"",INDEX(LookupTab,SMALL(IF(LookupTab=1,ROW(LookupTab)),ROW(1:1)),COLUMN(A1)))
|
| Select A1 on Sheet2.
| Click in the formula bar and paste (do not press ENTER yet), then press-and-hold CTRL and SHIFT, press ENTER (you have now 3
keys
| pressed) and release the 3 keys. The formula should now show between curly brackets in the formula bar.
|
| Now you can copy down as many rows as you like, and then copy right to columns B and C
|
| Later on you can change the definition of LookupTab to accommodate your input rows.
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
|| Hi, Niek:
||
|| I am sure it is a precise work. I am so sorry that I did not get it
|| yet. Could you please show me the whole process in more detail
|| including which keys to use? I apologize to give you a lot of troubles.
||
|| Thanks,
||
|| George
||
||
||
|
|

 

[Guest]

Offer withdrawn.

--
Regards,
Tom Ogilvy

You can do this with array formulas.

If you want a sample formula, send me a sample workbook at (e-mail address removed)
and i will show you how.

 

[George]

Hi, Niek:

It is perfect. I do not know how many thanks I need to tell you. But, I
will buy you a meal whenever you stop by Houston. E-mail me anytime and
I will get in touch with you!

Again, thank you so much for your help!

George

 

[Niek Otten]

Glad you got it working, George.

I had read Ashish's recipe before but this was the first time I applied it. So it was a useful exercise for me too!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi, Niek:
|
| It is perfect. I do not know how many thanks I need to tell you. But, I
| will buy you a meal whenever you stop by Houston. E-mail me anytime and
| I will get in touch with you!
|
| Again, thank you so much for your help!
|
| George
|
| Niek Otten wrote:
| > <my own recipe >
| >
| > That's unfair. It is mostly Ashish Mathur's recipe
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | Hi George,
| > |
| > | <I apologize to give you a lot of troubles>
| > |
| > | Don't!
| > |
| > | I'll try again! I started with a blank workbook (except for the input table on Sheet1) and followed my own recipe and it
worked.
| > |
| > | Select A1:C4 on Sheet1.
| > | Define a name for this range, like LookupTab. Defining a name can be done via the Insert>Name>Define menu or by clicking in
the
| > | Name box, that is the box to the left of the Formula bar.
| > | Select the following formula and copy it:
| > |
| > |
| >
=IF(ISERROR(SMALL(IF(LookupTab=1,ROW(LookupTab)),ROW(1:1))),"",INDEX(LookupTab,SMALL(IF(LookupTab=1,ROW(LookupTab)),ROW(1:1)),COLUMN(A1)))
| > |
| > | Select A1 on Sheet2.
| > | Click in the formula bar and paste (do not press ENTER yet), then press-and-hold CTRL and SHIFT, press ENTER (you have now 3
| > keys
| > | pressed) and release the 3 keys. The formula should now show between curly brackets in the formula bar.
| > |
| > | Now you can copy down as many rows as you like, and then copy right to columns B and C
| > |
| > | Later on you can change the definition of LookupTab to accommodate your input rows.
| > | --
| > | Kind regards,
| > |
| > | Niek Otten
| > | Microsoft MVP - Excel
| > |
| > || Hi, Niek:
| > ||
| > || I am sure it is a precise work. I am so sorry that I did not get it
| > || yet. Could you please show me the whole process in more detail
| > || including which keys to use? I apologize to give you a lot of troubles.
| > ||
| > || Thanks,
| > ||
| > || George
| > ||
| > ||
| > ||
| > |
| > |
|

 

[Ömer Ayzan]

Hi George,
Do you have row before you enter either 0 or one 1 into column A of that
row. If so you can write code for Worksheet_Change
event. In that event you check the content of the cell that is changed if it
is 1 than you copy the contents and than switch to sheet2 and paste whatever
you coppied. This scheme assumes that you just copy one row whose first cell
is the one you just edited.

You can use the following code: However you need to take the necessary
precautions not to copy the same row more than once. Cause change event
fires whenever you leave the current cell

Omer

Private Sub Worksheet_Change(ByVal Target As Range)
Dim bytData As Byte
Dim intCol As Integer
Dim lngRow As Long
Dim rngCur As Range

With Target
intCol = .Column
If intCol <> 1 Then Exit Sub ' We dont want todo any thing other
then first column
lngRow = .Row
End With

bytData = Target.Value

If bytData = 1 Then
Set rngCur = Range("A1").CurrentRegion.Rows(lngRow) ' Assumin g you
have data startin from a1
rngCur.Copy
CopyToMySht "Sheet2", "A1", xlPasteAll ' This always adds after
the end row of currentregion
End If
End Sub

Sub CopyToMySht(mySht As String, _
Off_Set As String, pMethode As XlPasteType)
Dim rCnt As Long
Dim rngPaste As Range


With Sheets(mySht)
If .Range(Off_Set) <> "" Then
rCnt = .Range(Off_Set).CurrentRegion.Rows.Count
Set rngPaste = .Range(Off_Set).Offset(rCnt)
Else
Set rngPaste = .Range(Off_Set)
End If
End With

rngPaste.PasteSpecial Paste:=pMethode, _
Operation:=xlNone, _
SkipBlanks:=False, _
Transpose:=False

Application.CutCopyMode = False

End Sub

Hi, Omer:

Thanks for your help! What I need is an automatic process. I do not
like to do it manually. The only thing I would like to see is whenever
I input 0 or 1 under column A on sheet 1, all rows with input 1 will go
to sheet 2 IN THE SAME ORDER.

I would appricate your efforts if you have an alternative to achieve
this.

George

 

[George]

Hi, Niek:

Everything is working fine. However, I do have another question.
That's, if 1 is the input under column A in sheet 1, then this whole
row with input 1 will be carried to sheet 2. The problem is if there
are some empty cells associated with this row with input 1, I do NOT
WANT a 0 showing up in sheet 2 in the corresponding cell. Could you
please help me on this?

Thank you so much!

George
*******************************************************************************************************************************************************************************************

 

[George]

Hi, Omer:

Thanks for your time and efforts. Each row under column A on sheet 1
has a default binary value 0-1. If the default value is 1, it means
that that row needs to be carried to sheet 2 all the time. If the
default value is 0, you can change it to 1 or leave it as 0. If you
change the value from 0 to 1, that row will be carried to sheet 2.
Otherwise, this row will not be transferred to sheet 2. What I need is
to have sheet 2 EXACTLY SAME AS sheet 1 with all row's input of 1 under
column A on sheet 1. Also, I would like this procedure to be done
automatically.

I still need you help on this. Thank you so much!

George
**********************************************************************************************