Devam Ediyor

Excel MetaData Macro

Hi I would a VBA Macro that can work across Excel 2007, 2010, Excel 2013 that can do the following.

Extract the following Data from a selection of Excel Cells on a sheet. Alternatively the user should be able to select a single Graph and extract cell data from that Grapth. The results are to put on separate sheet (Name will specified by Users) which will be automatically generated.

- Graph Name if Applicable.

- Sheet name

- Cell Location

- Cell Format

- Cell Formula

- Cell Value

- Cell Value Char Length

- Cell Comments

- Data Validation Applied to the Cell (Yes/No)

- Colour Of Cell (Hexadecimal format)

- Cell Font Used

- Conditional Formatting Applied to Cell? (Yes/No)

- If yes how many rules are applied to the cell. Eg Result = Yes, 13 Rules

- Does the Cell has Precedents? (Yes/No)

- Does the Cell reference External Sources. (Yes/No)

- If yes what is the external datasource (Web Address, File Location, Database etc.

*****************

User should be able to select what data they want to extract from the cell. The cell data this doesn't apply for is: Graph Name, Sheet Name, Cell Location.

All column heading should be labelled and in Bold. As specified above.

******************************************

I don't mind if you borrow code from the net if saves development.

My primarily concerns are strong error checking and good commenting of the VBA Code.

****************

Timeline: 1 Week for Development, 5 Days for testing on my end. Early upload of beta of course is accepted as well.

Thank you.

Another thing to check.

- Does the cell selection contain any hidden rows? (Yes/No)
- Does the cell selection contatin any hidden columns? (Yes/No)

I few other things I forgot to mention.

- Blank cells are to be ignored, if the user selects a check box specifying so.

*****
- Cell formula Char length.
- The value N/A to be written if for instance the user selects extract 'cell comments' and their are none.

Update:

The maximum I would be willing to pay for this project is $100.

Thank you.

Requirements Update:

Cell Named Range Reference - If Yes list the name, If No then put N/A

Thank you.

Beceriler: Excel, Visual Basic, Uygulamalar için Visual Basic

Daha fazlasını görün: excel metadata macro, how do you graph data, excel macro how to, excel macro file location, what is vba in excel, what is vba, what is macro in excel, vba error, excel sheet formula, excel 2013 vba, end vba, vba excel macro, vba code excel, Macro vba, macro to upload, excel vba macro, Excel Macro VBA, Excel Formatting, excel 2013, excel database visual basic, macro development excel, excel colour, excel sheet formatting, 2013 visual basic applications excel, visual basic database excel database

İşveren Hakkında:
( 82 değerlendirme ) Melbourne, Australia

Proje NO: #4462310

Seçilen:

sharly001

Simple for me. PMd.

2 gün içinde 63$ USD
(1 Değerlendirme)
1.8

8 freelancers are bidding on average $109 for this job

northwolves

Ready to [url removed, login to view] PMB please.

in 2 gün içinde100$ USD
(47 Değerlendirme)
5.0
srikartiram

I can make this. Please check PMB

in 5 gün içinde113$ USD
(22 Değerlendirme)
4.1
vickkey7

I am ready to start this project... I am ready to start this project... thanks thanks

in 5 gün içinde94$ USD
(9 Değerlendirme)
3.4
rohitpithisaria

Hi... I would like to apply for the job.

in 7 gün içinde105$ USD
(5 Değerlendirme)
3.3
PapucMihai

I have 5 years of experience in working with VBA for Excel, and I would have your project ready within the week.

in 7 gün içinde154$ USD
(0 Değerlendirme)
0.0
mrganr

i am ready go to begin =========== mr ganr

in 3 gün içinde154$ USD
(0 Değerlendirme)
0.0
KreativeSys

We are good in Excel Macros! We can do this task easily! We have done excel projects for other clients before!!

in 7 gün içinde88$ USD
(0 Değerlendirme)
1.6