Linking Tabs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, hopefully someone can help me with this. I have a main worksheet with
several columns (ie...Date, Vendor, Description, Water, Phone, Cable) I have
several rows with detailed information for these charges for multiple
properties, so it is alot, not just one each month. I have totals on Water,
Phone, Cable...etc) I then have other tabs set up for each persons
breakdown. Not everyone gets all the charges only certain columns. So for
instance John Doe pays Water, Phone and Jane Doe pays for Cable and Phone.
In the individual tabs, how do I get the detail information to pull from the
main tab if a figure is entered into one of these columns on the main sheet?
Any help would be very much appreciated. Thanks.
 
Hi Lori

i saw your original post & Don's response and my initial response would also
be to suggest an IF statement - which doesn't seem to be what you're looking
for.

Are you looking for an automated solution where when a value is entered into
e.g. cell D5 of sheet one, (D being water) the whole line is copied to
John's sheet? If so, this will require quite a lot of VBA code and raises
issues such as if row 5 is copied to John's sheet and then you realise you
made a mistake in cell D5 and retype the value ... the code to copy will
fire again and then you'll have duplicate records in John's sheet.

The idea of the IF function suggested by Don would create a live link
between the two sheets, so if data was changed on one it would change on the
other. However, the down side is that if the entry on the main sheet is not
for something John pays for then it will appear as a blank row on his sheet.

So i guess the question comes back to - will an IF statement give you what
you're after?, if not how much VBA experience do you have?
 
Back
Top