Sedang Disiapkan

VB For Excel (Mac) - Sort & Extract Data Based On Scores

In One Excel workbook I have

- 1 x Table with 138 Fixed Rows

- 1 x Table with 123 Fixed Rows

- 1 x Table with 149 Fixed Rows

- 1 x Table with 114 Fixed Rows

- 1 x Table with 32 Fixed Rows

- 1 x Table with 81 Fixed Rows

(1) Each table gets data from an external source - The row labels don't change

(2) Each table has a variable number of items selected by a customer

(3) Those items that are selected by the customer need to be extracted and placed into another sheet & table

(4) The extracted items will form an individual report

(5) I do not want to use a pivot table

Notes: The data in the above 6 tables is imported from an external survey with a multiple selection where a customer has selected specific items if true for them. For example, the table with 138 rows asks 138 questions on a topic where the customer may only need to select 5 items that are true for them. The external survey exports the entire 138 rows and an individual score (1,2,3,4,5 or 6) for only those items selected. Also note that each customer completing the survey will select different items, different number of items and a different score ... the 138 questions are always the same. Each customer's completed online survey needs to have a standard report based on their data only.

Notes: I need to extract from the tables, only those items that have a score. This has to be done automatically as the ongoing reporting will be handed over to a person with no skills. As well I am creating a standard looking report that will be used with each client. the extracted data will form a part of a report.

Notes: I dont want to use a pivot table as i don't want to refresh the data every time the customer changes ...

Two Files

#1 Review Rows 274 - 551 [SortedData] tab under the attached file [url removed, login to view], and

#2 [url removed, login to view] this is where the data comes from once exported from the online survey

Please note re file #2 ... currently it only has the response from 1 customer ... normally there could be 500 responses as time goes on - the individual customer's details are extracted using their email address (see file #1 [setupItems] tab)

Kemahiran: Excel, Visual Basic

Lihat lebih lanjut: visual basic 6.0 online, visual basic 5 online, vb note, online visual basic 6, online labels, excel sheet for customer details, extract mac, vb in excel, use excel online, pivot online, customer data in excel, a&t labels, xlsx, visual basic form excel, vb excel, survey part 3, sort excel, report from excel, pivot tables, pivot table excel, mac a, extract tables, Exports, Excel report, excel PIVOT

Tentang Majikan:
( 11 ulasan ) Hendra, Australia

ID Projek: #1557177

Dianugerahkan kepada:

bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

$150 AUD dalam 3 hari
(72 Ulasan)
6.5

12 freelancers are bidding on average $137 for this job

koolsidz

Excel Whiz here. Please see PMB

$110 AUD dalam sehari
(130 Ulasan)
6.2
Krusche

Hello. We are experts in Excel based projects. Please check our reviews and examples in your inbox.

$150 AUD dalam 2 hari
(30 Ulasan)
5.7
vbexcel

An Excel/VBA developer with over ten years of experience.

$119 AUD dalam 3 hari
(29 Ulasan)
5.5
naveenvarthaan

Hi, I looked into your two files. With few more discussions, I can start and complete your project. Did many BONUS money winning projects similar to yours. You can check my previous works / even download for TRIAL f Lagi

$75 AUD dalam 2 hari
(20 Ulasan)
4.5
ahmedmayeen

Hi, I explained my bid details in a private message; please refer to that for details. Regards, Mayeen

$200 AUD dalam 3 hari
(4 Ulasan)
3.5
shagoon2u

Experts are ready to start immediately

$90 AUD dalam 3 hari
(3 Ulasan)
2.9
WebSolution4

Hi, I am ready to start right-away on your approval. Best Regards, Websolution

$55 AUD dalam sehari
(1 Ulasan)
1.0
kiranappi

I am ready to take up this job,Please tell me the details.

$100 AUD dalam 10 hari
(0 Ulasan)
0.0
RedPeacePH

Please check PMB

$250 AUD dalam 7 hari
(0 Ulasan)
0.0
Svetanga

You will get the solution, wihout using the Pivot...

$204 AUD dalam 2 hari
(0 Ulasan)
0.0
sashidharan123

Can simplify this...

$140 AUD dalam 2 hari
(0 Ulasan)
1.9