Input data at Parent Level

[Former Member]

Hi

I want to enter data at Parent level, my requirement is

Project1
  CE1
    CN1
    CN2 
  CE2
     CN3
     CN4
Project2
  CE4
     CN5
     CN6
  CE5
     CN7
     CN8

there are 6 columns, in first two columns user want to enter at CE1 level which is parent of CN1 and CN2, CN1 and CN2 should grey out

other two columns user need to enter at project level Project1 and Project2 which is parent of CE1 and CE2, here CE1 and CE2 are grey out.

remaining two columns user enter at Base level members which are CN1 and CN2.

I can enter at base members but how can I input at parent level CE1 and Project1, Created Dummy ID's for parent members.

In same Input schedule need to appear the values again what ever entered at project1 level.

please let me know.

Regards

Klien

[Former Member · Accepted solution]

Hi Klien,

If you have 3 types of columns in the same input form, it will be a problem in correlating the data. Let me give you an example.

In the first column, you enter data for CE1_INP. CN1 and CN2 are greyed out.

But in the subsequent column, the user is also entering some data in CN1 and CN2. This data will be rolled up to CE1. Then what is the purpose of entering data for CE1_INP in the same input form.

[Former Member · Accepted solution]

Hi

Thank you, sorry I'm out of station these days so couldn't reply to your answer, problem resolved, at CE level creating dummy inputs, and user won't enter at CN level.

Regards

Klien

[Former Member · Accepted solution]

Hi

I have one more scenario in input schedule which need to grey out at intersection of row and column i.e in Row I took Project dimension and in column percentage

                              percentage

AE1                        grey out

AE2                        grey out

AE_GST                User need to enter data

PE1                         grey out

PE2                         grey out

PE_GST               User need to enter data

how can I grey out intersection of the cell which is "GST" project, dynamically members will be expanded, I try in format cell, by hardcoding as

project.id = AE_GST  row     format    LOCK     data

but worked only for "AE_GST" remaining GST not worked, how can I do this, should I need to write any macro, if so can you please let me know how to write it as I'm new to Macro

Regards

Klien