Pulling data from one worksheet to another

[imported_unknown]

I have a worksheet #1 that has 4 columns (amount, description, price and total). When I enter an amount it calculates the total automatically. My problem is I now want to take any totals that are > than zero and enter them into an invoice that I have on worksheet #2. Any suggestions or help would be appreciated.....

 

[PaddyD]

Hi - welcome to the board!

Depending on what you mean by "enter them into.." etc, could you filter the totlas column for values >0, copy the resulting rows & paste special...values into the invoice area? Or were you looking for something a little more 'automated'? (In which case, start by recording the above actions & see what you get...)

Paddy

 

[imported_unknown]

That didn't work. On Sheet one I have a list of products where I enter the quantity someone is ordering. I then want only the products with a quantity to be copied and pasted to Sheet 2 (the invoice.) Thanks for any help.

 

[PaddyD]

could you be a bit more specific re the "that didn't work". In your first post, you wanted a filter for > 0. Now you're saying ignore blanks? If it's the latter, & the filter option is OK, simply filter for "non blanks".

What exactly is the problem here?

paddy

 

[imported_unknown]

When I say that didn't work this is what I mean. I made a macro that filtered anything >0 and copied and pasted it into Sheet #2. But when I run the macro it only copies the cells that had been selected. The problem with that is the next time there might be another product selected. The file I am working with is at http:://www.thelarster.com/test/MLSheet.xls Thank you for you help thus far.

 

[PaddyD]

how about postin gthe code you've currently got & a description of the desired result
Paddy