How to get a row consecutive from a sheet to another
 

I hope I can get your help please. I want to know how to obtain
consecutive data from a sheet to another sheet in the same excel book.
I registered data in sheet one for different sheet in the book. I want
this data to b transferred automatically from sheet one to the
different sheets row sequency.

Example: Sheet one Row 23 567 to Sheet six Row 6 567
Sheet one Row 65 879 to Sheet six Row 7
879

As well data can be transferred to another sheets from Sheet one as
same fashion.

I hope there is some help for this problem.

Thanks


--
rodante
------------------------------------------------------------------------
rodante's Profile: http://www.excelforum.com/member.php...o&userid=28251
View this thread: http://www.excelforum.com/showthread...hreadid=479998

How to get a row consecutive from a sheet to another
 

Hi!

If there is some logic that can be put into a formula, then yes, this is
fairly easy.

In other words, why do you want 567 and 879 from sheet1 to "transfer" to
sheet6? What criteria do these values represent?

If you can build that type of logic into a formula then you can do this!

Biff

"rodante" wrote in
message ...

I hope I can get your help please. I want to know how to obtain
consecutive data from a sheet to another sheet in the same excel book.
I registered data in sheet one for different sheet in the book. I want
this data to b transferred automatically from sheet one to the
different sheets row sequency.

Example: Sheet one Row 23 567 to Sheet six Row 6 567
Sheet one Row 65 879 to Sheet six Row 7
879

As well data can be transferred to another sheets from Sheet one as
same fashion.

I hope there is some help for this problem.

Thanks


--
rodante
------------------------------------------------------------------------
rodante's Profile:
http://www.excelforum.com/member.php...o&userid=28251
View this thread: http://www.excelforum.com/showthread...hreadid=479998

How to get a row consecutive from a sheet to another
 

Biff Wrote:
Hi!

If there is some logic that can be put into a formula, then yes, this
is
fairly easy.

In other words, why do you want 567 and 879 from sheet1 to "transfer"
to
sheet6? *Because Sheet 1 represents data general register to be
transferred to different account sheets.*

What criteria do these values represent? *Represents value data to be
used to complete financial reports.*

If you can build that type of logic into a formula then you can do
this! *Can you help with some formula ideas?*


Thanks for answering Biff¡
rodante


--
rodante
------------------------------------------------------------------------
rodante's Profile: http://www.excelforum.com/member.php...o&userid=28251
View this thread: http://www.excelforum.com/showthread...hreadid=479998

How to get a row consecutive from a sheet to another
 

Hi!

You need to provide much more detail.

Also, when I say that there has to be some logic that you can apply to the
data and then build that logic into a formula, this is what I meant.
Consider these examples:

Assume sheet1 looks like this:

...........A..........B..........
1......400.....................
2......567.....................
3......212.....................
4......879.....................
5......397.....................

You want to extract data from column A where the value is greater than 500.
The logic is any value 500. We can build that logic into a formula and
extract the data that meets that condition and return it to another
location.

Assume sheet1 looks like this:

...........A..........B..........
1......400........No........
2......567........Yes.......
3......212........No........
4......879........Yes.......
5......397........No........

You want to extract data from column A where the corresponding value in
column B is Yes. The logic is where the corresponding value in column B is
Yes. We can build that logic into a formula and extract the data that meets
that condition and return it to another location.

So, you need to provide an explanation that includes the logic, where the
data is located and where you want the extracted data to appear. You must be
VERY SPECIFIC! Don't just say: I have data in column A. Where EXACTLY in
column A?

Biff

"rodante" wrote in
message ...

Biff Wrote:
Hi!

If there is some logic that can be put into a formula, then yes, this
is
fairly easy.

In other words, why do you want 567 and 879 from sheet1 to "transfer"
to
sheet6? *Because Sheet 1 represents data general register to be
transferred to different account sheets.*

What criteria do these values represent? *Represents value data to be
used to complete financial reports.*

If you can build that type of logic into a formula then you can do
this! *Can you help with some formula ideas?*


Thanks for answering Biff¡
rodante


--
rodante
------------------------------------------------------------------------
rodante's Profile:
http://www.excelforum.com/member.php...o&userid=28251
View this thread: http://www.excelforum.com/showthread...hreadid=479998

How to get a row consecutive from a sheet to another
 

Hi!

You are complete right, I have not provide enough information, so I
apologize for this inconvenience, as well I appreciate all your time
used in help me with this problem. I am attaching these files, because
I can´t not submmit files with xls extension I am submitted as pdf.
From Catalog Sheet accounts are transfered automatically to Register
Sheet, from Register Sheet data is transfered to Account Sheet but this
data is not in a consecutive row fashion needed. I manually construct
Account Sheets every time that one is needed. I hope will help to a
better understanding.

Thanks Biff

Biff Wrote:
Hi!

You need to provide much more detail.

Also, when I say that there has to be some logic that you can apply to
the
data and then build that logic into a formula, this is what I meant.
Consider these examples:

Assume sheet1 looks like this:

...........A..........B..........
1......400.....................
2......567.....................
3......212.....................
4......879.....................
5......397.....................

You want to extract data from column A where the value is greater than
500.
The logic is any value 500. We can build that logic into a formula
and
extract the data that meets that condition and return it to another
location.

Assume sheet1 looks like this:

...........A..........B..........
1......400........No........
2......567........Yes.......
3......212........No........
4......879........Yes.......
5......397........No........

You want to extract data from column A where the corresponding value
in
column B is Yes. The logic is where the corresponding value in column B
is
Yes. We can build that logic into a formula and extract the data that
meets
that condition and return it to another location.

So, you need to provide an explanation that includes the logic, where
the
data is located and where you want the extracted data to appear. You
must be
VERY SPECIFIC! Don't just say: I have data in column A. Where EXACTLY
in
column A?

Biff

"rodante" wrote
in
message ...

Biff Wrote:
Hi!

If there is some logic that can be put into a formula, then yes,
this
is
fairly easy.

In other words, why do you want 567 and 879 from sheet1 to
"transfer"
to
sheet6? *Because Sheet 1 represents data general register to be
transferred to different account sheets.*

What criteria do these values represent? *Represents value data to
be
used to complete financial reports.*

If you can build that type of logic into a formula then you can do
this! *Can you help with some formula ideas?*


Thanks for answering Biff¡
rodante


--
rodante

------------------------------------------------------------------------
rodante's Profile:
http://www.excelforum.com/member.php...o&userid=28251
View this thread:
http://www.excelforum.com/showthread...hreadid=479998



+-------------------------------------------------------------------+
|Filename: Account.pdf |
|Download: http://www.excelforum.com/attachment.php?postid=3966 |
+-------------------------------------------------------------------+

--
rodante
------------------------------------------------------------------------
rodante's Profile: http://www.excelforum.com/member.php...o&userid=28251
View this thread: http://www.excelforum.com/showthread...hreadid=479998