I gang

Project for bharani - excel

Please refer to the "NOTES"

on the worksheet.

Thanks,

Ask me any questions you might have...

The macro must do the following.

1.Delete rows that contain "Surface Sum" and "Total"

2.Choose which product to gather data from.

3. I will instruct the macro to pull the data for each week based on the following criteria:

1. Week, Product, which worksheet to pull data from ("single" or "double")
2. Choose the 5-7 character of ID2 to be placed under "Title1","Title2", "Title3" or "Title4".

Example: id2=D1A3ZZZV2 ----> i set that "zzz" will placed on "Title1" for product1.

id2=V08ABFCWD ----> "BFC" will be placed on "Title2"

So, all the id2 data will populated the tables that i set to.

*Any id2 that a rule was not created, will be placed on "Title4"

4. The pulled data will be pasted on "Sheet3" and will have the description, id1 and id2 and the number(week that i chose)
to be put under "Orders". If repeated more than twice, place the SUM of the numbers.

5. Same thing will happen for "Visitors". Take the SUM if the instance is repeated more than once.

NOTE: On the "Singe" and "Double" worksheet you will see columnd D called "Events"
COUNT AS "VISITORS" only events that have the following "Gift VIsitors" or "Subscription Visitors"
Anyother event is counted as a "ORDERS"



*Description is be taken only from "ORDER" events.


See Example for how the data to be pulled and pasted on the "Sheet3"

Worksheet: "Single" , Row 8 & 11, column 'Q'.

Product 1 44949 Description 5 Order Ack - Credit Card V92AZZZWN

Product 1 44949 Description 8 Subscription Visitors V92AZZZWN





The macro must do the following.

1.Delete rows that contain "Surface Sum" and "Total"

2.Choose which product to gather data from.

3. I will instruct the macro to pull the data for each week based on the following criteria:

1. Week, Product, which worksheet to pull data from ("single" or "double")
2. Choose the 5-7 character of ID2 to be placed under "Title1","Title2", "Title3" or "Title4".

Example: id2=D1A3ZZZV2 ----> i set that "zzz" will placed on "Title1" for product1.

id2=V08ABFCWD ----> "BFC" will be placed on "Title2"

So, all the id2 data will populated the tables that i set to.

*Any id2 that a rule was not created, will be placed on "Title4"

4. The pulled data will be pasted on "Sheet3" and will have the description, id1 and id2 and the number(week that i chose)
to be put under "Orders". If repeated more than twice, place the SUM of the numbers.

5. Same thing will happen for "Visitors". Take the SUM if the instance is repeated more than once.

NOTE: On the "Singe" and "Double" worksheet you will see columnd D called "Events"
COUNT AS "VISITORS" only events that have the following "Gift VIsitors" or "Subscription Visitors"
Anyother event is counted as a "ORDERS"



*Description is be taken only from "ORDER" events.


See Example for how the data to be pulled and pasted on the "Sheet3"

Worksheet: "Single" , Row 8 & 11, column 'Q'.

Product 1 44949 Description 5 Order Ack - Credit Card V92AZZZWN

Product 1 44949 Description 8 Subscription Visitors V92AZZZWN





The macro must do the following.

1.Delete rows that contain "Surface Sum" and "Total"

2.Choose which product to gather data from.

3. I will instruct the macro to pull the data for each week based on the following criteria:

1. Week, Product, which worksheet to pull data from ("single" or "double")
2. Choose the 5-7 character of ID2 to be placed under "Title1","Title2", "Title3" or "Title4".

Example: id2=D1A3ZZZV2 ----> i set that "zzz" will placed on "Title1" for product1.

id2=V08ABFCWD ----> "BFC" will be placed on "Title2"

So, all the id2 data will populated the tables that i set to.

*Any id2 that a rule was not created, will be placed on "Title4"

4. The pulled data will be pasted on "Sheet3" and will have the description, id1 and id2 and the number(week that i chose)
to be put under "Orders". If repeated more than twice, place the SUM of the numbers.

5. Same thing will happen for "Visitors". Take the SUM if the instance is repeated more than once.

NOTE: On the "Singe" and "Double" worksheet you will see columnd D called "Events"
COUNT AS "VISITORS" only events that have the following "Gift VIsitors" or "Subscription Visitors"
Anyother event is counted as a "ORDERS"



*Description is be taken only from "ORDER" events.


See Example for how the data to be pulled and pasted on the "Sheet3"

Worksheet: "Single" , Row 8 & 11, column 'Q'.

Product 1 44949 Description 5 Order Ack - Credit Card V92AZZZWN

Product 1 44949 Description 8 Subscription Visitors V92AZZZWN





Færdigheder: Dataindførsel, Databehandling, Excel

Se mere: thanks you notes, me excel, ask excel, data entry worksheet excel, notes data entry, worksheet excel, data entry excel questions, excel worksheet data, bharani, data entry excel worksheet, data entry notes, data processing worksheet, processing worksheet excel, excel worksheet, excel questions, excel search project, excel macro project daten importieren, excel import project vba, free excel spreadsheet project movement inventory, excel college project, excel vba project plan, excel regression project, excel database project, excel vba project 2007, scan document excel word project

Om arbejdsgiveren:
( 16 bedømmelser ) Toronto, Canada

Projekt-ID: #960131

Tildelt til:

bharanisrihari

Hi, as discussed. Will try my best to deliver in 2 days time. With the same QUALITY. Thanks!

$100 USD in 3 dage
(67 bedømmelser)
6.4

7 freelancere byder i gennemsnit $43 for dette job

frehmanpk

Respected Sir, I can assist u in designing a MS Access database for all ur requirements. Please see PMB for details & I m Ready to start immediately. Surety of quality work done with 100% accuracy with attention to Mere

$30 USD in 0 dage
(8 bedømmelser)
3.0
Alexandriaericka

Good day Sir. Please consider of hiring me for this project. I may be new to here at [url removed, login to view], but my long experience at [url removed, login to view] as a data researcher and encoder, working as a member of a BPO company, I Mere

$30 USD in 3 dage
(1 bedømmelse)
1.9
pavanasamr

Hello, we can get this done using VBA. Please check your PM for details.

$35 USD in 3 dage
(1 bedømmelse)
1.6
nouraradi

i will do that

$40 USD in 4 dage
(0 bedømmelser)
0.0
choxy

i want to start with this project, just give me details

$30 USD in 3 dage
(0 bedømmelser)
0.0
azroon

sure i can do the best

$37 USD in 3 dage
(0 bedømmelser)
0.0