How to get a row consecutive from a sheet to another

  • Thread starter Thread starter rodante
  • Start date Start date
R

rodante

I hope I can get your help please. I want to know how to obtai
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 wan
this data to b transferred automatically from sheet one to th
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 a
same fashion.

I hope there is some help for this problem.

Thank
 
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
 
Biff said:
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
Click to expand...
 
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
 
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
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

in
message news:[email protected]...
Click to expand...


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