Tamamlanmış

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: 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

%selectedBids___i_period_sub_7% gün içinde 30%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(5 Değerlendirme)
2.5

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

iQraTechnologies

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
2.3
CamThuy

I can do it. Let me do it for you

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
2.1
pradeep1210

Please see PMB.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
1.9
FinanceMike

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
1.4
WebSolution4

Hi Sir, Please view PM. Thank you

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
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 %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
1.0
SolitaireMumbai

I am ready to take up this assignment.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% 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 Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
chinashellivy

glad to help

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
anatprog

I can do it

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% 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 Fazla

in %bids___i_period_sub_35% gün içinde36%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(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 %bids___i_period_sub_35% gün içinde51%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
asadraza51214

Simple one

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
freelancerjimit

Please check your PM..

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
athennakoon

Total - 50$ Days - 1

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
roy21

Hello This is supriyo [login to view URL] 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 %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
rvikramn

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

in %bids___i_period_sub_35% gün içinde33%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
riffat85

Hi Sir, Please view PM. Thank you

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
sajid0001

iam very serious for this job

in %bids___i_period_sub_35% gün içinde45%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
vinodroy

hi,i am ready pl contact

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0