Recent content by dusty

in case your interested henrinaiara I did manage to solve this problem. I will post it here later if your interested.

So we have an app called team room which is based On MOSS. I have a document library with 3 colums called project phase, activity and document type. These can be used to filter each collum. However I would prefer to have the filter controls detached from the web part. So I was going to...

Hi quick question is there functionality for naming ranges in this plugin? In normal excel I can select cells and name the range, then if extra rows are added the range expands with the rows. Cheers Dusty

Yes a simple count if would have worked. Sometimes we have a habbit of making things more complex than they actualy are. The other problem was that I wished to have in effect three different formulas in one cell and 3 option buttons to flick between the formulas. But I figured out the code...

This is what I use now and it works perfectly. =(SUMPRODUCT((test1="i")*(CA="x"))/(ROWS(test1)*(COLUMNS(test1))) The next issue is related to the named ranges. There are actualy 3 columns with x's marked in them. Each column represents a different clasification of project. Class A, B and C...

Thanks Brian didnt see your post until after I posted mine.

solved used sum product

had a look at the attachment could you not next to the price at the bottom have another column could be hidden for asthetics which had a symbol U or E signifying USD or Euro. This column could be filled in using conditional formatting from the price column. Then you could do a vertical...

=(SUM(COUNTIF(test1;{"i","ii","iii"})*{1,0,0}))/(ROWS(test1)*(COLUMNS(test1))) This the formula I am using at the moment. It calculates a percentage of cells labeled i in the range test1. Is there a way of modifying this so that it only counts if the cell is labbelled i and another cell is...

No im not offended in the slightest critisism is always good. One answer though we don't have access. Word and excel and outlook are the only common office programs we have across our sites world wide. Our database system is designed in house this is just a small scale project so we have no...

there are 3 forms The first form displays a summary of the document with labels stating Product name Recipe Number Product Type Project Number Project manager factory Date of last update Username of Updater 2 command buttons View Edit view shows the document edit loads a...

So I wish to save the contents of a VB form i.e. text box entries and combo box selections when the form has been used. Then on reload of the word document I would like this saved data to be retrieved so that the entries can be edited. I have code for doing this. I use this code to...

I don't think I was clear enough in my original post. I understand how to do it by using a command button and then say adding a row at the end of the table or end of a specific section. But there are 7 sections so would mean seven buttons. At the moment the user will right click on the left...

I have a table in excel which people can add too. When they add to the table they inesrt new rows in the relevant section. It would be nice to have code in place that when a new row is inserted specific cells are merged in that row rather than the user having to merge them themselves. Is...

Ive sorted it :) I used the define name option and selected the range. When rows are added the range automatically expands. Then I can select the range within vb by its name rather than cell references.