Hi,
Could anyone help me find/create a vba that does the followings:
- I have two files (source and destination)
- The source file looks like this :
- I would like to copy the content from column A of the source file and paste it in New Notes of the destination file
- The destination worksheets and the cells are indicated in the columns B and C in the source file
- The macro saved in the source file should open the destination file (full path provided in cell A2) and loop through all rows starting from row 5 and down to the last row.
- Ideally the size of the new notes should be adapted based on the length of the content of each cell provided in column A.
Many thanks,
Cristian.
Could anyone help me find/create a vba that does the followings:
- I have two files (source and destination)
- The source file looks like this :
source of new notes.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | file path of the file where the New notes are copied from the current file | ||||
2 | C:/mydocuments/destination.xlsx | ||||
3 | |||||
4 | Content to be copied into New Notes | Worksheet name where the content is copied | Cell reference where the content is copied | ||
5 | aaaaaa | sheet1 | C2 | ||
6 | bbbbbb | sheet2 | D24 | ||
7 | cccccccc | sheet2 | AA99 | ||
8 | ddddddd | sheet3 | B121 | ||
Sheet1 |
- I would like to copy the content from column A of the source file and paste it in New Notes of the destination file
- The destination worksheets and the cells are indicated in the columns B and C in the source file
- The macro saved in the source file should open the destination file (full path provided in cell A2) and loop through all rows starting from row 5 and down to the last row.
- Ideally the size of the new notes should be adapted based on the length of the content of each cell provided in column A.
Many thanks,
Cristian.