Need help moving data from one sheet to another

I have a doc that I would like to have populate one from multiple sheets based on a yes or no or sold/denied not over write one another when moving the data to the one location.

Here is what I have so far that is working on the Deaths and Live Subtraction sheets.

=IFERROR(IFERROR(INDEX('Inventory Form'!C:C,SMALL(IF('Inventory Form'!$L$11:$L$1027="Yes",ROW($C$11:$C$1027)),ROWS($1:3))),INDEX(Newborns!C:C,SMALL(IF(Newborns!$I$10:$I$132="Sold",ROW($C$10:$C$132)),ROWS($1:3)-COUNTIF('Inventory Form'!$L:$L,"Yes")))),"")



What I need is when died or sold is chosen from the purchased additions sheet to move the id's to the correct sheet, deaths or purchased additions . If sold is chosen it needs to take the ID's from the purchased additions page and add it to the live subtraction page in the id locations, if died is chosen then move the id's to the deaths page in the id locations, but not overwrite any of the other data being moved to these locations..

I tried to add the following but it's not working INDEX(Purchased Additions !C:C,SMALL(IF(Purchased Additions!$M$10:$M$221="Sold",ROW($C$10:$C$132)),ROWS($1:3)

I have attempted to attach my doc as I am sure it's easier to see there.

Any help would be appreciated.

A couple things.

if died is chosen then move the id's

Formulas cannot move anything. It may just be a matter of terminology you are using but I want to make sure that conceptually you understand the formula cant actually move anything. Basically the formula either returns a result or it returns an error. So we can create logic in formulas that causes a result for one formula and not another.

It would for me at least, be helpful if you could provide a sample of expected results (manually entered) with an explanation of the logic to how you get the result. It would also be helpful to use references when explaining the location of formulas and information. In a couple places in your OP you mention acting upon some information to return a result without specifically stating locations of the information to be reviewed and/or where to return the result. It would help us help you to have those types of things explained in exact terms.

You may also consider consolidating your sheets into a single sheet before trying to parse it out to other sheets. Excel shines when taking a single data set and breaking the information down. On the other hand databases are much better at creating relationships between separate tables/data sets and then working with it as a whole dataset.

Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

I thought this was fairly clear esp if you take time to look at the doc-- sorry and thanks for responding.


"What I need is when died or sold is chosen from the purchased additions sheet to move the id's to the correct sheet, deaths or purchased additions. If sold is chosen it needs to take the ID's from the purchased additions page and add it to the live subtraction page in the id locations, if died is chosen then move the id's to the deaths page in the id locations, but not overwrite any of the other data being moved to these locations."

You are correct formulas don't "move" anything. I am not perfect with the terminology nor do I claim to be, if I was I would be helping here vs posing for help and getting me on track with terminology

Sheets are already created and there are other items built that that move data from one location to another so I don't want to merge them back into one. But do agree if starting from day one it would be easier that way.

Originally Posted by herbie000

I thought this was fairly clear esp if you take time to look at the doc-- sorry and thanks for responding.


"What I need is when died or sold is chosen from the purchased additions sheet to move the id's to the correct sheet, deaths or purchased additions #1. If sold is chosen #2 it needs to take the ID's from the purchased additions page and add it to the live subtraction page in the id locations, if died is chosen #3 then move the id's to the deaths page in the id locations, but not overwrite any of the other data being moved to these locations."

You are correct formulas don't "move" anything. I am not perfect with the terminology nor do I claim to be, if I was I would be helping here vs posing for help and getting me on track with terminology

Sheets are already created and there are other items built that that move data from one location to another so I don't want to merge them back into one. But do agree if starting from day one it would be easier that way.

1. Where on the sheet, can I put them in cell AXZ49?
2. Chosen where, appears on many sheets?
3. Chosen where, appears on many sheets?

I want to point out I am not trying to be argumentative. The only thing we have to go by to help you is your written posts and your sample file. The more detailed you explain things the better (cell references, sheet names, column/row headers, etc). Much of the file you take for granted because its your file (so you understand why it is as it is), but understand we have never seen it before, have no idea what your goals are, no idea what other considerations there may be, nor anything to compare it to to know its working properly other than what you tell us. I only pointed out the terminology so that we are speaking to each other in like terms, as you very well could have meant to move the data (which is perfectly valid, albeit by other means).