• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

data linking from one worksheet i.e Column Q to another worksheet i

Status
Not open for further replies.
P

paradise

Member
Hi,
I have added only one worksheet PG and used a formula in A2, currently it is displaying the result zero this is so becoz the data in column Q there is no data.

As per the vba code, whenever the data is mentioned in column K to P accordingly in column Q it is automatically unhidden.

So, when I use the formula in existing or another worksheet/s relating with column Q data,Column Q data should function irrespective of hidden.

1st Column Q should be unhidden when there is data from K to P( which is already done thru VBA code)

2nd In other worksheets Column Q should work irrespective of data hidden/unhidden.

Hope this is suffice info.
If further info required kindly let me know.
 

Attachments

No,2nd part is still yet pending.In above enclosed workbook I have another worksheet name PG.And a formula mentioned in A2.I want this to function as it is not displaying result.Currently it is showing Zero due to blank of data in column Q .The formula i.e VBA code should not be altered.

I hope this also would be solved.
Thanx in advance.
 
paradise said:
No,2nd part is still yet pending.In above enclosed workbook I have another worksheet name PG.And a formula mentioned in A2.I want this to function as it is not displaying result.Currently it is showing Zero due to blank of data in column Q .The formula i.e VBA code should not be altered.

I hope this also would be solved.
Thanx in advance.
Click to expand...

Why not ask the same there again so that one can help.

For the now, i had locked the post.
 
Status
Not open for further replies.
Back
Top