Excel/auto move rows


i have a workbook with multiple sheets that, I am trying to get excel to automatically cut and move a row of data from one sheet to another when data is contained in a cell within that row.Let me break down what i am trying to do. On the first sheet labeled stock locations contains layout of products placed in a warehouse, the second sheet labeled new items is where i will place info of new items that does not have a place in the warehouse yet, and then we have the third sheet labeled product list where it has the entire list of products with all their data. I want to move the row of data for new items to the complete list of products automatically when i find a location for the item, so once there is data in the row under the column new stock location it should be moved. in that cell i have a formula that searches the first sheet for the item and if it finds it it displays the location of the item where i placed it and it shows as blank when i have not placed the item yet.


that is a link to the workbook that i have to have a better idea of what i am trying to do. if you can help or point me in the direction of how i can get help with this it would be great thanks a lot.

This question appears to have been posted across the web in multiple locations.  This is nice for you, but will certainly waste the time of SOMEONE on one or more of those duplicate locations, people who are helping others for free would definitely be disappointed to hear the question they are helping with was already solved on another site elsewhere.

I'm sure you hadn't thought about that possibility, so there you have it.  Here's a link to one of the ones I noticed elsewhere.


It would be a courtesy if you added links to ALL the other places where you posted that same question in each of the duplicate location threads, so anyone considering helping you would be able to quickly click the links and see if the question remains unsolved across all locations.

I would recommend picking one good site like AllExperts or ExcelForum.com and ask your question there only, coupled with a little patience should insure you do not accidentally waste other people's time.  Thanks for your consideration.
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here


All Answers

Answers by Expert:

Ask Experts


Jerry Beaucaire


Excel Formulas, macros, automation. Microsoft Excel MVP - 2010. Code site with free code snippets and techniques: http://sites.madrocketscientist.com/jerrybeaucaires-excelassistant/files


Microsoft Excel MVP - 2010. I have my own extensive Excel help/code site: http://sites.madrocketscientist.com/jerrybeaucaires-excelassistant/files ===================== I have been offering free assistance as an Excel aid on many web sites for many years: (http://www.excelforum.com - JBeaucaire) ======== (http://www.askmehelpdesk.com/spreadsheets - JBeaucaire) ======= (http://www.mrexcel.com/forum - jbeaucaire)

Bachelor's Degree from Azusa Pacific University in Mathematics and Music Composition

Awards and Honors
Microsoft Excel MVP 2010

©2017 About.com. All rights reserved.