#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jon jon is offline
external usenet poster
 
Posts: 13
Default COPY / APPEND`

Hi,
I have an excel document with 2 sheets.

The first sheet contains an order that I wish to place, being 2 columns (A=
Product and B = Quantity).

I need a button that copies the product and quantity from every line in
sheet 1 where the quantity is 0 and appends it to sheet 2 ( which is my
sales order history table).

Any ideas ?

Thanks

Jon

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to copy and append spreadsheet changes to new spreadsheet Journey Excel Discussion (Misc queries) 1 June 13th 08 04:33 PM
Copy and Append Macro Excel Help! Excel Discussion (Misc queries) 2 April 7th 08 05:39 PM
How do you append one row to another? BobVanS Excel Worksheet Functions 3 August 30th 07 02:04 PM
Append text Jeff Excel Discussion (Misc queries) 1 February 16th 07 10:28 PM
Macro that will Cut rows and then insert-copy or append rod Excel Discussion (Misc queries) 3 October 21st 06 04:50 PM


All times are GMT +1. The time now is 04:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"