Drag Path Down Changing Part of the Path (VBA?) UPDATED

[Code Ghost]

Good morning community,

I am retrieving seven values from a saved Invoice to a different Workbook.
I have seven rows, from an invoice, to retrieve the values to columns Q to W in a different workbook.

My paths start on row three as follows (not the complete path but the important elements are at the end):

Column .... Q .... R .... S .... T .... U .... V .... W
Row 3 (path) .. ='C:\Users\[1000.xlsx]Invoice'!$AI$38 .... [1000.xlsx]Invoice'!$AI$39 .... $AI$40 .... $AI$41 .... $A$I42 .... $AI$42 .... $AI$44
Row 4 ...... ='C:\Users\[1001.xlsx]Invoice'!$AI$38 .... [1001.xlsx]Invoice'!$AI$39 .... $AI$40 .... $AI$41 .... $A$I42 .... $AI$42 .... $AI$44
Row 5 ...... ='C:\Users\[1002.xlsx]Invoice'!$AI$38 .... [1002.xlsx]Invoice'!$AI$39 .... $AI$40 .... $AI$41 .... $A$I42 .... $AI$42 .... $AI$44

So, I need to drag the path down to change the invoice number each row to the next invoice number.

But dragging down the path in Excel doesn't change anything.
If I had to modify the path to 100 rows I would do it manually, but I need to do this for 1000 or more rows.
I think VBA would help, but I can't figure out how.
If it is of any use, the invoice number is also stored in column A.

I truly appreciate in anticipation all the help and advice given.

 

[Code Ghost]

The path in column V should be: $AI$43

 

[Joe4]

Duplicate to: Drag Path Down Changing Part of the Path (VBA?)

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.