View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Harlen Harlen is offline
external usenet poster
 
Posts: 2
Default relative cell address

When I am missing some input information for column D of each row in Sheet1
of my spreadsheet, I need to mark(or name) the current cell in column D
Sheet1 so I can jump to cell C7 in Sheet2 to do some separate calculations
for Sheet1 and then jump back to the marked cell in Sheet1 and copy the value
(with no formating) from Sheet2 cell C27.
I have worked all evening and I have not been able to accomplish this. Any
ideas would be appreciated...