BaldyMcFatFat
Technical User
I am having an issue trying to come up with a way to pull values from two seperate cells in a workbook and convere them into one cell on a seperate workbook.
Easiest way to explain it: I run a report for work that gives me hard values and is set-up perfectly to use an hLookUp. It basically gives me a table with multiple lines of data and I need to move that data to a seperate workbook but have it in one cell as a phrase instead of just numbers. I basically need it to show up as the following phrase: "X out of Y were correct."
As you can probably imagine, X equals the first line of data under the LookUp_Value and Y equals the second line under the LookUp_Value.
I am new to the VBA world and pretty much have been thrown in with training or people to ask questions. I have never done programming in the past and am trying to learn as I go along. I have searched every resource I know of and haven't found anything on this particular question.
If anyone has any help on this, that would be greatly appreciated. Right now, I would even take helpful sarcasm.
Easiest way to explain it: I run a report for work that gives me hard values and is set-up perfectly to use an hLookUp. It basically gives me a table with multiple lines of data and I need to move that data to a seperate workbook but have it in one cell as a phrase instead of just numbers. I basically need it to show up as the following phrase: "X out of Y were correct."
As you can probably imagine, X equals the first line of data under the LookUp_Value and Y equals the second line under the LookUp_Value.
I am new to the VBA world and pretty much have been thrown in with training or people to ask questions. I have never done programming in the past and am trying to learn as I go along. I have searched every resource I know of and haven't found anything on this particular question.
If anyone has any help on this, that would be greatly appreciated. Right now, I would even take helpful sarcasm.