View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
misscharliebrown misscharliebrown is offline
external usenet poster
 
Posts: 7
Default adding rows, pasting values then empty sheet

Hi:
If I import a report weekly (and therefore though it has the same columns -
5, the row number varies) onto a worksheet "synergy". How can I move all this
to the worksheet "lifetime" (same workbook) at the next available row at the
bottom of the table located in "lifetime". With the values still intacted
(colums include date and numbers). then erase the synergy worksheet ready for
the nexts weeks update?