Auto-populate column based on another column

Hi Putting the following line of code in the unit price cell will give you the unit price

=IF(B12="","",TRIM(RIGHT(B12,LEN(B12)-SEARCH("-",B12))))

I used simple IF to check if cell is blank to avoid the value error there are other ways to error trap but this will do - for Total Price you can time unit price by quantity.

Hope this helps!

One more thing when clicking new invoice I suggest you only clear cells that require input therefore not deleting your formulas example below would clear any content from the chosen range. You can use more VBA to pre-populate the rows in your "Sale" sheet and use the offset to move to a new row.

Private Sub CommandButton1_Click()
Range("B12:B26").Select
Selection.ClearContents

End Sub

technocrawl

I am certainly not and expert and I also don't think I am a geek but

In column H you could try:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

and in column I try:

Please Login or Register  to view this content.

Hope it works until someone with a better solution comes around.

Good luck and all the best wishes for 2011

John

Jolivanes, I'm sorry but

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc

arthurbr
First of all, a Happy New Year and all the best wishes for 2011.
To the best of my knowledge, there was no restriction yet on the thread I answered to but if there was, my apologies.

Jolivanes, thx for the wishes and may 2011 be wonderful for you.
I suppose that you did not ( as we all sometimes do) refresh your page before posting.

So, in the spirit of New Year, I will reverse the infraction., just for this time. Don't forget to hit F5 in the future :-)

Arthur.
Indeed, I did not.
Thank you for the kind spirit.

shg.
Too old be a sinner!!!!

All the best to all of you for 2011

Is that an expert talking Mike?
Maybe I should have worded as "Too Old To Be A Consistent Sinner"
Happy days to you also Mike

Thanks a Lot folks, I finally solved the problem with your kind help and little more messing with the dynamic lists....

Now I am in the final stage guys, but still one more problem is there, I think its bit easy to solve this issue, but i am looking for VBA code from the experts to calculate the "Total Price", by automatically taking the values of "Unit price" and "Quantity". I dont want to do this with any sorta formulas, I am only looking for the VB code, that helps fix this issue and I dont want to calculate the "Total Price" manually.

Find the Excel file that i am dealing with in the attachment...

Thanks in advance...