View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rambler Rambler is offline
external usenet poster
 
Posts: 1
Default Post results to a new workbook

Hello

Realtive newbie here!

I am looking for a macro that will move worksheets to a master
workbook.

I have an order form with macros that save a file as a certain name and
forward it via email that works fine.

I want to have a macro the inserts the order worksheet into another
workbook so copies are kept in one master file. Another option is a
macro to post values to another workbook posted on a network drive,
where they can be totaled, i.e. order one becomes line one in another
workbook

Any suggestions?