simple Excel VBA Macro needed
$10-30 AUD
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?
ID Projek: #15478756
Tentang projek
10 pekerja bebas membida secara purata $33 untuk pekerjaan ini
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
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
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
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
hi, I am very good in excel and this is very simple for me you can trust me for this project. thanks