I need a button that will grab data from another sheet "Check Creator", and when pressed, add that data as a new row on the existing sheet. Date ='Check Creator'!F1 Check #= keep blank/empty To ='Check Creator'!C2 Amount ='Check Creator'!F2 Description ='Check Creator'!C8 Deposited = Set to "No" P = keep blank/empty When it is grabbing from these fields however, it needs to be converted to text. For instance, I don't want the final output to reference the other sheet as we will be changing the Check Creator sheet as needed. Let me know if this is possible.
Solved by O. J. in 28 mins