Automation and processing of Google Sheets (Cash Flow)
I am looking for a PROFESSIONAL contractor for ongoing collaboration on Google Sheets.
Currently, I have the following task:
Table 2 needs to pull data from Table 1 (counterparty, date, and payment amount - from the rows).
Table 2 should place the values of payment amounts taken from Table 1 into specific coordinates of Table 2, which depend on the counterparty (vertical list) and the date (horizontal list).
Meanwhile, Table 1 is constantly filtered through filtering modes.
Additionally:
1) As a second step, it is also necessary to set up cell formatting so that cells are highlighted under certain conditions, which we will specify in the technical specification or discuss.
2) Some data will be transferred from Table 2 to Table 1 and vice versa: some data will be taken from Table 2 to Table 1.
3) It is also necessary to transfer data from the main Table 1 to other tables 3, 4, 5, 6 so that employees with a certain level of access can only view what they are allowed to.
-
1 day111 USD
3152 34 0 1 day111 USD
Hello.
I didn't quite understand the vertical and horizontal list in table 2.
You also wrote that data about the contractor should be taken from table 1, and then that payment data should simply be entered in table 2 depending on the contractor.
Can you describe this differently?
Everything else is clear.
-
2 days22 USD
421 13 0 2 days22 USD
Hello!
I work with Excel and Google Sheets.
I am ready to help using formulas or macros (scripts).
Connection with Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.
Hello.
I work with Excel and Google Sheets.
I am ready to help using formulas or macros (scripts).
… Connection with Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.
Kyiv