Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Formula and Cell Value

Posted on 2013-11-14
3
258 Views
Last Modified: 2013-11-14
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
Comment
Question by:leezac
  • 2
3 Comments
 
LVL 1

Accepted Solution

by:
EhntilZa earned 500 total points
ID: 39649210
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
 

Author Closing Comment

by:leezac
ID: 39649237
Yes - that will work...
0
 
LVL 1

Expert Comment

by:EhntilZa
ID: 39649290
Have a great day.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question