Excel workbook with two sheets [Solved/Closed]

Report
Posts
3
Registration date
Tuesday October 28, 2014
Status
Member
Last seen
November 4, 2014
-
Posts
3
Registration date
Tuesday October 28, 2014
Status
Member
Last seen
November 4, 2014
-
Hi,
i have an Excel workbook with two sheets and when i enter data in sheet #1 it automatically goes to sheet # 2.
How on earth can i stop this from happening?
Please help!
Thanks

2 replies

Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
454
Hi Ibraun,

It can either be a formula (check the destination cell) or a macro (check under each sheet in VBA [Alt + F11])

You can also try to create a new workbook and copy/paste the data from one to the other.

Best regards,
Trowa
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
3
Registration date
Tuesday October 28, 2014
Status
Member
Last seen
November 4, 2014

Hi Trowa,
Problem is solved.
Thanks for your time.
"Time is money"

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!