Worksheet Change Event

[jquintana83]

Hello,

I am using a simple worksheet change event to have what ever happens on sheet1 to be mirrored on to sheet2. I'm using this method with application.calculation set to manual.

Please Login or Register  to view this content.

I worry that it will become too slow after a while. What would be the best way to have one sheet mirror another without using up too much resources that would slow it down.

Any help is greatly appreciated.
Thank you

[humdingaling]

limit the range to certain amount of rows with

Please Login or Register  to view this content.

to determine last row

if deletions occur...add extra rows to last row?


do you really require it to run every worksheet change?
can you not just run it when workbook opens or closes?

[lancer102rus]

Try this

Please Login or Register  to view this content.

[jquintana83]

@humdingaling

Thank you for your response...well perhaps I could do Open/Close but let me give you the scenario and you can give me your input.

I have Userform in which the user inputs data to specified textboxes. There are 5 text boxes that would take the value and put it in 5 different sheets on the same row and column as in sheet1. Would the better approach be to just take the values, put them into an array and have them put across the 5 different sheets?

[humdingaling]

does the userform opens everytime you open the workbook or do you trigger the userform?

so 5 boxes = 5 rows of data on 5 different sheets?

how would userform know when to stop/start?
how about putting a command button on the user form to trigger event?

if it is direct from textbox to 5 sheets
you would only need to create a loop to copy into specified range on every sheet
if you have a sample spreadsheet i can help you code it