Creating formulas or macros

E

Electroplastik

I have a workbook that has multiple sheets with different information in each
sheet that needs to move to new results sheet.
I need to take the following cells c9 e9 g9 i9 c10 e10 from the all of the
sheets and put the results into a new sheet going accross the page. The
following sheets have the data in the same places as the first sheet c9 e9 g9
etc. but the results need to be placed the next lines down so that none of
the information is overwritten. Would a formula or a macro be better for this
and what would the formula look like ? The results will be in another sheet
in the same workbook.
Cheers Shaun
 

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

Quick help with a simple function! 4
text function? 11
Move selected cells to new destination via macro / formula / VB ed 3
help with a formula 2
Macro to hide rows with zero in specifc column range 2
Array formula - nee help 0
Extract workbook information 3
Formula error when created via VBA 2

Top