• 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.

Publish only when value generates

T

Techtrend

Member
Hello Team

We run an excel live sheet with formulas,As and when the condition meets the value gets generated in Sheet 1 F and G Col,as and when it is generated we need to publish the details in Sheet 2,

The sample sheet is attached for reference
 

Attachments

Hi,

See the file. Note any time any row with data in col F or G appear on Sheet 1 the same will come on Sheet2. You can change the range in formula as per your data.

Regards,
 

Attachments

Mr.Misra

I am not able to populate the same formula in my sheet,Getting Error,

Can you please generate the references from HL-BO to Targets Sheet as and when the condition meets ,

As it is a live sheet, As and when In HL-BO if H and I values gets generated the values or the entire col gets published in the Targets sheet.

The sample is attached for your reference.


Narendra
 

Attachments

Mr.MIsra

I am unable to copy paste the formula,
Can you plz tell me how can i replicate the same to diff colums,

Need to publish HL- BO To HL-Targets Sheet

IT HAS TO ONLY PUBLISH IF ANY ONE CONDITION MEETS

Regards
Narendra
 

Attachments

Hi Narendra,

The formula are array formula: you are copying and pasting the formula than you have to press F2 and press Ctrl+Shift+Enter and not just enter to confirm the formula in A2 and than copy down and across.

Regards,
 
Mr.Misra

I am sorry getting error,
Unable to replicate the code in other column,

Can you please copy paste the same logic to all the column.

The sheet is attached

Need to publish HL- BO To HL-Targets Sheet

IT HAS TO ONLY PUBLISH IF ANY ONE CONDITION MEETS

Regards
Narendra
 

Attachments

Mr.Misra

The sheet has become very slow as it is updating live,
Is it bcaz you have applied the formula to 10000 ROWS,

If yes can you please do it only for 200 Rows as the data is not there more then that .

Thanks
Narendra
 
You must log in or register to reply here.
Back
Top