Devam Ediyor

478977 Macro VBA Expert Needed

This is a simple task for anyone who is a expert ad Excel, Macros and Visual Basic for Applications

Brief: The spreadsheet will include 2 tabs, "Master" with all the data in it and "Filters" with all the column headers (which can be changed therefore those header names have to be variable).

The master tab will have an "x" amount of columns/rows. The macro will copy the whole master file into a new tab and rename the tab. However, the macro will copy the whole data after certain filters are applied so the new tab will only show the filtered data.

The new tab name should be renamed as the names in column "A" of the "Filters" tab, starting at A2 and going down to the last row of the "tab names", therefore after renaming the new tab with the name from the "tab names" column it will take all the corresponding filters and filter the master tab for it and dump that data into the new tab.

However, the most important part is that once I decide to change the filters I want to be able to type in the new filter criteria under each header in the "Filters" tab and run the macro so each tab will include the new filtered data as well as named properly. The macro should work for any spreadsheet regardless of the new data/column headers so set the headers to be variables in the master file on A1:AB1

Examples attached.

Needed by Monday 5pm New York Time

Beceriler: Her şey Kabul, Excel, Visual Basic

Daha fazlasını görün: who can expert in excel, visual basic x, visual basic for applications, vba work, vba with, starting with visual basic, simple spreadsheet examples, macros expert, file excel expert, expert with excel, excel 0 to expert, be expert in excel, be an expert in excel, ad copy examples, vba time, vba for, vba and macros, Expert in Excel, VBA Macros, vba expert, vba excel macro, simple macro, renaming, renaming i, macro

İşveren Hakkında:
( 116 değerlendirme ) Asheville, United States

Proje NO: #2224886

Seçilen:

webstarmonali

Hi , Please see PMB. Thanks!

0 gün içinde 30$ USD
(21 Değerlendirme)
3.6