View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
AltaEgo AltaEgo is offline
external usenet poster
 
Posts: 245
Default Updating data from one worksheet to another

1) Open your summary sheet.
2) Click on the cell where you want the summary to start.
3) Type '=' in the formula bar (without quotes)
4) Click your main sheet tab
5) Click the first value in the first column you want in the summary sheet
6) press enter.

After pressing [Enter] you should find yourself back in the summary sheet
with a cell containing a formula like =Sheet1!A1

Drag this down using the fill handle (or copy).

If your summary data are in adjacent columns you can drag (or copy) across.

--
Steve

"joe2017" wrote in message
...
I've created an in-depth spreadsheet to organize information. I need to
then
take a few columns of that information and put it into a more concise,
easier
to sift through worksheet.

This list will be updated frequently. Is there any way I can create this
secondary list and have it automatically fill in information that is
entered
into the first, more thorough list? I'm just trying to avoid entering
things
twice and make it easier for the next person to use.

Thanks in advance.