Re: $$Excel-Macros$$ copy new column from sheet 1 and paste to sheet 2

2016-02-09 Thread Kat
Thank you very much for your help. It's much appreciated. On Friday, 5 February 2016 23:16:28 UTC+8, era_kar wrote: > > Hi, > I give u the following code you can run and get what u expect. For the > next time u have to change the j value(i.e.,column > value,A=1 B=2 etc) to 6 to 7, and next time t

Re: $$Excel-Macros$$ copy new column from sheet 1 and paste to sheet 2

2016-02-05 Thread 'karunanithi ramaswamy' via MS EXCEL AND VBA MACROS
Hi,I give u the following code you can run and get what u expect. For the next time u have to change the j value(i.e.,columnvalue,A=1 B=2 etc) to 6 to 7, and next time this should be 8 to 9.Or if u don't mind in over printing the data,u can put j value = 4 to 33.It is upto u.Here the row is fixe