copy info from another sheet
 

I am using a column in sheet1 that I input the info, and I need that this
info go to
another sheet2 and then print it.

Return to sheet1
continue the process, input info........ go to sheet2 print it.

I don't know how to do it
I would appreciate any solution
Thanks
David

copy info from another sheet
 

Select your data in sheet1. Menu Edit|Copy.
Go to sheet2. Click on the destination cell. Menu Edit|Paste
Menu File|Print... Print what? Choose Active sheet.

HTH
Kostis Vezerides


Davidgg wrote:
I am using a column in sheet1 that I input the info, and I need that this
info go to
another sheet2 and then print it.

Return to sheet1
continue the process, input info........ go to sheet2 print it.

I don't know how to do it
I would appreciate any solution
Thanks
David

copy info from another sheet
 

Thanks Kostis for your promtly reply.
Let me be more specific, I am sorry.

In sheet1 I have a column example
TAXES
10
5
7.5
BLANK
12
etc...

In sheet2 I have like an Invoice, and at the moment that I type
in sheet1 10, automatically that 10 goes to sheet2 in "P5" and print it.
Go again to sheet1 and type 5, this 5 goes to P5 and repeat

I was doing in sheet2, like
=(0+Sheet1!P5) and it worked, but it worked only if I work on the same
cell on sheet1, but is in diferente row, in some rows there is nothing
blank.

Thanks for your info.
David


"vezerid" wrote:

Select your data in sheet1. Menu Edit|Copy.
Go to sheet2. Click on the destination cell. Menu Edit|Paste
Menu File|Print... Print what? Choose Active sheet.

HTH
Kostis Vezerides


Davidgg wrote:
I am using a column in sheet1 that I input the info, and I need that this
info go to
another sheet2 and then print it.

Return to sheet1
continue the process, input info........ go to sheet2 print it.

I don't know how to do it
I would appreciate any solution
Thanks
David

copy info from another sheet
 

David,
I have to go now, so someone else might jump in. But,
what exactly do you want?
The formula that you have in Sheet2 can be copied down. Thus you can
have a copy of Sheet1 into Sheet2 dynamically.
Do you want only the non-blank values in Sheet1 gathered together
neatly?

Also, the addition of 0 is for converting numbers in text format into
actual numbers. Otherwise, if Sheet1!P5 is text you will get a #VALUE!
error. It might be better to have something like:
=IF(Sheet1!P5="","",Sheet1!P5)

HTH
Kostis

Davidgg wrote:
Thanks Kostis for your promtly reply.
Let me be more specific, I am sorry.

In sheet1 I have a column example
TAXES
10
5
7.5
BLANK
12
etc...

In sheet2 I have like an Invoice, and at the moment that I type
in sheet1 10, automatically that 10 goes to sheet2 in "P5" and print it.
Go again to sheet1 and type 5, this 5 goes to P5 and repeat

I was doing in sheet2, like
=(0+Sheet1!P5) and it worked, but it worked only if I work on the same
cell on sheet1, but is in diferente row, in some rows there is nothing
blank.

Thanks for your info.
David


"vezerid" wrote:

Select your data in sheet1. Menu Edit|Copy.
Go to sheet2. Click on the destination cell. Menu Edit|Paste
Menu File|Print... Print what? Choose Active sheet.

HTH
Kostis Vezerides


Davidgg wrote:
I am using a column in sheet1 that I input the info, and I need that this
info go to
another sheet2 and then print it.

Return to sheet1
continue the process, input info........ go to sheet2 print it.

I don't know how to do it
I would appreciate any solution
Thanks
David

copy info from another sheet
 

David,
I have to go now, so someone else might jump in. But,
what exactly do you want?
The formula that you have in Sheet2 can be copied down. Thus you can
have a copy of Sheet1 into Sheet2 dynamically.
Do you want only the non-blank values in Sheet1 gathered together
neatly?

Also, the addition of 0 is for converting numbers in text format into
actual numbers. Otherwise, if Sheet1!P5 is text you will get a #VALUE!
error. It might be better to have something like:
=IF(Sheet1!P5="","",Sheet1!P5)

HTH
Kostis

Davidgg wrote:
Thanks Kostis for your promtly reply.
Let me be more specific, I am sorry.

In sheet1 I have a column example
TAXES
10
5
7.5
BLANK
12
etc...

In sheet2 I have like an Invoice, and at the moment that I type
in sheet1 10, automatically that 10 goes to sheet2 in "P5" and print it.
Go again to sheet1 and type 5, this 5 goes to P5 and repeat

I was doing in sheet2, like
=(0+Sheet1!P5) and it worked, but it worked only if I work on the same
cell on sheet1, but is in diferente row, in some rows there is nothing
blank.

Thanks for your info.
David


"vezerid" wrote:

Select your data in sheet1. Menu Edit|Copy.
Go to sheet2. Click on the destination cell. Menu Edit|Paste
Menu File|Print... Print what? Choose Active sheet.

HTH
Kostis Vezerides


Davidgg wrote:
I am using a column in sheet1 that I input the info, and I need that this
info go to
another sheet2 and then print it.

Return to sheet1
continue the process, input info........ go to sheet2 print it.

I don't know how to do it
I would appreciate any solution
Thanks
David

copy info from another sheet
 

This is the example

sheet1 = test

MPF EE
blank
$15.00
blank
blank
blank
$33.00
$400.00
$450.00
$150.00
blank
blank
===============
sheet2 = Inv

G40 - MPF 15 (this comes from TEST)
G11 ENTRY FEE 5
010 MEXICAN BROKER 15

TOTAL 35
right here I go to Print w/o a problem

My problem begin when I type the 33 or the 450 (in TEST I need only
that number: 33, on MPF, made the sum and print

===============

thanks
David

"vezerid" wrote:

David,
I have to go now, so someone else might jump in. But,
what exactly do you want?
The formula that you have in Sheet2 can be copied down. Thus you can
have a copy of Sheet1 into Sheet2 dynamically.
Do you want only the non-blank values in Sheet1 gathered together
neatly?

Also, the addition of 0 is for converting numbers in text format into
actual numbers. Otherwise, if Sheet1!P5 is text you will get a #VALUE!
error. It might be better to have something like:
=IF(Sheet1!P5="","",Sheet1!P5)

HTH
Kostis

Davidgg wrote:
Thanks Kostis for your promtly reply.
Let me be more specific, I am sorry.

In sheet1 I have a column example
TAXES
10
5
7.5
BLANK
12
etc...

In sheet2 I have like an Invoice, and at the moment that I type
in sheet1 10, automatically that 10 goes to sheet2 in "P5" and print it.
Go again to sheet1 and type 5, this 5 goes to P5 and repeat

I was doing in sheet2, like
=(0+Sheet1!P5) and it worked, but it worked only if I work on the same
cell on sheet1, but is in diferente row, in some rows there is nothing
blank.

Thanks for your info.
David


"vezerid" wrote:

Select your data in sheet1. Menu Edit|Copy.
Go to sheet2. Click on the destination cell. Menu Edit|Paste
Menu File|Print... Print what? Choose Active sheet.

HTH
Kostis Vezerides


Davidgg wrote:
I am using a column in sheet1 that I input the info, and I need that this
info go to
another sheet2 and then print it.

Return to sheet1
continue the process, input info........ go to sheet2 print it.

I don't know how to do it
I would appreciate any solution
Thanks
David