Re: $$Excel-Macros$$ Macro for format table

2012-03-15 Thread dguillett1
I don't understand your need and WHY Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Rajesh K R Sent: Thursday, March 15, 2012 12:16 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro for format table Hi Thank u

Re: $$Excel-Macros$$ Macro for format table

2012-03-14 Thread Rajesh K R
).Row Cells(fr, i).Resize(lr).Copy Cells(2, i + 6) Next i End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Rajesh K R Sent: Tuesday, March 13, 2012 8:50 AM To: excel-macros Subject: $$Excel-Macros$$ Macro for format table

Re: $$Excel-Macros$$ Macro for format table

2012-03-14 Thread Rajesh K R
Hi Thank u for ur reply, still I need some more changes in the code, pls check the attached xl file, it will show step by step what to do.pls make the necessary change in the code for getting the result. Sub CopyColumnsToTableSAS() Dim i As Integer Dim fr As Long Dim lr As Long 'col A Cells(2,

$$Excel-Macros$$ Macro for format table

2012-03-13 Thread Rajesh K R
Hi experts Find the attached file,and help me to create a macro to format a table from the data given. My idea to solve this select column A:E, paste in G1 Select blank cells in column B ,here B2:B26 Deletethem Repeat the sale in next columns Regards Rajesh Kainikkara -- FORUM

Re: $$Excel-Macros$$ Macro for format table

2012-03-13 Thread dguillett1
Cells(2, i + 6) Next i End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Rajesh K R Sent: Tuesday, March 13, 2012 8:50 AM To: excel-macros Subject: $$Excel-Macros$$ Macro for format table Hi experts Find the attached file,and help me