• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 266
  • Last Modified:

Formula and Cell Value

Is there a way to have a path name and insert Cell values in the path name?

P:\TEST\Sheet1!J3\Sheet1!K4\Support
0
leezac
Asked:
leezac
  • 2
1 Solution
 
EhntilZaCommented:
Is this what you are talking about?

p:\test\      Sheet1!J3      \      Sheet1!K4      \      Support      p:\test\SubDir1\Variable 1\Support
p:\test\      SubDir1      \      Variable 1      \      Support      p:\test\SubDir1\Variable 1\Support

the final path would look like this.
=A2&B2&C2&D2&E2&F2

you would then want to copy and paste values only in to a final row to build a batch file from it.
directory-creation.xlsx
0
 
leezacAuthor Commented:
Yes - that will work...
0
 
EhntilZaCommented:
Have a great day.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now