How to populate a sheet with specific data from other sheets?

R

R

Rafael2662021-07-14 09:17:42

Macros

Rafael266, 2021-07-14 09:17:42

How to populate a sheet with specific data from other sheets?

There is Sheet 1, Sheet 2, Sheet 3, Sheet CLEANING. Only 4 sheets.

Data is entered manually in sheets 1-3.
task: to fill in the "CLEANING sheet" automatically. the formula or macro searches the "comments" columns for the word "cleaning" and fills in the rows in the "CLEANING SHEET" by copying the data from the cells plus the sheet name.

Please teach me how to write such a macro.

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

A

Anton2015-03-19 01:21:47

What add-in can I write in C# for Microsoft Project (BKR help)? 1Reply

A

apodolsky2019-09-17 14:54:50

How to save matching rows by name from column N to a separate file? 1Reply

F

Fuzzy Boy @Fuzzy2015-07-11 00:29:25

Is there a way to write an Excel macro that will watch the clipboard? 2Reply

I

IVBAN2021-05-24 10:10:44

How to delete values in cells with the same value in excel? 1Reply

M

Maxim Timofeev2015-09-09 17:51:57

How to solve this problem with a macro? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question