I have multiple rows of data. I went through the first row and reference all the cells to a particular workbook. I have copied the first row into the second but need to change all the references to another workbook. How would i go about doing this without manually going through them all?
Ctrl + h perhaps?
Or if you have lots of workbooks with names containing dates or some sort of counting number you could build up the name with INDIRECT.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks