site

  1. D

    Save and close a wb

    I have some code that is meant to save and close the workbook identified in the select statement (Wes_reference or Riv_reference) but it is not closing it. What have I left out? Sub AddReference() Dim wb1 As Workbook, wb2 As Workbook Dim sh1 As Worksheet, sh2 As Worksheet, site As String Dim...
  2. HappyChappy

    Barcodes in Excel

    Hi having great problems with bar codes currently using a web based site https://www.barcodesinc.com/generator/index.php to generate barcodes then cutting and pasting them into excel as a picture. The site uses Code 128b for the fonts. I downloaded said font and thought it must be better to do...
  3. S

    Count instances of text where cell matches month/year

    I am trying to prepare holiday data for an import into a resource planning system at work. Human Resources have provided me a spreadsheet of all our sites (100+) and which holidays each site observes from 2019 through to the end of 2025. Sites are listed in column A. The date of the holiday...
  4. D

    Counting instances in workbook with both AND and OR statements

    All, I have a workbook that contains site names, technology at each site, then multiple columns where my KT teams can enter times for conducting knowledge transfer. Column A - Site Name; typically have 4-6 rows containing the Site name Column B - Technology; in rows for each site, there are...
  5. D

    Monitoring sharepoint site using VBA

    Hello Everyone, I was hoping there might be someone within this forum that has come across this issue before. I would like to set up some code to review a sharepoint site for the most current file that has been uploaded on to the site. The URL for the site is...
  6. A

    VBA to extract website that does not support IE

    I am trying to extract data in the table in this site. https://www.dw16.com/indicative-price-and-info/?dw=SAWA16C2001A Using various method, eg. web query, ie automation. I can't find a way to extract data. When open with IE, web page will say you need to use chrome or firefox to open the...
  7. TAPS_MikeDion

    Duplicate Data Check

    Hi everybody, I haven't been able to figure this one out on my own. I'll try to keep this as simple as possible. I need to search the rows of data for duplicate entries of Last Name (Col A), First Name (Col B) and Location (Col AB). I have 3 radio buttons used to select the sorting of the...
  8. S

    Tranpose with Editing

    <tbody> <colgroup><col width="536" style="width: 402pt; mso-width-source: userset; mso-width-alt: 19602;"> <col width="145" style="width: 109pt; mso-width-source: userset; mso-width-alt: 5302;"> <tbody> Site list Site list...
  9. F

    autogenerate WO number

    I need to autogenerate a number in a cell when other data in the row is filled out. Sheet is basically: Date Site Name several other columns of non relevant data Work Order Number I need the WO number to be in the following format: (4 digit site code)-1920-(next...
  10. J

    macro to Insert one named range at numerous changing rows containing the macro button inserting relative to the position of macro button used

    The copy and insert on macro “InsertAtLevel1” functions to copy the named range “l1insert” and paste at a row named range “insertPointL1” At the moment there are two reports site ABC and site DEF. But user my create further reports from the “l1insert” template The level 1 insert is working ok...
  11. D

    dynamic report header

    Access 365 I have a QBF with a combobox "CboGrouping" that tells the report the tow grouping the user wants. (code from Allen Brown) Now I need to add the correct fields in the Header area... i.e. if case 1, then District Header would be [District] and District Header would be [District]...
  12. T

    % increase.

    Hi all, New user and couldn't seem to find exactly what I was after, so hopefully below makes some sense. Context: I'm looking at utility spend across our portfolio of around 100 locations, each location is a different size and spend is location specific. What I'm trying to pull out is any...
  13. S

    Web Scraping Login

    I am going nuts trying to figure this out! I am needing to navigate to a site and login through VBA to scrap some data. (which I have done several times before) I cannot for the life of me figure out the HTML for this particular site...
  14. D

    Access

    Sorry to ask , but is there a site like this for Access?
  15. T

    Excel opening workbook in another instance

    Hi all, I have some multiple workbooks that I have saved on a sharepoint site that have macros to open other workbooks on that site and pull data out of them This all works fine, except sometimes when I open the other workbooks from the sharepoint site. excel seems to open the workbook in...
  16. T

    Return the value based on the another cells content within that row?

    Hi All I'm finding a solution to this problem of mine some what tricky! Hopefully someone a lot smarter than me will have an answer. I have a spreadsheet that records accidents for multiple sites, 1 row = a new accident Along the row it has a date of the accident in column B, further along in...
  17. S

    Trouble pasting VBA code, scrolling down post, typing

    Hi, Brand new here, and I'm having a little trouble with the site. First problem I ran into is trying to paste VBA code onto a post. I click the "paste as plain text" button, a window pops up, I hit ctrl+v, submit it, and nothing happens. Sometimes the window won't even pop up. I've also...
  18. T

    Grab data, create new sheet, rename tab, paste data

    Hi All I'm trying to speed up a process and in need to your help. I requested something similar a while back in an earlier post but can't adapt it. Here's what I do right now for each new tab. Sheet1 (Called Data) holds duplicate site names in Col A and staff names in Col B (sometimes...
  19. I

    vba code for automation

    Dear SirI want to enter data (roll numbers) from excel in site http://rajresults.nic.in/resbserx19.htm and the and extract the data received in excel. I had tried to write the code which is given below but unable to extract percentage or data from site. Please help. Private Sub...
  20. J

    Highlighting Cells with Conditional formatting

    i currently have a couple of tables on a workbook. i am wanting to use some conditional formatting that will highlight certain cells when a criteria is met and will change the highlighted cells when the criteria is changed. i am able to highlight one cell using conditional formatting, but is...

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