Macro to Retrieve, copy, paste and update on other worksheet


New Member
Apr 25, 2019
Hi all,

While I've performed simple Macro's in the past, the relative complexity of my current project has me a little stumped!

I have created dependent drop-downs that display varying options of which users then score. I am wanting to paste these answers into the next worksheet, with the format in Columns O to T made to measure. (This process will repeat many times for each user)

To make it future-proof I am needing two buttons:

Retrieve:Upon selecting options via the drop downs, a macro to retrieve scores (for the options) from the Dataset (
If applicable - most will be entering for the first time initially)

Update: Upon entering/updating score, a macro to copy and paste columns O to T (Variable rows) to next worksheet. This may replace existing data, or add to it. The order does not matter as PivotTable will update/filter this accordingly - however aligning the data would make it neater. E.g. Name 13 always updates over the top of/or inserts below existing entries, not at the bottom of the entire list

Is anyone able to assist me with similar examples or suggestions please?

Thank you for your time!

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...