Display same values in 3 differnt sheets.

[rapsingekar]

Hello Everyone,

I am new to programming, I am sorry if my question is too simple.

I have a workbook with 37 sheets,it is basically for tax calculation.
- I will get a Start and end date and I will break them in to Calendar year -Fiscal year. Which again depends on the Country selected for Home and Host from other sheet.With all the bordering in run time.
-So I need this display on 3 differnt sheets on one single click
-I have written[copied the same macro] twice. I know excel vba executes sequentially.
-While every thing runs and works beautifully it takes way lot of time...to get executed.
-Is there a way out so that I can get the thing executed quickly....as far as I know I have followed the Global variable declaration etc which can reduce quite a bit of time.
Thank you for the help
Regards
Ram

[ragulduy]

Can you post the code you have so far?
Using
Application.screenupdating = false
and
application.screenupdating = true
before and after the main body of code is usually the first step.

[rapsingekar]

Here is part of my code ....I have done the application.screenupdating... I have the same piece of code with another country refering in another sheet which will display values on two other sheets
Thanks for the quick response.

Please Login or Register  to view this content.

Moderators note: code tags added for you - this time

[Naveed Raza]

Please use code tag while posting code on thread edit your thread and follow the below step
type like this below
[code]
here your code
[\code]

[FDibbins]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[ragulduy]

Other than your while loop there doesn't seem anything in that block that would slow it down considerably. You can try setting the stuff in the loop to an array and then assigning that to the worksheet range in one go. It's hard to say how much use that would be without all the other moacrosthat get called up.

Could you edit your post to include code tags and maybe post the workbook in question if possible (removing all sensitive data).

[rapsingekar]

I am really sorry for this ..I will come back with the question and the code correctly formatted as per the rules. I see how annoying it looks. Thanks a lot for your inputs .

[rapsingekar]

Hi Yudlugar,
Thanks a lot I will update the Workbook. Thank you and sorry if you had to put in extra effort to go through the code.