Example:
I have several boxes, each with a section for names. This excel document is to be used multiple times, so I would like to make it to where in a cell, I type a name "Austin" and it fills the other sections for names on the other boxes.
Example:
I have several boxes, each with a section for names. This excel document is to be used multiple times, so I would like to make it to where in a cell, I type a name "Austin" and it fills the other sections for names on the other boxes.
Hi Arch,
Welcome to the Forum!
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thank you!
TestPLC is the before version
Sample, is part of the wanted results (I didn't fill out other name sections.)
Never mind! I figured it out lol I used the MID Function
Glad you got it - maybe I can help another time
Hello,
I opened the "Sample" file attached in the forum. There is one thing I did not understand. I tried to define value of K6 by refering to A6, it was supposed to show "Mills" but it shows "=A6". Could you please explain what is wrong with that?
Thanks
Untitled.png
Hi Hunbat,
In the Advanced Options - Display Options for this Worksheet - you can choose:Show formulas in cells instead of their calculated results - so, if thats checked, you need to uncheck it
I have checked and it was already unchecked.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks