Search results

by the way the link you sent doesnt work..Can you please look into it

Thanks SirJB7 I was hoping this would provide some solutions as it is much easier reviewing complex workbooks...Any other takers on this???Any add ons???

I was searching regarding highlighting cells from other sheet (in edit mode) but could not find any solution to it. (Just like we can do when editing a formula). Hope i make myself Clear. For example A3= =Sheet2!F9+Sheet2!F11 then somehow when i go top the other sheet i can see which cells...

Dear Sir, I have uploaded another file . There are remarks within the file. Have a look. Yes ID 120 will be the code and when this code is entered in Code Column(H column) the Shape must change accordingly, Consequently since there is only one length in Spiral. On entering this length in column...

Thanks for the response Narayan :)

Yes its very acceptable.... There is no particular code name I want but i am putting in few shapes which we use ...

Hiii dear readers, I am trying to prepare a bar bending schedule which basically calculates length weights of various shapes of bent reinforced bars . (File attached) I will input dia of bar, no of elements , bars and cutting length which I will calculate from the drawing. Now the...

Okk thanks...will try :)

Yes only in my system for some reason ... Not sure what can be done now :) ..

when i move with my keyboard i hardly can move without creating a lag in areas where data validation is created .. i was easily doing it for all the workbook but only those portion the keyboard movement was problematic... for example D5:D60 (Or others with the same ColorCode) the right keyboard...

It is difficult to move in sheet where the data validation exists. What could be the reason?? Files Attached.

If you do not wish to make a dashboard. Simple rank formulae for Excel 2007 can do the trick.

Drop box link for the same file https://www.dropbox.com/s/o8k8khbpr35nqua/Excel%20Cashflow.xls.xlsx

Hiii Greetings!!! I have a worksheet with the following parameters a) Sales Projected b) Project Schedule c) Payment Plan A payment plan is to be derived by taking the following criterias:- • When a person buys a unit he has to pay the cumulative percentage(multiplied by Bsp ) till...

Thanks for the help Hui....however Consulting would be way to much to ask for the company at my level and I would try to understands the simple VBA you told about doing what is mentioned here http://www.begraphic.com/create-custom-map-add-in-excel-and-powerpoint Menitoning any further resources...

I have been to Daniells site but then No VBA section i get panicstruck for now...At excel charts i read an article http://www.excelcharts.com/blog/how-to-create-thematic-map-excel/ but it wasnt exactly replicated in 2007.. However regarding what exactly I want is a Visually effective Site...

Dear Hui...vow i never thought you would step in but anyways....I have allready gone through chandoos PM posts but What I want is somehting like this http://www.begraphic.com/create-custom-map-add-in-excel-and-powerpoint Rather than making it a gantt chart it should just be a visual thing which...

I am a construction engineer and i think to visually record progress thematic charts might be a good idea. The monitoring part includes major activities like excavation concreting etc and I want to show them on the map + carry out some insightful informations.Is it possible in excel or shoul I...