Right, I have a spreadsheet that I want information entered in Sheet 1 to update the information on sheet 2 without loads of big formula parts. EG Colum A is a number as an age, Colum B is type either Scrap or Cips, and Colum C is a name of a person. So for example if I enter in Colum A a 0, then B Cips, then C J Bloggs, then A a 3, B Scrap, C A Bloggs, it then does a count of the Scrap (or Cips) that is J Bloggs and that is 1-3 old and tallys up each line.
2006-06-28 18:33:55 · 4 answers · asked by slave_or_dom_imboth 1 in Computers & Internet ➔ Programming & Design
If I understand you correctly, your sheet2 is the summary (with counts) of sheet1. If so, I suggest you use pivot table to do the counting for you.
You can enter as many rows as you can (as long as Excel can hold). Then select the columns with data and create a pivot table. Whenever you enter a new row of record, just refresh the pivot table and it'll summarize the count for you.
Go to microsoft.com/excel for help and tips on using Pivot tables. It's a powerful tool and you'll love it once you know how to use it.
2006-06-29 15:00:28 · answer #1 · answered by jxu 2 · 1⤊ 0⤋
You can actually add the info from sheet 2 to the bottom of sheet 1 have it cal.
2006-06-28 18:44:10 · answer #2 · answered by celtic-tides04@sbcglobal.net 2 · 0⤊ 0⤋
Use paiste link from editmenu or go to 2 sheet put formulae refering to the first sheet.
2006-06-28 18:37:59 · answer #3 · answered by bimalpoovadan 1 · 0⤊ 0⤋
right click and use paste special menu and select "only values"(or something useful for you)
2006-06-28 18:39:52 · answer #4 · answered by glimpse 1 · 0⤊ 0⤋