View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lorence Lorence is offline
external usenet poster
 
Posts: 3
Default Relative cells in different sheets in same workbook

Until I can get it into Access, I need to use a workbook for work,
with 10 sheets in it.

To collect data I want to select a range (relative to the cursor) and
then select the same range from each sheet, copying each line to a
single sheet in the same, or a different w/book

On the next day, I would position the cursor down one line and repeat
the exercise to generate historical data on one sheet

Help!!

Lorence