I have a very perplexing dilemma which I am unsure how to resolve. I have copied the issue into Google Sheets here: https://docs.google.com/spreadsheets/d/1OKaGqqxMJS7OCvixQvpmBqelyh24DlV9nSa1QsT4yCk/edit?usp=sharing
So columns I,J, and K all have information that needs to be entered into the table (columns A-F).
Columns D,E, and F have to be manually entered no matter what however information will consistently copy and pasted from another source into the three columns I,J,K. I need to pull out the Date and put it into Column B, The remaining content of a cell in column C, and the hall (located at the top of the column) in column A.
As you can see in the page above, the "Before" sheet is when the data is pasted into the I,J,K columns.
I would like this data to automatically populate the appropriate columns (A-C) upon the paste ("After" sheet)
This information will be updated many times over the year so at any paste, the table should be updated.
Ideally it is ordered by date.
Aucun commentaire:
Enregistrer un commentaire