I can see your point too, and can see that you do help a lot of people. (I did my research this time).
Anyway I think it is time to stop this mini arument and carry on with our work.
Since this post I have worked out how to do the problem myself, so I doubt very much that it is beyond me to take part in these forums.
I am the first to admit that I get more out of this site than I put in, but that is because I am relatively new to it all. And learning day by day. And if...
In reply to a very unhelpful xlbo.
In response to your comment...This is not a helpdesk..of course these formums provide of source of help and guidance on resolving problems people have. So they can in one form or another be described as a helpdesk.
I would not have come onto this forum if...
Below is a typical line of information I have on a spreadsheet:
ABC 0
AB 1
ABD 0
RTD 12
TGR 9
What I would like is that when I get a 0 in a field that that whole row can be hiden, is that possible?
Thats great it works fine.
Just so I know what you did, Left,3 picks up the first three characters and Mid,6 picks up anything over 6 characters, so characters 4 and 5 are missed out.
Is that correct?
I have a table, within which I want to update a field.
Currently it has 5 characters within the field, eg:
5TR65
RTE32
I want to delete the 4th and 5th charcters for all recordss in the field.
How can i do this?
I have a master table that I import data into each month. Once i have imported the data I change or add certain fields within the master table.
When I run the module that changes/adds data to the master table it edits all the existing data. I want it to just edit the newly added data, how...
I have a pivot table that I read data off.
The formula used is as follows:
IF(ISERROR(GETPIVOTDATA('By Trust and Specialty'!$A$3,"'RespWL IP - "&$B$4&"' "&$A12&" 'Current Month' '"&$D$192&" Total' '"&E$11&" Resp'")),0,GETPIVOTDATA('By Trust and...
no good, I think it is because there are too many rows in the sheet!!! It is a pivot table. DOes any know the max number of rows allowed in a worksheet?
I have a workbook that I am trying to open, each time I click to open it, it goes to Excel and looks like it is opening up and everything. Even have the name of the file in the top of the screen. But nothing appears! What is wrong, everything else is fine just problems with this file!!!!
if i take out:
Private Sub Form_Open(Cancel As Integer)
Call SetRef 'Updates Reference when Form is opened.
End Sub
Private Sub Surname_AfterUpdate()
Call SetRef 'Updates Reference when Surname is changed.
End Sub
then it seems to work just fine, is this ok to do?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.