View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gustakovish Gustakovish is offline
external usenet poster
 
Posts: 1
Default How to create multi-spreadsheet scenarios in an excel workbook

Can a scenario be created to modify cells in several tabs (spreadsheets) of
an excel workbook?
I have a clomplex model that feeds from more than one spreadsheet (all
spreadsheets are in the same workbook) and when I try to add cells from more
than 1 spreadsheet in the cells to be changed field it only keeps those of
the last spreadsheet I selected or gives me an error.