Transferring Data based on entering number in column

**briancambier** · 11-15-2014, 04:56 PM

Hello all, here is my issue that I just cannot figure out. A little about what I am trying to accomplish:
I have a master list of supplies that I use for various remodel projects. Let's just say column A is blank and this is where I go through the entire list adding a number for the amount of each item I need to order. I would like to have the entire row that I have entered an amount in column A transfer to the next sheet. Only the items would transfer to the next sheet and of course the amount of the items from column A. This way I can send this right off to the supplier for order and also use it for cost analysis. Can anyone please point me in the right direction? Thank you!

**Tony Valko** · 11-15-2014, 05:04 PM

Originally Posted by briancambier

I would like to have the entire row that I have entered an amount in column A transfer to the next sheet.

How many columns on the row need to be copied over?

Be more specific. Tell us the actual range addresses.

**davesexcel** · 11-15-2014, 05:04 PM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**briancambier** · 11-15-2014, 06:16 PM

Thanks for the replies. Sorry that was a bit vague. Here is a sample of what I am looking at. On Sheet 1, I am going through
and entering a quantity amount in column C. Once I enter the quantity, I would like it to automatically transfer only those rows onto the next sheet. I just cut and copy to sheet 2 what I am hoping I can accomplish automatically. Then I can figure out a
material cost for only the items we need for a specific job. Thanks for any help.

example.xlsx