| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loop Macro a variable number of times | Excel Discussion (Misc queries) | |||
| Is it possible? | Excel Worksheet Functions | |||
| Edit / Move or copy sheet stopped working in Excel 2003 | Excel Worksheet Functions | |||
| I need to merge lots of info, w/o copy paste? | Excel Worksheet Functions | |||
| Copy 1 Sheet to Another | Excel Worksheet Functions | |||
Linear Mode
