| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need another Formula Help for Copying Info Between 2 Pages
I need to know what formula i would use for this following situation.
I have a Excel Sheet in Excel 2003 First Sheet says: Credit Card Setup Second Sheet Says: Order Form There are fields in both of the Sheets that require Identical Information to be on both of the sheets. Now in the Order Form sheet i want a formula that will take for an example. Company Name Field which in the order form is B7 in the Credit Set Up form it is B10 now what i want is to put the formula on the Order Form so that i copies the field that corresponds with it on the Credit Card Setup form, so as i am typing in the credit card Setup sheet, it is automatically copying over to the Order form, so that i do not have to do duplicate typing. I really appreciate any help you can provide me. This is a copy of the formula that i was using before but my bosses changed the sheet on me and want me to use a specific format, so i need revision on the formula so that it will work with this one. =IF(Sheet1!B3<"",Sheet1!B3,"") Help Please |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need another Formula Help for Copying Info Between 2 Pages
Try =IF(Sheet1!B7="","",Sheet1!B7) in Sheet2 B10
-- kassie never stop learning "EmanJR" wrote in message ... I need to know what formula i would use for this following situation. I have a Excel Sheet in Excel 2003 First Sheet says: Credit Card Setup Second Sheet Says: Order Form There are fields in both of the Sheets that require Identical Information to be on both of the sheets. Now in the Order Form sheet i want a formula that will take for an example. Company Name Field which in the order form is B7 in the Credit Set Up form it is B10 now what i want is to put the formula on the Order Form so that i copies the field that corresponds with it on the Credit Card Setup form, so as i am typing in the credit card Setup sheet, it is automatically copying over to the Order form, so that i do not have to do duplicate typing. I really appreciate any help you can provide me. This is a copy of the formula that i was using before but my bosses changed the sheet on me and want me to use a specific format, so i need revision on the formula so that it will work with this one. =IF(Sheet1!B3<"",Sheet1!B3,"") Help Please |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need another Formula Help for Copying Info Between 2 Pages
It did not work, The formula that i gave as an example was going to the fact
that the sheet name that i was wanting to copy from was Sheet1, and now the Sheet name that i want to copy from is named Credit Card Setup, and the Sheet that i would be putting the formula into is Order Form. "Kassie" wrote: Try =IF(Sheet1!B7="","",Sheet1!B7) in Sheet2 B10 -- kassie never stop learning "EmanJR" wrote in message ... I need to know what formula i would use for this following situation. I have a Excel Sheet in Excel 2003 First Sheet says: Credit Card Setup Second Sheet Says: Order Form There are fields in both of the Sheets that require Identical Information to be on both of the sheets. Now in the Order Form sheet i want a formula that will take for an example. Company Name Field which in the order form is B7 in the Credit Set Up form it is B10 now what i want is to put the formula on the Order Form so that i copies the field that corresponds with it on the Credit Card Setup form, so as i am typing in the credit card Setup sheet, it is automatically copying over to the Order form, so that i do not have to do duplicate typing. I really appreciate any help you can provide me. This is a copy of the formula that i was using before but my bosses changed the sheet on me and want me to use a specific format, so i need revision on the formula so that it will work with this one. =IF(Sheet1!B3<"",Sheet1!B3,"") Help Please |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need another Formula Help for Copying Info Between 2 Pages
=IF('Credit Card Setup'!B7="","",'Credit Card Setup'!B7) should then do the
trick -- kassie never stop learning "EmanJR" wrote in message ... It did not work, The formula that i gave as an example was going to the fact that the sheet name that i was wanting to copy from was Sheet1, and now the Sheet name that i want to copy from is named Credit Card Setup, and the Sheet that i would be putting the formula into is Order Form. "Kassie" wrote: Try =IF(Sheet1!B7="","",Sheet1!B7) in Sheet2 B10 -- kassie never stop learning "EmanJR" wrote in message ... I need to know what formula i would use for this following situation. I have a Excel Sheet in Excel 2003 First Sheet says: Credit Card Setup Second Sheet Says: Order Form There are fields in both of the Sheets that require Identical Information to be on both of the sheets. Now in the Order Form sheet i want a formula that will take for an example. Company Name Field which in the order form is B7 in the Credit Set Up form it is B10 now what i want is to put the formula on the Order Form so that i copies the field that corresponds with it on the Credit Card Setup form, so as i am typing in the credit card Setup sheet, it is automatically copying over to the Order form, so that i do not have to do duplicate typing. I really appreciate any help you can provide me. This is a copy of the formula that i was using before but my bosses changed the sheet on me and want me to use a specific format, so i need revision on the formula so that it will work with this one. =IF(Sheet1!B3<"",Sheet1!B3,"") Help Please |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need another Formula Help for Copying Info Between 2 Pages
Thank you for your help
"Kassie" wrote: =IF('Credit Card Setup'!B7="","",'Credit Card Setup'!B7) should then do the trick -- kassie never stop learning "EmanJR" wrote in message ... It did not work, The formula that i gave as an example was going to the fact that the sheet name that i was wanting to copy from was Sheet1, and now the Sheet name that i want to copy from is named Credit Card Setup, and the Sheet that i would be putting the formula into is Order Form. "Kassie" wrote: Try =IF(Sheet1!B7="","",Sheet1!B7) in Sheet2 B10 -- kassie never stop learning "EmanJR" wrote in message ... I need to know what formula i would use for this following situation. I have a Excel Sheet in Excel 2003 First Sheet says: Credit Card Setup Second Sheet Says: Order Form There are fields in both of the Sheets that require Identical Information to be on both of the sheets. Now in the Order Form sheet i want a formula that will take for an example. Company Name Field which in the order form is B7 in the Credit Set Up form it is B10 now what i want is to put the formula on the Order Form so that i copies the field that corresponds with it on the Credit Card Setup form, so as i am typing in the credit card Setup sheet, it is automatically copying over to the Order form, so that i do not have to do duplicate typing. I really appreciate any help you can provide me. This is a copy of the formula that i was using before but my bosses changed the sheet on me and want me to use a specific format, so i need revision on the formula so that it will work with this one. =IF(Sheet1!B3<"",Sheet1!B3,"") Help Please |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if and then formula | Excel Worksheet Functions | |||
| How do write a formula so that only rows with info prints? | Excel Worksheet Functions | |||
| On excel, my formula will not calculate and add info into cell | Excel Worksheet Functions | |||
| External Link Shows Formula Not Info | Excel Worksheet Functions | |||
| how do I copy info from one sheet to another via a formula? | Excel Worksheet Functions | |||
Linear Mode
