Copying Data from One Sheet to Another Automatically?

asked 2021-04-11 17:50:23 +0200

CompSciSarah gravatar image

I have a table which auto-calculates functions on one sheet and another sheet which has raw information.

Is is possible to press a button or run a command that maps the raw data (2 column, not side by side and I can't make them side by side for simple copy-paste) to the data/analysis column of the other sheet?

The Problem:

Data Sheet (want name + id): NAME (THINGS) ID

Function Sheet: NAME ID ANALYSIS

Right click -> ???? -> Function Sheet auto fills with the appropriate columns (but only the rows that I selected)

Is this possible?

edit retag flag offensive close merge delete


Please upload your sample file here.

Zizi64 gravatar imageZizi64 ( 2021-04-12 06:29:42 +0200 )edit