updating a worksheet from another worksheet

  • Thread starter Thread starter robertm
  • Start date Start date
R

robertm

I have a workbook that contains worksheets for each Month
and 1 worksheet called Combined

Example : Worksheet names in workbook are:
January
February
March
Combined

Each of the worksheets except the Combined worksheet
contains the same column Titles
Example

January worksheet has columns

A1 = NAME
B1 = Telephone
c1 = City
D1 = State

February worksheet has columns

A1 = NAME
B1 = Telephone
c1 = City
D1 = State

March worksheet has columns

A1 = NAME
B1 = Telephone
c1 = City
D1 = State

Combined worksheet has
A1 = City
B1 = Name


What I am looking to do to the Combined worksheet is have
it automatically updated with City and NAme Columns
when the data is entered on each of the Months Worksheets
where the City is equal to a Value. Example New York

any help would be greatly appreciated.
 
Robert
It's easy enough to do if all you want is to copy the City and name to
the Combined sheet whenever they are entered in one of the other 2 sheets.
The part I don't understand is:
"where the City is equal to a Value". What does that mean? What is it when
it's not equal to a value? HTH Otto
 
I don't like having this type thing automatic. I would bet you'd end up using a
macro and if someone opens the workbook with macros disabled, then your data
would be out of sync.

In fact, if you delete/change a record on the combined sheet, I would think
you'd want to update the corresponding sheet.

I like to just refresh those subordinate worksheets whenever I want.

If you like this idea, you may want to look at Debra Dalgleish's site:

http://www.contextures.com/excelfiles.html

There are a couple of files you may want to steal from:

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb
 
the worksheets contain may values for City, and I would
like to just have a populated list of those rows that
contain a city equal to one specific value. If the city
is not equal then I do not want to copy the data from the
monthly sheets.
hope this helps. and Thank you
 
Dave Thank you I will look at Debra Dalgleish's site
and see what kinds of examples she has and try to
incorperate them into what I am attempting to do.

just a note: I am pretty familiar with using spreadsheets
in general, just not comfortable writing functions and
array formulas. I was just asked to try and automate this
so that the individual who uses the sheets did not have
to do anything but look at the report page and take
action accordingly. That person has very little knowledge
of Windows let alone spreadsheet capabilities.
Thank you though for the assistance
RM
 
Back
Top