| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy data from once worksheet to another using formula
I am trying to create a formula in which I am able to copy data from one
worksheet to a cell of a different worksheet in the SAME workbook based on specific criteria. For example, if cell A2 on Worksheet A contains item data, I want to copy that exact data to Worksheet B cell D50. I need to use a formula as there will be additional criteria added later on. How should I proceed? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy data from once worksheet to another using formula
Use something like this in D50 of Worksheet B
=IF('WorkSheet A'!A2100,'WorkSheet A'!A2,"Not 100") "Maureen" wrote: I am trying to create a formula in which I am able to copy data from one worksheet to a cell of a different worksheet in the SAME workbook based on specific criteria. For example, if cell A2 on Worksheet A contains item data, I want to copy that exact data to Worksheet B cell D50. I need to use a formula as there will be additional criteria added later on. How should I proceed? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy data from once worksheet to another using formula
Thanks I will give i a try
"Sheeloo" wrote: Use something like this in D50 of Worksheet B =IF('WorkSheet A'!A2100,'WorkSheet A'!A2,"Not 100") "Maureen" wrote: I am trying to create a formula in which I am able to copy data from one worksheet to a cell of a different worksheet in the SAME workbook based on specific criteria. For example, if cell A2 on Worksheet A contains item data, I want to copy that exact data to Worksheet B cell D50. I need to use a formula as there will be additional criteria added later on. How should I proceed? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A formula to filter data and copy it from one worksheet to another | Excel Worksheet Functions | |||
| copy from B worksheet to A worksheet with NO repeated data | Excel Discussion (Misc queries) | |||
| copy data in a cell from worksheet A to worksheet B | Excel Discussion (Misc queries) | |||
| Copy Data from one worksheet to another | Excel Discussion (Misc queries) | |||
| Copy data into a NEW worksheet | Excel Discussion (Misc queries) | |||
![Maureen[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
