forward

  1. R

    Environ use (blackslash vs. forward slash)

    So I have a question on the use of Environ function in VBA. If I want to open a file from my desktop, it appears I need to use forward slashes instead of backslashes? Is this correct? Is there a forward slash version on Environ? Private Sub PortConvey_Click() Dim sPath As String 'MTS...
  2. VBE313

    What does this mean on Microsoft’s website?

    Can someone please give me a detailed example of what this means? Do not use forward referencing and backward referencing To increase clarity and avoid errors, design your formulas so that they do not refer forward (to the right or below) to other formulas or cells. Forward referencing usually...
  3. J

    find and replace same word showing twice in same cell

    Hey Guys, Trying to figure out how to find and replace the same word that shows twice in the same cell. Is this possible? I took a text file and pasted it into excel to do a find and replace but realized I need it to find the next word in the same cell and its not doing that. I am trying to...
  4. P

    Help re Date Sort with New Entry AND Date carried forward from previoius sheet, ie mixed, pls

    Using Excel 2010 I have spreadsheet, each month on own sheet and, currently, have a Macro to sort the date into ascending order, (day only, ie between 1-28/31) and taking the whole row, of course. See VBA below Due to other entries being added each month, in addition to those carried...
  5. Y

    Forward an outlook email from an excel macro

    Dear members, I am trying to forward an outlook email to multiple adresses with a vba macro in excel. Why in excel ? Becase all the email adresses are in the excel file. I want to forward an email that I received. I want to forward the exact same email (i.e. without the usual lines when you...
  6. B

    How to remove forward slash (/) from a series of numbers

    I have an excel sheet and one column has a series of numbers that make up a barcode for a particular product. My problem is that each of these barcode numbers has forward slashes within them (eg: 123/45/678/910). In order for me to process the numbers I need to remove these characters as my...
  7. L

    Help with sequential numbering

    HI, I need to create a Excel Database file for work and more importantly I am really terrible at Excel. I need rows from 1-1000 and only 1 column - that much I know....but it has to be 1000 records of "1/1000" then "2/1000" then 3/1000 and so on all the way to "1000/1000". So far all i am...
  8. S

    Searching for players in a particular position

    Hi, I have a list of players & their positions: <colgroup><col><col></colgroup><tbody> Alcock, Craig Full Back (Right) Alcock, Craig Central Defender Alcock, Craig Defensive Centre Back Alcock, Craig Full Back (Left) Anderson, Tom Central Defender Anderson, Tom Defensive Centre Back...
  9. S

    Getting a VLOOKUP to say a line of text

    Hi, I've got a list of players but i'll just narrow it down to 1 for the reason. At the side of 62.06 i want it to say "Taken" as there is already a player in that position, i just cant figure out the formula. I think it's a VLOOKUP but that just returns the players name & i dont want that. Any...
  10. S

    Matching one position to another

    Hi, At the top of my page i have this: <colgroup><col width="220"><col width="152"><col width="157"><col width="118"></colgroup><tbody> Highest Rated Player (Available): Beestin, Alfie Attacking Midfielder 500 </tbody> <colgroup><col width="220"><col width="152"><col...
  11. D

    VBA Command from Excel to forward emails in Inbox(outlook)

    Assume below is a excel worksheet with consolidated emails from MS outlook(by export data function as .CSV) , I need help to develop VBA code to trigger action to forward email from ms outlook Inbox folder where below Subject = C2, then should get forward to assign=D2,similarly C3 then should...
  12. R

    Help with VLOOKUP when using a referenced cell

    I am trying to make a spread sheet of data for the nba arranging players against who they would be matched up against for that night's game. I currently have it set up so that the teams are labeled and depth position is input manually along with opponent. For instance, LeBron James (small...
  13. S

    Pivot Tables Count vs Sum

    When I'm creating a Pivot table some of my numbers default to count instead of Sum. Is there any way I can fix this in a setting so going forward I don't have to keep changing it or do I need to change the value settings every time? Thank you
  14. M

    VBA linear interpolation FX forward points

    Hi community, please bear with me this is my first post. I do have basic VBA knowledge but Im struggeling to achieve the following. I do have curve of forward pts from bloomberg or reuters as you can see from below html code. What I try to generate automatically is the yellow area. Basically...
  15. J

    Excel to word linking

    I have an excel linked word table. Whenever, I make changes to the excel file, it gets reflected in the word document except that the formatting in the excel file is not carried forward to the word. What are the possible remedies?
  16. C

    VLOOKUP Results - removing 0

    Alright, I have done a search and did not find for 0, for #N/A yes, but not 0. Here is the formula, very straight forward: =IFERROR(VLOOKUP(A:A,Physician!A:P,5,FALSE),"") In the results I am getting 0 instead of a "blank". Any suggestions? -T
  17. A

    Unpivot and Arrange the data in Sheet1

    Hi All, Please help me unpivot and arrange the data in Sheet1 using power query. My data must look same as in Sheet2.. Mr MarcelBeug helped me in the past and now I am looking forward to his help or some other expert. My file link is here...
  18. B

    Progressing through data range until conditions are satisfied.

    Hi all, I have a a long data sequence consisting of either 0s, 1s or 2s. By starting at a random point in the data I'm looking to calculate how many cells forward I need to progress until I come across 'X' number of cells in succession with values ≤ 'Y'. Hopefully that is clear. As a quick...
  19. B

    month text to number formula

    I'm rolling forward financials and have a budget number for the month on worksheet 3 in cell M1, so right now it's 7 for July. Is there a way I can have it change to 8 when I roll forward the financials? I would have the month name August on worksheet 1 cell D5.
  20. J

    Vlookup Help

    I am trying to lookup a value in a separate workbook whose value contains a forward slash. The lookup value is "Total Disc / Coup" and the lookup doesn't work with the forward slash in it. Here's formula: =VLOOKUP("Total Disc / Coup",'C:\FH276 QB WEEKLY...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top