Duplicate record when saving data from a form in vba/useform

Asked

Viewed 265 times

1

Good afternoon friends,

How do I duplicate a record in a spreadsheet with data saved from the useform. Being more specific, I will use an example of a health plan where I have a form that registers holder and dependents and need to save each dependent in a different row with the holder in the next (or previous) column like the image.inserir a descrição da imagem aqui

  • What would duplicate? Would copy and paste into another spreadsheet?

  • Buddy, I suggest you don’t duplicate this data... but simply put it on different tables with an id number or something. But if you want to duplicate, you can take the same code you do to save the holder’s row and create a function so that when entering the dependent pick insert in the holder column the desired name. What code you are using today to write this data to the spreadsheet?

  • Duplicate would repeat in the bottom cell the name of the same holder while the dependent is bound to it.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.