excel-vba

  1. S

    Update multiple pivot tables to the last row of data.

    I have multiple pivot tables on 5 sheets named in the code. Data source for all of them is "CUIC data", which i update daily. I want to change the data source and refresh all the pivot tables in all of my worksheets. The code i have works for one sheet, but i dont know how to get it done for...
  2. G

    Trying to fetch Youtube Trending videos name and links using Excel VBA

    I'm trying to fetch Youtube Trending videos into excel sheet with Title and video links. But my code is not working. I do not know whether there is something wrong with my code or the trending page. This is code from where i am trying to video the data VIDEO TITLE When i run the code. It...
  3. D

    VBA - ActiveSheet.ShowAllData works differently on 2 machines

    Guys, I have some macro that filters all the data (250 rows) by one column, then deletes the data that is hidden after filtering. Next step is unfiltering whole sheet using ActiveSheet.ShowAllData. What's strange, on my machine after unfiltering my used range seems to be 200 rows (50 rows...
  4. D

    Print button

    So I created some code that will allow a user to enter multiple pages of data and then just click a print button to click the number of pages of data he has entered. However we are running into a problem where by if a user enters 200 lines of data, then deletes the last 25 lines, it is still...
  5. B

    Creating a loop using a list of values with Excel Macro/VBA

    I have a list of values in cells A1:A10. I want to create a macro so that cell B1 will first contain the first value in the list, then the second value replace it, then the third, and so on. Once the entire list is run through, it should loop back to the first value again. The same...
  6. H

    Automating Manual Date Changes recorded on another sheet.

    I have two sheets on the first sheet, Column A have the project name, I have Columns K, L, U where I have dates that change on a weekly basis. On Sheet two I have same thing starting with A27, I have the same project names, however on F27, G27 and H27 where I manually enter the historical...
  7. H

    Keeping Records of Values in Different Sheet

    I have two sheets, sheet1 and sheet2. On Sheet1, Column A have the project names and columns K, L and U have dates that are updated on a weekly basis and just consist of dates. K column dates are entered manually, L column have conditional formula basically adds x amount of days depending on the...
  8. A

    Excel-VBA macro to format inconsistent text strings

    It seems to be a huge challenge for Excel VBA to format inconsistent text strings and so I am looking for a solution to format the following table: The table may contain hundreads of rows that have to be manually checked and so it is important to make it as readable as possible...
  9. T

    Excel VBA - Return to the sheet the Macro was called from

    Hi All I have a problem with my code. I need to call on a .csv file, format it, select a specific dynamic range and paste it in the sheet the macro was called from. I managed most of the above, however, i can't get it back to the sheet the macro was called from. I have tried multiple options...
  10. xlhelp15

    To sum based on the condition

    Hello All, Kindly help me for the below query which I need in the way of Excel-VBA. Here column A - is the serial number and I need to sum the values of Column C (56+44.01+33.20 = 133.21) and provide the value in Column D in row 1. Likewise, it needs to sum automatically for the Serial numbers...
  11. K

    Displaying MsgBox when range of cells have not a specific length

    I have a program in which a label is scanned and that value goes into a cell, but for security reasons, it's necessary to check that the length of this is always the same (for example: 8, label=12345-78) the string has a "-" in it. What I want the program to do is that, when the scanned label...
  12. J

    EXcel VBA Trim

    Hi, I'm trying to Trim visible cells after a filter is applied. It all works except for the result. Current Cell Value: "11 05 18 09:06:50: closed by linker #MIT # Updates were made well before SLA expired" Result Required Cell Value: "#MIT # Updates were made well before SLA expired"...
  13. S

    Select non-contiguous cells and post to specific columns on next blank row of sheet

    Hi, I need to select non-contiguous cells in a sheet and paste them to specific columns on the next blank row of another sheet. The code below can copy non-contiguous cells and paste to specific cells on the required sheet, but I cannot adapt to get it to copy to the next blank row. Sub...
  14. F

    How to use datediff properly and take action according to the difference.

    Hope everybody is fine. I am stuck with a problem. what i am trying to do is subtract dates of column C from column AQ dates. the logic is if aq - c <= 20 then copy entire row to sheet1 else copy entire row to sheet2. column c contains empty cells it should automatically go to sheet 2 right...
  15. C

    VBA code to Copy data from one sheet to another

    I am apologizing in advance for my lack of in depth knowledge of macros and VBA as I am new to this. I am trying to add a command button on one sheet to take the data from multiple cell ranges and copy the data over to another sheet in one horizontal row. The data must be copied to the next...
  16. A

    Excel VBA : Vlookup/index match with various value in column and row

    Hi guys, I'm very new in this excel VBA. I have a problem with this table. see the picture This is sheet1 = all the data will be here. this is sheet2: only the selected element will show. the problem is, i don't know how to link/get only the selected value data to show in sheet2. I tried...
  17. S

    Excel/VBA Creating Outlook Appointments from Spreadsheet Data

    I'm trying to create a macro that will create appointments based on task from column B. For some reason, my code to create appointments is creating each item in the subfolder twice. Also, I'm trying to get the appointment date to be column F -30 days. Ultimately I would like to have this macro...
  18. S

    VBA Excel Setting Outlook Appointments From Spreadsheet Data

    I'm trying to create a Macro to create Outlook appointments based on words in Column B. For some reason, my code to create appointments is creating each item in the subfolder twice. Also, I'm trying to get the appointment date to be column F -30 days. I tried <code style="margin: 0px; padding...
  19. S

    Inserting a Batch Changes the Formatting of the Cells Below?

    Now, I've never been accused of being the smartest guy in the room, so I apologize if this is a simple and easy solution, but here goes. Currently, we have a template that allows users to operate within a batch of specified sheets, with a pre-generated number of line items that they can add or...
  20. K

    Having a tabstrip open only when called by a textbox

    Hi, I'm new to the forum and I would like to ask a question regarding a problem that I'm having with a userform. I have used this page as a way to learn more of excel and solve past doubts. What I'm doing is a userform where I want to ask the number of failures using a textbox, and then each...

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