$$Excel-Macros$$ Re: VBA Code for Create Name Range

2016-01-24 Thread Mandeep Baluja
> > Check this out !!! Regards, Mandeep baluja > https://www.linkedin.com/messaging/thread/6086488646137958400 https://www.facebook.com/groups/825221420889809/?fref=nf Sub Creatnamedrange() Dim Sdic As Object Dim Nrows As Long Dim workrng As Range Dim col As Long: col = 1 Nrows = Sheets(

Re: $$Excel-Macros$$ Create Multiple sheet

2016-01-24 Thread Shrinivas Shevde
Really a great job Very very thanks Regards Shrinivas On Mon, Jan 25, 2016 at 11:49 AM, Abhishek Jain wrote: > Please see attached. > > HTH > > On Mon, Jan 25, 2016 at 11:43 AM, Shrinivas Shevde > wrote: > >> Dear Abhishek >> Thanks for the macros.Its exactly As I want. >> Can you do only a sma

Re: $$Excel-Macros$$ Create Multiple sheet

2016-01-24 Thread Abhishek Jain
Please see attached. HTH On Mon, Jan 25, 2016 at 11:43 AM, Shrinivas Shevde wrote: > Dear Abhishek > Thanks for the macros.Its exactly As I want. > Can you do only a small help further. > Sheet Name should also appeared the cell M16 of each sheet.(In template > marked in Green).If sheet name i

Re: $$Excel-Macros$$ Create Multiple sheet

2016-01-24 Thread Shrinivas Shevde
Dear Abhishek Thanks for the macros.Its exactly As I want. Can you do only a small help further. Sheet Name should also appeared the cell M16 of each sheet.(In template marked in Green).If sheet name is AAA then in M16 it should be AAA Thanks once again for great help Regards Shrinivas On Sat, J

$$Excel-Macros$$ database copy paste issue from one workbook to another workbook

2016-01-24 Thread Kat
Hi guys, I want to copy paste database from one Workbook A to Workbook B. When new row data is added in Workbook A, the excel vba code will compare whether the data is exist in Workbook B. If no, new row data needs to be copied and pasted automatically to last existing row in Workbook B. I've h

$$Excel-Macros$$ Merge multiple Workbook

2016-01-24 Thread Sandeep Chhajer
Hi Excel guru, I have found macros for merging multiple workbook (kept in a single folder) into a single worksheet. But my requirement is a step ahead...can that macro to be changed to copy only specified column from every wrokbook (Sheet1). Like it will search in all the workbooks (sheet1 row no