Dynamically copy and paste sheet cells into a specific sheet

MrFire · Jul 31st 2021

Hi guys

i need help on this problem

I have sheets with all types of files but column titles are the same.

I want these lines to be listed in another sheet and change automatically each time the file is added

**royUK** · Jul 31st 2021

Attach an example file.

MrFire · Aug 2nd 2021

Quote from royUK

Attach an example file.

this is Example file

I want these lines to be listed in Search Sheet and change automatically each time the file is added

**royUK** · Aug 2nd 2021

To handle data efficiently in Excel there are certain rules that need to be followed. All data should be on one sheet, if you need to view data by category you can use PivotTables, AutoFilter or AdvancedFilter. If you don't follow these rules then you create problems for yourself.

Read this

Working with data in Excel

Dynamically copy and paste sheet cells into a specific sheet

Participate now!

Share

Tags