Question Inputting Repetitive Data Into a Table

[RonW7341]

I have a need to input repetitive data directly into a table. For example, Ctrl-C gives me the abilty to copy the data and then Ctrl-V wherever needed. I have a need to do similarilly on other data. Would a macro work for this or is there a better way?

Thanks

 

[Alansidman]

Will you be repeating the same fields consistently? Always the same number of fields being repeated? Or will the number of fields vary and will the particular fields vary?

 

[RonW7341]

Alan, thanks for responding. For example, one file might be a person's initials, another file might be today's date, another filed might be the publisher of a book etc. Instead of having to type out the same data time after time where appropriate, I'd like to be able to assign a sequence like Ctrl+1 to a publisher's name like "Simmons Publishing Co.". and have it insert that whenever I press Ctrl+1. Additionally, when I press Ctrl+2 it would insert today's date, etc.

I hope this makes sense. I know years ago back in the DOS days, a friend of mine had such a ability in a program he was using. I presume something similar could be done in a Macro today, but I just don't know how to go about it.

Thanks for your help.