Log In
Register
Home
New Member
May 17, 2024
Offline
Please for your help!
I have two worksheets, one is the source and the second one is the destination. In the source workbook I have a list of project names. The project names are listed in column A . Adjacent to column A, are in columns the months, where the employees will manually add the percentage of hours they worked for each project for that month.
I managed with power query to link the data in the destination file so when I add a new project in the source workbook automatically is added in the correct row of the column A in the destination workbook. However, when a new project is added in the destination workbook, creates only a cell and not the whole row. I do not want to link the whole table (this would have added a new row), I want the new row to be empty and ready to be filled by a user.
How can I automatically create a new row with filled the column A and empty the rest columns of the row when a new project is added in the source workbook?
Many thanks in advance!
Moderators
January 31, 2022
Offline
Not sure I understand what you mean by:
"I managed with power query to link the data in the destination file so when I add a new project in the source workbook automatically is added in the correct row of the column A in the destination workbook."
What exactly did you do in PQ? And, could you perhaps upload a file with som example data.
1 Guest(s)
