This is my first post and I'm new to scripts. Upon searching through multiple questions similar to mine, I couldn't find exactly what I was looking for.

I want to create a macro that pulls specific data from my Invoice sheet and add it to the next available line on the Data sheet. After the data has been added to the Data sheet, I want it to reset the Invoice sheet and clear those fields while also adding 1 to the job # (currently at 100, moves to 101 after macro has completed the move, then 102 and so on).

I created a simplified dummy sheet for reference:


I made a helper line on row 18 of the information to be transferred, but I don't know if that's necessary for the process or not.

  • 1
    Welcome. While including a link to a spreadsheet could be helpful, questions should be self-contained. In other words, please add enough details to the question itself including a simplified version of you code (minimal, complete and verifiable example) – Rubén Jan 26 '19 at 7:43
  • I actually figured it out and I'm set to go! Thank you for letting me know though! – Sabrina Jan 26 '19 at 17:03
  • Great. Please consider to share your solution. Ref. webapps.stackexchange.com/help/self-answer – Rubén Jan 26 '19 at 20:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.