Need a shortcut for copying formulas on a master sheet that gets .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I am creating a workbook that will consist of over 100 sheets plus a master
sheet that will contain values carried over from these 100+ sheets. Each row
on the master represents data from the individual sheets. There are 8
columns of data in each row. The cell references are the same for all
sheets. I don't want to build over 800 formulas from scratch. Is there an
easy way to copy & paste the formulas in one row and have the system keep the
cell refereneces the same? and, in addition, is there an easy way to then
change the reference to the sheet name? The cell data being transferred is
an X or a blank (don't know if this matters.) Any ideas? Thanks. Maureen.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Compile Data from Different Sheets 2
Macro to Combine Data from Multiple Sheets with Cell References 4
hide multiple worksheets based on a formula value in one cell 1
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
Autohide rows based on formula in another sheet 0
Creating several smaller worksheets from a 'master sheet' 3
Reference Separate Sheet for Formula 2
Macro to increase cell range by 1 5

Back
Top