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
2658
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 28, 2020
440
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"