Modification of macro created by using Record Macro 1 of 7

[VKS]

Dear Experts,
I created 7 macros using record macro(They all look dirty) and then created 8th macro to run all 7 one by one. My problem are:
1. I think all those 7 Macros can perform better if written correctly iso using record macro
2. When I created these macros real time data was available till OCT and now NOV data is also available but macros are not picking up NOV numbers.
I intend to seek experts help in resolving both the points above. Please advise if I should go ONE MACRO one post or one by one in separate posts.
Below is the first macro for reference.
Best Regards/VKS

Please Login or Register  to view this content.

[mike7952]

How about posting your workbook, and tell us what your trying to do.

[VKS]

Hello Mike, How I wish I could do that but its not possible for me to post the data file and creating a dummy file would take ages ( and i am bound to miss my deadlines in that case)

[mike7952]

Ok it will be hard for me to give any advice without a file or a dummy file. Im unable to follow whats going on with all the Selection.End(xlDown).Select

[VKS]

Thanks Mike for taking time out and looking at the post. You must have noticed that macros are for handling sensitive information called “Budget”. I am sure not very many people will look into it seeing 1 of 7.
Best Regards/VKS

[mike7952]

Well if you get time to create a mock up example I'll be happy to look at it.

[VKS]

Hello Mike, Thanks for your gesture, Do you think its ok if i create Dummy file showing 8 columns instead of 30 or 40 and 8 rows instead of 80 or 150.
Best Regards/VKS

[mike7952]

You can do that and it might be enough for me to suggest something. Does your current macros require all the columns?