p.o

  1. K

    Struggling with Loops

    I have two worksheets in my workbook. Sheet1 contains customer order information with column A holding their account number. Sheet2 contains customers name & address information with column A also holding their account number. I need VBA code to start at cell A2 of sheet1 and check the account...
  2. S

    Extracting numeric portion of address with p.o. Box help?

    the following formula is used for extracting the numeric portion of the home address. However, how can I add onto this formula to give me the numeric portion of the p.o. box. The addresses appear on a single column but the formula leaves the po box cells blank because it's not finding a numeric...
  3. A

    Splitting Address Out With Spaces

    Hi I've been given a large amount of data to transfer from one system to another, the problem I have is that the original data is space delimitited, for example; 12 High Street Leeds Flat 1 28 New Street Openshaw Manchester P.O. Box 255 15 Low Street Hackney London Other than using text to...
  4. T

    Auto-populate P.O. info

    Hello all. I'm updating our P.O. form again as it has been requested that wave letter representations be placed behind our P.O. number so that anyone looking will know how many waves of collateral materials were ordered just by looking at the P.O. I tried to add on to my original formula which...
  5. B

    Outstanding balance formula in Pivot

    Hi everyone, my first post on here, so please be kind. I have a list of invoices raised and alongside each which Purchase Order they refer to. In a Pivot I can see the total invoices raised against each P.O, but I am struggling to show the outstanding value of the P.O. The list is constantly...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top