EXCEL VBA SMALL PROJECT

완료 등록 시간: 6년 전 착불
완료 착불

I have a spreadsheet that has 7 tabs, please see attached (the GREY tabs).

The orange tabs just show you how these tabs SHOULD look like after the macro has been run.

A few notes about the spreadsheet.

The main tab is „Raw Data”. All other tabs are empty at the beginning.

Most of the columns have data that is irrelevant (called „Data” in the attached spreadsheet)

The only columns that really „matter” are O, P, AW, BR, BV, BW

Column O and P can only take on three values: „Dog” or „Cat”, or „Sheep”

Column AW can take on only two values: N or Y

Column BR can only take on two values: „Apple”or „Orange”

Column BV can take on any value.

Column BW is a COUNTIF formulae (with range BV)

I need a VBA code that does the following.

1. The first row is just the header row, that should always stay the same no matter what.

2. If in a certain row, column P is not blank, delete the whole row

3. As I mentioned earlier Column BW is a COUNTIF function looking at column BV as a range and cells BV2, BV3 etc as criteria -please see attached in the spreadsheet

4. If in a certain row, the value of column BW is 1, move this row to tab „Sunday” (starting from row 2, do not touch the header) and delete it from tab „Raw Data”

5. If in a certain row, the value of columns BW is more than 2, move these rows to ”More than two items”, and delete these rows from tab „Raw Data”

6. If in a certain row, the value of columns BW is 2, then these pairs need to be analyzed individually following the below logic. (By pair i mean rows where column BV matches, so for example the two rows where column BV is „ad” and so on for all of the pairs)

A: if column BR has the same value for the two rows currently analyzed (so either Apple/Apple or Orange/Orange) move these rows to sheet „Monday” and delete it from the „Raw Data” tab

B: if column BR has different values for these two rows, do the following:

a. If column O if has the same value for these two rows (either Cat/Cat or Dog/Dog, or Sheep/Sheep) move these rows to sheet tab „Tuesday”

b. If column O if has different values for these two rows, do the following

i. If column AW is „Yes” for either of the rows move to tab „Wednesday”

ii. If column AW is „No” for both of the rows move to „Thursday” (Invalid mismatch)

7. Go to tab „More than two items” and if within any of the groups (same definition as before) column BR is the same for all row, move these to „Monday” and delete from „More than two items”

That is it, by now the raw data tab should be empty

Obviously the attached ss is just a random example, the actual spreadsheet is much larger and can contain thousands of rows.

I know VBA a bit, so please make sure all of the lines are explained so I can chaneg it if needed.

In the actual spreadhseet i wont necessarily have apples/oranges so please make sure it is straightforward how I can change it.

Same with the column names, so please make sure it is straightforward how I can change it.

I know VBA a bit so it wont be a problem if the code is clear,

데이터 처리 엑셀 비쥬얼 베이직 앱을 위한 비주얼 베이직

프로젝트 ID: #15838364

프로젝트 소개

11 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 6년 전

수상자:

sardaaditya28

This is a very easy task for me. I have 3 years of experience in VBA. I know how to write code and will be easily understandable for you also Relevant Skills and Experience Excel Vba, Excel Models Proposed Milestones 기타

£15 GBP (1일 이내)
(2건의 리뷰)
2.7

이 일자리에 대한 프리랜서 11 명의 평균 입찰가: £35

schoudhary1553

Greeting, I have understood your EXCEL VBA 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 Processing 기타

£20 GBP (1일 이내)
(377 리뷰)
8.1
avinav606lx

Hi there, This looks feasible. I am expert in Excel VBA with over 5+ years of experience. Ping me to discuss more about the project. Thanks Aman

£50 GBP (1일 이내)
(178 리뷰)
6.6
zu02

Hello , I saw your project and analyze your requirements. I can code your current Excel project. Relevant Skills and Experience I'm programming in ms Access/Excel/VB since Ms Office 97 released Proposed Milestones 기타

£38 GBP (1일 이내)
(33 리뷰)
5.8
insidenetsoft

Hello, We could create this macro that will loop and process the data following exactly the established rules. Also I could add a lot of comments in the code in order to be easily maintained by you later. My l 기타

£75 GBP (4일 이내)
(28 리뷰)
4.4
stillart

Hello, I'm available for this project. If you award me now I will complete it in 24 hours. Relevant Skills and Experience I have more than 20 years experience in vb (vba, vb6 vb.net) coding. Please take a look at my r 기타

£55 GBP (1일 이내)
(9 리뷰)
3.7
parthapaul0001

Hi,i am experienced in VBA Relevant Skills and Experience Data Processing, Excel, Visual Basic, Visual Basic for Apps Proposed Milestones £18 GBP - initial milestone

£18 GBP (1일 이내)
(7 리뷰)
3.4
XcelSolution

I have been working every day with Excel: formulas, databases, reports, and VBA for the past 10 years. Relevant Skills and Experience Excel: formulas, databases, reports, and VBA Proposed Milestones £15 GBP - Excel f 기타

£15 GBP (2일 이내)
(2 리뷰)
0.7
elwagner3000

A proposal has not yet been provided

£23 GBP (1일 이내)
(0 리뷰)
0.0
techokeet

Hi Mate, I have more than 10 years of experience and can deliver a very useful solution which will save a lot of time. I understand that you provided example data and would like something which can configured for real 기타

£18 GBP (7일 이내)
(0 리뷰)
0.0