pulling info from multiple sheets

G

Guest

I have 55 sheets in my file. I have one page that I am collecting data from
other sheets. So on the individual sheets I will have the same data for
different dates in cells C7 C14,C21,C28,C35,C42 and so on. On the sheet I am
collecting data I will have a list of the indidvidual sheets and columns
labeled with the individual data to be collected there. What I need
assistance with is this:
If on first row of my collection sheet I pull info from sheet #1
C7,D7,E7,F7, AND G7 and I would like on the same row to then pull from the
same sheet C14,D14,E14,F14 and G14, and then C21,D21,E21,F21, and G14 and so
on and so on. How do I copy and paste my formulas? Can I increment a formula
so when I copy it to a different rows it will automatically increment the
formula to pull data from the next sheet? Don't know if it possible, but it
woul sure save me time.
 
M

mevetts

Have you tried using the 'paste special' options? It allows you to past
formulas.

HTH.

Mark
 

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

create multiple sheets using info from one 2
Pulling data from one cell to another 3
Pulling one cell from Multiple sheets to one sheet 2
pulling from one sheet to another 3
Best Way to Pull Data from Other Sheets 6
Summary from multiple sheets 1
link issue 1
Merge Multiple workbook sheets into one workbook 0

Top