Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: albop
  • Order by date
  1. albop

    Copy & paste based on change in ID in next column

    Hi, I currently have a list of Policy Numbers (not unique) and Membership number (Unique) What I need to be able to do is copy and paste the first instance of a membership number where the policy number is the same and repeat the process on each change of the policy number. I've attached a...
  2. albop

    Applying ID numbers to multiple rows

    Thanks so much for your help - It's working perfectly :-)
  3. albop

    Applying ID numbers to multiple rows

    Hi, I've not used VBA in a number of years and found myself needing to use it this afternoon and I've gone totally blank! and I'm really hoping one of you could help I have an Excel sheet (see attached) where I have a membership number and on the same number there could be several people...
  4. albop

    Creating sequential count of transactions by Client ID in Excel

    oosh! That's just given me something further to investigate! Thanks so much for the help
  5. albop

    Creating sequential count of transactions by Client ID in Excel

    Thank you so much - I've been looking at it for ages and driven myself mental!! :-)
  6. albop

    Creating sequential count of transactions by Client ID in Excel

    Hi all, I'm trying to create a count of transactions by client ID so over a period of time we would expect a client to have made multiple payments, what I need to do is number them in order of date so essentially my data will look like the below with the transaction number being the variable I...

Part and Inventory Search

Back
Top