post

  1. P

    Excel 2010 formula to look up duplicates so I can contra them off

    Hi, first of all thank you for looking at this post. I have started a new job and am wanting to improve the speedof the month end process. I have to download the information from Excel from thenominal ledger to review (approx. 3000 lines) some of the values are the same butare pluses and...
  2. S

    Autoexecute when Access is open or closed

    I have been looking for my original post or the post that I think I thought was mine but was someone else's. Anyway, we have an access tool that someone else built. Each day I press a "Run All" button and 20 mins later I finishes and I continue. We are trying to have this run automatically a...
  3. T

    Posting Screen Prints to Questions

    I have a basic question that I haven't figured out. How do I post (paste) a screen print to a message I am posting? I see the Insert Image icon in the ribbon, but when selected it prompts for a URL. How do I post a picture stored locally on my computer to the question I am posting? Thank you...
  4. I

    excel survey calcustion, pre and post session.

    A colleague has asked to see if there a way of creating a formula to calculate the progression that a group of young people have made through a survey folllowing a short course. The table below shows 9 young people and where they gauged their level of understanding before and after the session...
  5. J

    Histogram graph

    Hello We use a product that generates an histogram on a PDF I would like to generate a mirror image of the report but I also need help to generate an histogram graph. How can I show you how the reports looks as I can't post images
  6. L

    design mode

    Hi I want to understand Developer-->Design mode and what is used for. I read this post https://www.mrexcel.com/forum/excel-questions/32669-design-mode-vba.html and Parry said: ""If you select the Control Toolbox to draw a control etc, you will notice that design mode automatically comes on.""...
  7. H

    Copy to next blank column - almost there

    Hi All, I want to post to the first blank cell in Row 'L' after L3, but it is pasting to B3. Any correction pls?
  8. Dan Wilson

    Forum privileges

    Good day. After writing a rather lengthy question, I found out that I am not allowed to attach documents to my post. What privilege do I need to be able to do that? Thank you, Dan Wilson...
  9. J

    Question About Posting Questions Posted on Other Forums

    Hi everyone, can i post a thread present in another forum? jc
  10. P

    VBA - How to call a new tab with variable name

    Hi, I've written some code in VBA which creates a new tab based on a cell value. As you can imagine this cell value can change. After creating this tab i wanted to paste some information into it. However, I cannot call the tab; i'm getting error 9 subscript out of range. Or Object required...
  11. BlakeSkate

    [vba] Checking if sheet exists inside array

    Hello, I have this sub from jmacleary found on this post but i thought i would be best to start a new post as the problem has shifted So the sub will grab sheets from an array and put the first column of each sheet into one sheet titled "Unknown" My problem is that the sheets are now generated...
  12. G

    Vlookup based on contents of a cell

    I've gotten a list of post codes and their counties. This is how the data is presented: <thead> #EAECF0[/URL] , align: center"]Postcode area #EAECF0[/URL] , align: center"]Postcode districts #EAECF0[/URL] , align: center"]Post town #EAECF0[/URL] , align: center"]Former postal county...
  13. D

    How long does it take a moderator to approve a post

    Hi all, new to this forum. I tried to make a post about 4 hours ago but it will not show up in the Excel Questions forum. How long does it usually take for a moderator to approve it. I made myself look stupid by trying to post it twice more thinking I did something wrong the first two times.
  14. H

    How to attach file on newpost

    Hi everyone! I'm new mem :) How to attach file on the new topic Thanks you so much!
  15. B

    Count consecutive occurrences when sum of two consecutive numbers below 3

    Hello, I have a column of numbers : 3 0 4 2 1 0 5 0 3 2 0 2 I am trying to get the number of times the sum of two consecutive rows is below 3. In this example 4 (i.e. 2+1,1+0,2+0 and 0+2). I tried a way around with this formula : =SUMPRODUCT(--(FREQUENCY(IF(C5:C16<2, ROW(C5:C16))...
  16. K

    Distance between addresses

    Hi, I am looking for a way to find the closest destination based on a post code entered by an user. As below, when an user inputs "Post code A", I would like the macro to use maps:) and bring back the closest location to post code A which for e.g may be Post code Y Post code entered : Post...
  17. R

    Posted replies not showing in thread

    Hi, I have replied to a thread i started last week, and it hasn't been posted, i did the first one about 11am AEST +10GMT and it worked fine, bu then i replied to another quote, i pressed submit, and had a meeting to go to. I came out of the meeting an hour ago and checked the thread and the...
  18. R

    Split Text in to adress format

    Hi, Can some body help me to split the excel value. I have a list of address's in one excel and I want to split it into the normal address format. for eg. my current value is something like this, <tbody> Abraham , XXX HOUSE, yyyy POST PLACE 689121 </tbody> I want to split it like...
  19. M

    Complex Index match or sumproduct?

    Hi I'm stuck. I have a table where I want to read the dates depending on country and row type. THEN - populate this on another table under the relevant date with a code. So here's my table I am reading from (sorry I can't paste it as a table for some reason?)...

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Macro to copy values across rows and transposing them and add the user id
    [FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=Calibri][SIZE=3][COLOR=#000000]Hi,[/COLOR][/SIZE][/FONT] [FONT=Times New...
Top