Copy Multiple Columns and Paste to Different Sheets based on Header

[ccoates]

Hi All!

I'm creating a dataset type of spreadsheet where I monitor data of three different types for example distance , velocity and acceleration. Each has its own sheet and results are logged for different years 2015,16,17,18 etc.

Id like to program an input data tab where i can paste the values into three different columns then select a year, 2019 and whether its a draft of final report and then hit a button that will paste the data to its respective sheet.

Apologies if my description is poor im new to this and my work is somewhat confidential so using an analogy!

 

[ccoates]

VBA code to select a Paste location on a different sheet

I'm looking for a code that will allow me to select where i want to paste data in a sheet.
[TABLE="width: 500"]
<tbody>[TR]
[TD]2016-17[/TD]
[TD]2016-17[/TD]
[TD]2017-18[/TD]
[TD]2017-2018[/TD]
[TD]2018-19[/TD]
[TD]2018-19[/TD]
[/TR]
[TR]
[TD]draft[/TD]
[TD]final[/TD]
[TD]draft[/TD]
[TD]final[/TD]
[TD]draft[/TD]
[TD]final[/TD]
[/TR]
</tbody>[/TABLE]

my table headers look as shown above. I would like the user to be able to select a year then whether its draft or final data before clicking a button that will paste in the correct column.

Any help is massively appreciated

 

[Joe4]

Re: VBA code to select a Paste location on a different sheet

Welcome to the Board!

Since this seems to be a re-posintg/clarification/continuation of your original question, I am combining your two threads together.

Note that all clarifications, follow-ups, and bumps should be posted back to the original thread (please do not post the same question multiple times). Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.