Alright folks of this wonderful forum.
I need your helpful assitance.
My boss wants an easier way to bounce two employee charge numbers from two different excel workbooks to make sure both timekeeping systems are reporting properly.
I have about 2-3 days clocked in trying to gather as much information about this but i keep hitting roadblocks. I hate wasting mine and his time. (My priority is Database not VBA but boss says do it, you gotta do it LOL)
Refrence=
Charge Number (Cell = G2:G99999): 300000039143
Issue 1: I was able create a code that grabs a range and formats it to Text. Problem is that inorder for it to change to the format i still have to click inside every single cell. annndd it changes to 30E+11 blah blah. I have changed my code to every possible format but i still have to click inside the cell for changes to even happen.
Issue 2: Since my time was focused on the formatting and converting, I barely had time to look at how to trim the first 5 characters, (On the other workbook itll be trim first 5 and last 1)
Issue 3: Lastly I will need to bounce both workbooks together to ensure employee A charged N Hours to Charge Code of XXXXXXX
If you need any more information let me know. I would be happy to provide an example spreadsheet if its possible here.
Bookmarks