I would need a formula which allows me to replicate the data I insert in the main sheet to each of the sheets identified by a specific name which I input initially. For example, I have a main employee sheet where I keep the records of all employees and then I have a separate sheet for each employee which will replicate the data entered in the general sheet. I need the formula to check whether the name condition is met and afterwards append the data entered in the general sheet to the individual employee sheet in the empty row after the last filled-in row. Thus, I will not be required to copy the row of each employee from the main sheet to the individual sheets. This needs to be done dynamically so I will not be required to enter the formula in each corresponding cell. I would suppose it’s a global document formula, if I’m using the right term. I expect the formula to automatically standby and detect when I input a name included in the condition, and afterwards generate the replication of the data in the right place, pertinent to the name I input.
I assume this would involve a combination of references and conditional formatting.
- Conditional formatting is used in the main employee sheet to determine which name is input and where to replicate it on the individual employee sheets.
- The reference of the main employee sheet is defined in each of the individual employee sheets.
Since I can’t upload an attachment, I am pasting the data from the spreadsheet here as an example.
Main employee sheet
Name Age Date of birth Address Pay date Hourly wage Pay
Sally Grilmers 35 11/05/78 1254 Hickory Dr. 12/31/2012 15.35 2410.54
Jacob Miltisworth 28 05/23/88 2657 Jensons Ave. 12/31/2012 14.29 2105.42
Martin Flemings 43 01/11/64 5342 Landers St. 12/31/2012 17.58 2856.41
Wendy Silmerpan 52 09/15/58 6684 Filtinger Rd. 12/31/2012 32.58 5187.36
Shawn Talsyrvith 26 03/14/91 2384 Miltonaire Ln. 12/31/2012 20.35 3157.31
Input Sally Grilmers for next pay period
Individual employee sheets
Sally Grilmers sheet
Name Age Date of birth Address Pay date Hourly wage Pay
Sally Grilmers 35 11/05/78 1254 Hickory Dr. 12/31/2012 15.35 2410.54
This is an empty row. When I type Sally Grilmers in an empty row in “Main employee sheet”, all data input in “Main employee sheet” automatically gets replicated to its respective column in this sheet.
Jacob Miltisworth sheet
Name Age Date of birth Address Pay date Hourly wage Pay
Jacob Miltisworth 28 05/23/88 2657 Jensons Ave. 12/31/2012 14.29 2105.42
This is an empty row. When I type Jacob Miltisworth in an empty row in “Main employee sheet”, all data input in “Main employee sheet” automatically gets replicated to its respective column in this sheet.
Martin Flemings sheet
Name Age Date of birth Address Pay date Hourly wage Pay
Martin Flemings 43 01/11/64 5342 Landers St. 12/31/2012 17.58 2856.41
This is an empty row. When I type Martin Flemings in an empty row in “Main employee sheet”, all data input in “Main employee sheet” automatically gets replicated to its respective column in this sheet.
I have read through all these posts but haven’t found anything relevant to my interest.
https://help.libreoffice.org/Calc/Addresses_and_References,_Absolute_and_Relative
https://help.libreoffice.org/Calc/Referencing_a_Cell_in_Another_Document
https://ask.libreoffice.org/en/question/39791/copy-conditional-formatting-from-cell-to-cell-in-other-sheet/
https://help.libreoffice.org/Calc/Applying_Conditional_Formatting
I greatly appreciate your help.