SoldierWalb
New Member
- Joined
- Feb 11, 2022
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
I have some information that is sent to me in a PDF document and I am needing to try and manipulate the data so that it works better for our operation team. When the data is first pasted into the excel document it places all the data into the first Column. I have written a Macro that when the person clicks a button it breaks the first column into multiple columns based on using a space as the delimiter. I currently have two issues with this Macro. First is the "There's already data here" message that pops up. There is no data getting over written so not sure why this is popping up. I would like to eliminate this pop up. The next issue I run into is sometimes the width contains inches. When this happens it detects the space between the foot measurement and the inch measurement and pushes everything to the next column. So in the example I have below you can see that on 36 & 37 the width show 15' and the Height shows 6". This is incorrect. The Width should be 15' 6" but I am not sure how to make this work. I am able to manually do this operation with using some formulas but wasn't sure if there was a way to correct this that someone may know about.