Pls Help Me!

  • Thread starter Thread starter davidtips
  • Start date Start date
D

davidtips

:confused: Hello there! Greeting.

I have 2 files named *Master.xls * & *Copy.xls *

In *Master.xls * (sheet1), colunm A & B which content Name & Birthda
respectively.
This is an ongoing database whereby new names will be input to thi
sheet day by day.

How can I linked & updated to *Copy.xls * (sheet1) whenever m
*Master.xls * is updated?

I mean both files on sheet1 colunm A & B is identical.

Thanks!

davidie
 
One way:

In Copy.xls, sheet1, enter

A1: =IF([Master.xls]Sheet1!A1<>"",[Master.xls]Sheet1!A1,"")

Copy to B1, then down as far as desired.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pls Help Me! 1
copy worksheet from closed workbook to active workbook using vba 6
HELP: how to evaluate a filename when looking up another sheet? 3
Please Help - Trouble with counting occurrences in external file 2
Pls help me!! 2
Semi-Complicated Question... 1
need function/formula help!! 4
Automating copying of data from different worksheets. 2

Back
Top