vba & excel

  1. J

    Copy data from lastrow to first empty row on new sheet created

    Good morning all! I've been trying to used multiple posts for reference, but i'm stuck on the last piece of code to make this sheet work. When i create a new sheet, based on the submission of data through a userform, it should also copy the data to the new sheet created (to automatically start...
  2. J

    Name new Worksheet with range from LastRow on list

    Good Afternoon, I'm currently having trouble with my code to name a new sheet (when created) with the value from column A, using the last row used as guidance. The userform adds the data to the list and it should copy a worksheet named "Template" and rename itself to the last info added on...
  3. H

    Listing Numbers in between a range to a separate column

    Hello, Looking for a VBA script that would extract numbers in a range to a separate column. Attaching a screen-shot of various possibilities of ranges. Below is an explanation of diff set of groupings that would like expanded into individual numbers. \+1234567891[01234567] - Anything in...
  4. U

    VBA Powerpoint to Excel

    Hello Excel Gurus, I'm trying to link my excel tabs sheets to a powerpoint template. However, whenever I run the macro, the charts overlaps in the slides. Is there any way where I can set the slide view to 100%? Whenever I open the PPT, its always set to 115% - not pretty sure if this is the...
  5. T

    VBA code to loop and extract data

    I have another sheet were a user selects a name. Is it possible to have a macro loop through the data and return the event type listed below the employee along with the date. This is just a snippet of the data. An employee will have multiple event types. I'm not sure if this is even possible...
  6. A

    VBA conditions clashed with one another

    Hi everyone, I have this file that tracks engine status from Sales and Production departments. FYI my file tracks the last 8 days of the month, each Day group has the following column order: Sales, Production, Day #, Status. 1st Sales column is column N 2nd Sales column is column R 3rd Sales...
  7. A

    How can i copy data to new sheets based on cell value

    I have a data sheet where there is presented Name, personal number, email etc. I have around 500 Rows with person data, that needs the data separated in different sheets sorted after names. I have color coded the persons data and the sheets to where their data should go. I have made an vba that...
  8. A

    How do based on cell values, copy data to other sheets so they fit.

    Hi, i want to sort & copy data to different users sheets, there is about 350 accounts, where i need to sort the data and add them into their sheet with Names, numbers addresses etc. so i made the vba create several sheets named after the names on the list. But i have no clue to how i sort on...
  9. F

    Code giving run-time error when called, but not when placed on worksheet.

    The code listed below runs on the worksheet, but gives a Run-time error '424': Object required when called. I called the code, because when placed on the worksheet, it prevented other code from running. I was thinking that if the code was called it would allow the other code to run. Sub...
  10. L

    select a value from dropdown list via EXCEL VBA

    i want to select a value from dropdown list and have tried below code, but can't work. please take a look: <select name="fldcusval" nchange="fnSetBankName();fnSetCurrencyList()fnGetCustomer();;displayDetails (this);">..</selec> code ie.Document.getElementsByName("fldcustval").Foucs...
  11. A

    At a same time refresh all data connections in all open workbooks

    I have multiple workbooks and I want to refresh all data connections in all open workbooks for that I have given try to following vba code <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height...
  12. T

    don't copy sheet with specific name

    how to not copy a sheet with specific name please, thanks!
  13. A

    to get the values from data file to format file, based on sheet name, reference column and date

    I have two excel files, one is file named data and other one is flile named format. The data file has multiple sheet named as "north" ,"south" and "west", each of these sheets have a reference column containing values a, b,c,d,e as values of first column and dates from Nov 4 to Nov 10 as values...
  14. S

    VBA / dll project ideas

    Hi, I have quite a few years experience with VBA and have developed various dashboards and tools using APIs and web scraping etc. I'm looking to further increase my skills and wondered if anyone had any cool project ideas. I really don't mind what it is. I'm particularly interested in getting...
  15. B

    Userform ListBox - Display a Tick if Condition is Met

    Is it possible in a ListBox that has its row source from a spreadsheet that it can display a symbol like a Tick if the value in the row source was the value "YES" for example ? I have a column that will only have the value YES or No and would like to display a Tick or Cross rather than the...
  16. A

    Copy data from worksheet and paste in same worksheet but at different range

    I have some data points that are unique in each sheet and the same unique data points need to pasted as a value in the same worksheet but at different range I have write down following VBA code for copy paste in same sheet Sub EOD() Dim i AsLong For i =4To ThisWorkbook.Worksheets.Count...
  17. A

    Copy data from worksheet and paste in same worksheet but at different range

    I have some data points that are unique in each sheet and the same unique data points need to pasted as a value in the same worksheet but at different range I have write down following VBA code for copy paste in same sheet <code style="margin: 0px; padding: 0px; border: 0px; font-style...
  18. M

    Unprotect copied protected sheets and paste a range as value

    Hi All I have this code below, I'm trying to figure out how i can copy protected sheets and unprotect together with copying a specific range and pasting it as value only. Hoping for a quick response. Thank you! ? Sub CopySheets() Application.ScreenUpdating = False Dim MyFolder As...
  19. K

    UserForm textbox to textbox in sheet

    Hello there, I'm pretty new with VBA and I am trying to make a Userform to add comments to an excel sheet. I have a combo box with initials (of the person making the comment) and a text box where they will write the comment. Now if the person clicks the OK button I want it to start a new line...
  20. J

    Add Totals Column on multiple sheets

    Good day, I have a workbook containing multiple sheets and a 'Summary' sheet. I have a column in the Summary sheet named 'Balance as Per Schedule' and I want to sum the amounts in the 'Total' columns on each sheet by using the ID No as the criteria. Basically there is a column for 'Total' on...

Some videos you may like

This Week's Hot Topics