1
117lefty
Help!! I have two workbooks in Excel and I want to link the data.
Both books are about the same size...4 colums, 330 rows. No numbers,
just text in both. The problem is this: in the source file I have to
sometimes enter a row. This messes up the link to the destination
file. How can insert a row in the source file and have that same row
get entered into the destination file?
Also, when I create a link from my destination file to my source file
any empty row gets populated with a "0". How can I prevent that?
117lefty
Both books are about the same size...4 colums, 330 rows. No numbers,
just text in both. The problem is this: in the source file I have to
sometimes enter a row. This messes up the link to the destination
file. How can insert a row in the source file and have that same row
get entered into the destination file?
Also, when I create a link from my destination file to my source file
any empty row gets populated with a "0". How can I prevent that?
117lefty