simple Excel VBA Macro needed

Lengkap Disiarkan 6 tahun lepas Dibayar semasa penghantaran
Lengkap Dibayar semasa penghantaran

Values from and excel table (in a sheet called BUDGET) need to be extracted and put into a smaller table on a new sheet (called METRICS). The workbook might have many other sheets in it so the program must specifically work only on the sheet called BUDGET and the new sheet METRICS without altering any other sheet

New sheet METRICS will be created by the macro

The new table will have formulas referring to the cells from the original table (not just copying the values but inserting a reference).

See attached spreadsheet for an example.

The original table (in BUDGET) has 3 parts, namely:

MATERIALS-(M)

LABOUR-(L)

PRELIMINARIES-(P)

Within each of these 3 parts, there will be one or many scopes. scopes name always starts with the suffix SCOPE. For example: SCOPE 1_, SCOPE 2_, etc The example attached shows only 2 scopes but there could be more. The macro is to find how many scopes there are and possibly loop as many times as required

The macro will then create the new sheet (METRIX) and will populate with the reference to the values in BUDGET. See attached spreadsheet

FORMATING:

For clarity I have highlighted the cells that are referring to each other with many different colours but it will be ideal if a single colour per scope could be used. For example: the items on SCOPE 1 in light blue (on both sheets: BUDGET and METRICS), the items on SCOPE 2 in light yellow, etc

Please suggest the best methodology to achieve this, is a nested loop required? Or would simple array formulas do the trick?

Pemprosesan Data Excel Visual Basic

ID Projek: #15478756

Tentang projek

10 cadangan Projek jarak jauh Aktif 6 tahun lepas

Dianugerahkan kepada:

vano101

I have opened attached file and I have many ideas how to solve it. I call such projects peace of cake. It's possible to complete in couple of hours, or maybe even in 1 hr. Maybe even sooner, but I rarely estimate with Lagi

$18 AUD dalam sehari
(337 Ulasan)
6.4

10 pekerja bebas membida secara purata $33 untuk pekerjaan ini

cgullapalli

HI, I am good at Excel and vba. I prefer vba for this case. I can link the formulas. I can get all the scopes and complete all the columns in metrics. Program will not touch other sheets. -Chandra Relevant Skills an Lagi

$34 AUD dalam 0 hari
(777 Ulasan)
7.8
whitehorsetechn

Greeting, I have understood your excel Macro task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 years of experience in Data Process Lagi

$100 AUD dalam 2 hari
(13 Ulasan)
5.3
beltran0404

Hello, I am Luis from Venezuela and it will be my pleasure to assist you in this matter. I can help you to solve your excel requirement Habilidades y experiencia relevante excel expert, visual basic for apps Htos pro Lagi

$25 AUD dalam sehari
(93 Ulasan)
5.1
nurnga1218

Hi There... I've read your brief and downloaded your attachment. I think I can do but I have to change the budget format (maybe add some hidden column). So it easier to be read by the macro loop. Relevant Skills and Lagi

$35 AUD dalam 3 hari
(40 Ulasan)
4.5
rIbrarahmed

hi, I am very good in excel and this is very simple for me you can trust me for this project. thanks

$25 AUD dalam sehari
(15 Ulasan)
3.8
tom19468

I will modify my existing MS Excel VBA scripts to create a new sheet METRICS for each 'SCOPE' to populate with the reference to the values in BUDGET. Relevant Skills and Experience I have been coding in basic & MS Off Lagi

$25 AUD dalam sehari
(1 Ulasan)
3.4
jemeeja

Hi I am interested to project. I saw your project and read its details. I am fully expert this job. I want to do its because i am sure i can do its. thanks. Relevant Skills and Experience Data Processing, Excel, Visua Lagi

$15 AUD dalam sehari
(0 Ulasan)
0.0