Devam Ediyor

Excel 2007 Data Operations using Macro

Hello,

I have an excel spread sheet which has multiple columns in the first Worksheet. One of the columns in that sheet is the Date ‘column’. There is data in the other columns which is there for that particular date. This first worksheet has all the data which has been captured and the data in some columns have been calculated using the appropriate formula.

I also have the second worksheet which has some of the columns based on the data from the first worksheet. Basically, all the data in the columns in this second worksheet have been derived from the data in the first worksheet. I have put all the formulas in the columns needed to populate the data in all these columns. The third worksheet displays some pie and bar charts based on the data from this second worksheet.

I would like to create the pie/bar charts based on the input data from a selected date range of first sheet. So all the necessary calculations in the second worksheet can only be done on this data for a particular date range (which has been captured in the first worksheet). The charts in the third sheet would be created accordingly. So, in a nutshell it is quite simple: Pick up data for the date range specified by the user from the first worksheet, apply the necessary formulas and populate the columns of second sheet, and finally create charts from this data. I think you would need a macro for this to ask user for the date range and then work only on this data in date range. Not more than 1 hour job for an excel wizard, as I have all the formulas and data.

Let me know ASAP as I have limited time and also the timeframe to do it. Thanks

Beceriler: Excel

Daha fazlasını görün: excel data operations, data operations excel, date operations excel, me excel, ask excel, excel data operations macro, excel sheet formula, simple macro, operations, macro, macro excel, macro + excel, it operations, input data , excel spread sheet, excel job, Excel Formulas, excel formula, excel data sheet, excel charts, excel based, do excel, create excel worksheet, sheet excel job, data range

İşveren Hakkında:
( 1 değerlendirme ) Mumbai, India

Proje NO: #748064

Seçilen:

Abikris

Hi Check your PMB Kris

0 gün içinde 30$ USD
(5 Değerlendirme)
2.5

37 freelancer bu iş için ortalamada 53$ teklif veriyor

iQraTechnologies

Hello, are you looking for an Excel Expert? See your PM...

1 gün içinde 50$ USD
(3 Değerlendirme)
2.3
CamThuy

I can do it. Let me do it for you

in 3 gün içinde30$ USD
(1 Değerlendirme)
2.1
pradeep1210

Please see PMB.

1 gün içinde 34$ USD
(1 Değerlendirme)
1.9
FinanceMike

No Macro Needed. I can make it very user friendly with 100% accuracy.

1 gün içinde 75$ USD
(1 Değerlendirme)
1.4
WebSolution4

Hi Sir, Please view PM. Thank you

1 gün içinde 60$ USD
(1 Değerlendirme)
1.0
bojan1979

I have done a lot in excel using macros, and willing to start working. If you are interested in some examples of my work, send PM, regards.

in 7 gün içinde50$ USD
(1 Değerlendirme)
1.0
SolitaireMumbai

I am ready to take up this assignment.

1 gün içinde 50$ USD
(0 Değerlendirme)
0.0
dsalis

I am a computer programmer looking for some extra money on the side. I have Excel 2007 at home and I have developed a complex workbook to keep track of our family budget. In addition, I am very familiar with Visual B Daha fazlası

1 gün içinde 50$ USD
(0 Değerlendirme)
0.0
chinashellivy

glad to help

1 gün içinde 50$ USD
(0 Değerlendirme)
0.0
anatprog

I can do it

1 gün içinde 50$ USD
(0 Değerlendirme)
0.0
nithya62463

Dear Sir, We are very much pleased to join in your project by participating in the bid. We are a 7 member team working together in online jobs for round the clock to establish ourselves as good, accurate prompt and ho Daha fazlası

in 0 gün içinde36$ USD
(0 Değerlendirme)
0.0
aggarwal123456

hello sir i have done many of MBA project doing in my MBA.i have done this excel work in my project so i am sure i can complete it easily.

in 2 gün içinde51$ USD
(0 Değerlendirme)
0.0
asadraza51214

Simple one

1 gün içinde 50$ USD
(0 Değerlendirme)
0.0
freelancerjimit

Please check your PM..

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
athennakoon

Total - 50$ Days - 1

1 gün içinde 50$ USD
(0 Değerlendirme)
0.0
roy21

Hello This is supriyo [url removed, login to view] grad looking for job. I am very serious and dedicated for job, looking forward to business with you. Regards supriyo

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
rvikramn

I.m ready to this project.... i need the detailed description abt this

in 5 gün içinde33$ USD
(0 Değerlendirme)
0.0
riffat85

Hi Sir, Please view PM. Thank you

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
sajid0001

iam very serious for this job

in 2 gün içinde45$ USD
(0 Değerlendirme)
0.0
vinodroy

hi,i am ready pl contact

in 2 gün içinde50$ USD
(0 Değerlendirme)
0.0