Prev: If statment problem
Next: Text to Column will not cooperate
From: T on 28 May 2010 14:59
I have 2 seperate spreadsheets one with monthly info and one with yearly
info. I wondered if there was a way to update the same info in one
spreadsheet and it automatically fill in in the other spreadsheet since its
the same information going into both databases without having to copy/paste
all the time
From: Don Guillett on 28 May 2010 15:17
why not have one where you filter for month ???
data>filter>autofilter
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"T" <T(a)discussions.microsoft.com> wrote in message
news:9E30B3EE-2D44-4E1D-8F10-16CC36DB8D6E(a)microsoft.com...
>I have 2 seperate spreadsheets one with monthly info and one with yearly
> info. I wondered if there was a way to update the same info in one
> spreadsheet and it automatically fill in in the other spreadsheet since
> its
> the same information going into both databases without having to
> copy/paste
> all the time

 | 
Pages: 1
Prev: If statment problem
Next: Text to Column will not cooperate