Greetings,
I have 15 sheets named t 1 through t 15. Each sheet contains 400 cells. There is a two digit number in these cells or they contain one space so they are not null [I hope].
I wish to collect and combine the result from each cell into a master sheet. So collect the result of cell one, sheet t 1 and put it into master sheet A1. Collect the cell result of one sheet t 2 and put it into master sheet A1. By the end of the process I should have a combination of 15 numbers and spaces in 400 cells in the master sheet.
By looking at cell C17 [or however I lay it out] I should be able to match each number in that cell to whatever one cell is referenced in each sheet.
Do I need VBA to do this?
Looking at excel help files I notice some errors in what they explain so it's been hit and miss trying to reference cells in different sheet pages and concatenate into one sheet.
Have a great evening,
Gene
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar