LinkBack URL
About LinkBacks
Hi,
I have been working on this project for some time, some people have already helped me , but I got stucked now and I cannot move on. I send the database in the attachment, can somebody of you help me work out some of these problems? Any help is greatly appreciated :-)
The problems in the spreadsheet are:
All the sheets:
1.The numbers ( first column) could be added automatically ( in ascending order) and updated if I add or delete a row in the table.
Pipes sheet:
2. I would need the dropdown menu in the form ( if possible) so that I can choose the fittings and price cathegory directly when entering data. When I click add new record the dropdown lists are not copied ... but If I can choose from a dropdown in a form ( i need dropdowns for fittings and price cathegory), this problem would already be solved.
Price offer sheet:
1. In the form the data in the dropdown are merged from pipes table and others table on separate sheets. However I need to get the Unit price and Unit weight from the Total Weight and Total Price in the pipes sheet and from Price and Weight on the others sheet. I used to do this by Vlookup function, but I dont know how to program that for forms ( and when I have tables on two sheets as the source tables)
2. I would like to have the summary that will sum up the total weight and total price in the price offer sheet. I would like to have it as the last row of the table ( now there is a blank row between the last row and the totals, I would also like to have the word totals written in the B column, but it deletes itself automatically when I add new record).
Can somebody help me work out these problems? I send the database in the attachment, I would be greatful for any help with these, because I am strugling with this project for so long ...
I am a newbie and I have to pass out this project I was given at work .... this is a one time project so I cannot dedicate years to learn VBA code / macro.
Mechant
Register To Reply
Bookmarks