View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Excel novice Excel novice is offline
external usenet poster
 
Posts: 7
Default Overwrite tab 1 (1 save per overwite), continous update in tab 2.

My first tab is a request form, in which case some of the info is updated in
a row on the second tab. What i want to happen is to fill out the first tab
info, and automatically the data transfers to the second tab, then save.
PROBLEM: reopen the file, overwrite the first tab, while updating the second
tab but in the next row down. I want a new row updated for each time tab is
wrote over and saved.

Thank you and have a nice day