Trouble recognizing data in excel sheet
Closed
Umair
-
May 16, 2011 at 11:18 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 24, 2011 at 10:08 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 24, 2011 at 10:08 AM
Related:
- Trouble recognizing data in excel sheet
- Mark sheet in excel - Guide
- How to open excel sheet in notepad++ - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Sheet right to left in google sheet - Guide
- How to screenshot excel sheet - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
May 17, 2011 at 10:05 AM
May 17, 2011 at 10:05 AM
Hi Umair,
Thanks for the credits, but I guess it wasn't very helpfull or else I wouldn't be reading this post.
How does your sheet look like?
Can you maybe post a view lines of your workbook or use a site like www.speedyshare.com to upload your entire file(s)?
Is it really necessary to have two workbooks? or is that your first step in solving your query and therefor not necessary when another solution is found.
Best regards,
Trowa
Thanks for the credits, but I guess it wasn't very helpfull or else I wouldn't be reading this post.
How does your sheet look like?
Can you maybe post a view lines of your workbook or use a site like www.speedyshare.com to upload your entire file(s)?
Is it really necessary to have two workbooks? or is that your first step in solving your query and therefor not necessary when another solution is found.
Best regards,
Trowa
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 24, 2011 at 10:08 AM
May 24, 2011 at 10:08 AM
The issue that i see with your approach is that, since the other excel only contains formula that are linked to original sheet. So if you make the change in the original cell, the link will make the change flow thru. Think it like this
if i write
A= 7 + B
as soon as i change value of B, the value of A is changed too. From what I am getting from your question is that you want B to change but A to remain static. I think there is a way you can supress the auto update of links but you have not mentioned what version of excel you are using.
If all you want is to have the other workbook contain the last updated value, why not just copy the content to the other workbook when you think it is time to copy.
if i write
A= 7 + B
as soon as i change value of B, the value of A is changed too. From what I am getting from your question is that you want B to change but A to remain static. I think there is a way you can supress the auto update of links but you have not mentioned what version of excel you are using.
If all you want is to have the other workbook contain the last updated value, why not just copy the content to the other workbook when you think it is time to copy.
