What does the "pro" mean in the descriptor IT pro? I would remove that tag as to avoid confusion that an IT professional related to Excel would know anything about VBA.
Thanks for your understanding.
Excel VBA script runs to copy/paste cells from WB2 to WB1 when # format = "1234E-11" is entered in cell(xx) of WB1 - HELP!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 30%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SamiAm
1
Reputation point
I am attempting to populate my parts list upon entry of model number in my Excel documents. WB1 is primary and generates my order, WB2 is the repository of parts. When WB1, cell (C7) has a model number equal to a pre-described format (####E-##) entered, it sources WB2 parts list and copies those parts and descriptors to the predetermined WB1 location. I can do the copy with no problem but can't condition using the format I have to use (####E-##) - I've tried if-then and have now gone down the path to utter confusion. any help is appreciated. ![69814-image.png][1] [1]: /api/attachments/69814-image.png?platform=QnA
{count} votes
-
Emily Hua-MSFT 27,656 Reputation points2021-02-19T07:11:04.637+00:00 @SamiAm
As tag "office-excel-itpro" focus more on general issues of Excel client, but your issue is more related to to VBA, I would remove this tag.
Thanks for your understanding.
Sign in to comment
1 answer
Sort by: Most helpful
-
SamiAm 1 Reputation point
2021-02-19T13:06:17.547+00:00 -
SamiAm 1 Reputation point
2021-02-19T13:09:15.52+00:00 That is of course based on your comment to remove this from a thread labeled "office-excel-itpro".... very confusing.
Then where would you post such a request?
Sign in to comment -