for egs:
column A having different or same names Egs: james, peter, james .... Column B have its value 1, 2, 3..... Now how i will subtract another value "egs: 50"(james) from same name value, that meants 50-1-3.
that meants ,all same name value in one column-all same name value in another column
Can you provide a sample workbook with a before and after?
HTH
Regards, Jeff
Sir Here below the workbook.. please check sheet1 and sheet2
In H12 cell
Formula:
Please Login or Register to view this content.
Drag it down and right..........
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
thnksssss, i got the result
how can i generate auto seriel numbering(1,2,3,...)from column A2 to A20 when data enter in another column B2 to B19
In B2 cell
Formula:Please Login or Register to view this content.
Drag it down.......
thnkk but its not working.. i need autoseriel number in columnA, From A2 to A19.....when i enter any data in B2 to B19
Oops.... sorry...
In A2 cell
Formula:Please Login or Register to view this content.
Drag it down.............
Shouldn't you start a new thread? This is a different questionOriginally Posted by semeer
i am using the below code for data entry by using userform . now am entering data to Sheet1. but i need this same data to another sheet, that is sheet7
Please Login or Register to view this content.
Last edited by jeffreybrown; 01-29-2013 at 08:55 AM. Reason: As per Forum Rule #3, please use code tags…Thanks.
Please refer Post #10
@semeer,
Moderators Note:
- Please follow Forum Rule #3 and use code tags.
- Added for you this time, but please use them in the future…Thanks.
- And please start a new thread as already advised.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks