$$Excel-Macros$$ Change all the destination cell

2012-10-20 Thread chhajersandeep
Dear All, Suppose I have column of data which is linked with column d of another sheet. Like 'Sheet1!D5 'Sheet1!D6 'Sheet1!D7 'Sheet1!D8 'Sheet1!D9so on. Now I want the destination column of entire linked column to be changed to e like 'Sheet1!e5 'Sheet1!e6 'Sheet1!e7 'Sheet1!e8

Re: $$Excel-Macros$$ Change all the destination cell

2012-10-20 Thread vba
-Macros$$ Change all the destination cell Dear All, Suppose I have column of data which is linked with column d of another sheet. Like 'Sheet1!D5 'Sheet1!D6 'Sheet1!D7 'Sheet1!D8 'Sheet1!D9so on. Now I want the destination column of entire linked column to be changed to e like 'Sheet1!e5

Re: $$Excel-Macros$$ Change all the destination cell

2012-10-20 Thread vba
@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Change all the destination cell Dear All, Suppose I have column of data which is linked with column d of another sheet. Like 'Sheet1!D5 'Sheet1!D6 'Sheet1!D7 'Sheet1!D8 'Sheet1!D9so on. Now I want the destination