vba macro

  1. D

    Date is being changed when workbook is being exported

    Hi, I am currently working on a VBA code that has a specific button to export a copy of the worksheet in question. The table has a column for date and time together in this format: dd-mm-yyyy hh:mm AM/PM;@ The import of the data into this worksheet works fine, however when exporting the...
  2. A

    URL looping is not going well and scraping data is piling up

    Good evening friends, everyone I have a worksheet where the URL List is filled in range A and the URL worksheet has been prepared, I want to retrieve the data for Price and Stock. I want all the data in the Worksheet List I can take for Price and stock only. Errors occur when running the...
  3. M

    How to create generic Macro (all variables)

    I need a generic macro that can take in three inputs: Yr grey (from droplist choice of 3 or more), Line items rows purple box (droplist- eg. Sales, Costs, Units) and Percentage - yellow box which contains the percentage to increase or decrease the line items the results replace the row. I am...
  4. K

    From excel timesheet create a import file csv

    Hi, really hoping for some help please. I have a excel timesheet which details hours worked against different pay elements. For example , columns would be ... Ee no., name, no.of hrs, hourly rate, total pay. Header above theses columns would be PE Basic pay( 88). Following to the right , the...
  5. J

    Excel macro to change the values of a sheet based on 2 different sheets

    I have 3 sheets in excel, Sheet1, Shee2 and Base price In sheet1 I have values in Column A and Column B, Column A is the Product Code and Column B is the values, In column A there are multiple product codes and multiple values are assigned to it. In Sheet 2 also I have values in Column A...
  6. B

    VBA Macro will copy/paste names to sheets

    Hello everyone! I have a VBA question on how to create a macro that will copy/paste names to specific worksheets if conditions are met. I get new data each month so this will be very helpful for me if it's automated. The data is 91 rows (90 reports) so this is just an example. The idea is that...
  7. M

    Macro

    Hello everyone ,I am new to this forum , And I am trying to automate a task which I perform daily by inputting data from excel to main frame t3270 ,it consumes me 2 hours every day schedule ,any macro code to help me out ,it pick up only mobile numbers from excel each rows and inputs in the...
  8. J

    IsDate macro missing some blank cells

    For some reason, IsDate is missing some blank cells and I can't seem to resolve the problem. The blank cells have been thoroughly checked with IsBlank and IsEmpty and show as blank cells. What happens is, the blank cells are then subtracted from a date and consistently return a -43524...
  9. C

    VBA if column B contains "New" copy only specific cells to another sheet

    So I have a heavily VBA and Macro laden workbook that I have continued to work on to simplify and streamline data tasks, as well as keeping the others from struggling in my absence. What I am trying to do is if column B contains text "New" then copy ONLY cells D:F, I, O:P and paste them to the...
  10. V

    VBA Set .Worksheets name wildcard

    Hi all, I found a great macro to combine different works sheets but my issues is that the sheet name change from file to file. How could I change this line Set wksSrc = wbkSrc.Worksheets("data") to something like this Set wksSrc = wbkSrc.Worksheets("*") The link to the macro is here...
  11. R

    VBA macro to copy/paste data from sheet to another

    so let's say I have to worksheets, Sheet1 and Sheet2. I would like to search for a column header in Sheet2, and if found, copy all the data in that column (except for the header) and paste it into a particular column in Sheet1 beginning from row 2 (to account for the header). I would then...
  12. A

    Transferring data using a macro button but skipping out columns containing formulas in the destination

    Hello, I have created a front-end user form designed to transfer data entered, across to a worksheet using a macro button. This works successfully, however a number of the columns in the destination worksheet include formulas. When the data is transferred, the formulas are wiped and the data is...
  13. R

    Save Range Sheet 1 as filename for closed excel worksheet

    I am new to macros and I want to do something I am sure someone else would like to do. I have two spreadsheets. Spreadsheet 1 is closed and perfected to the way I need it. Second Spreadsheet 2 is a spreadsheet of 60 names that I want to rename with Spreadsheet 1 Names. Below is the vba I am...
  14. K

    VBA macro HELP- Column to rows

    Hi there! I am in need of some VBA macro magic here. I have a stream of data that represents energy usage on an hourly basis. It is in one column currently that goes Day 1 HE 1, Day 1 HE 2, etc. I would like to have a macro that takes the 24 hours and transposes it into a table that has the...
  15. L

    VBA MACRO-Copy BLANK/EMPTY Cell and PASTE SPECIAL ADD to an entire COLUMN by COLUMN HEADER NAME

    Hi All, I'm trying write a MACRO to do the following (As a small porti of a large MACRO project): (Consider that I will have a varying number of COLUMNS and ROWS each time the report is generated, so, the columns needed manipulated will be different each time. This is why I need to use Header...
  16. L

    Advance Custom Cell formatting

    I want to validate cell with the following text formats Case-1: -1.50-0.25x180 or +1.50+0.00x180 Case-2: -1.50-0.25x180 ADD+1.00 BF or +1.50+0.00x180 ADD+1.00 BF Using (+#0.00,-#0.00) works fine for +1.50 or -1.50 or +0.00 or -0.00 I am using the following format for the entitre text...
  17. B

    Macro transposing column to rows in step of 15 rows

    I have a table with columns A-F and several thousand rows. I want to be able to easily transpose the the first rows (2-16) in column E as headings on a new page. From the F Column i alse need to transpose the data in row 2-16 to the new page. i need to do this for the entire F column. Every 15...
  18. M

    VBA Macro - Transpose with conditions

    So I need your help! Firstly I am a student and don't really know much about VBA, because my teacher skipped those classes, whatever... I have a table with a long number of rows and data in columns.I wanna transpose them to rows and deleting duplicates, so it's better to review the data. I'm...
  19. B

    VBA Macro to read text file and assign values to lines

    Hi all, I am hoping someone can help me make my excel spreadsheet read a text file line by line and assign variables to those lines so they can be referenced further down the marco to hyperlink. First I would like the macro to read a .txt file line by line and give say line 1 = certain text...
  20. V

    Excel workbook crashing when trying to open with vba Code

    I was trying to open a excel workbook with VBA macro code Workbooks.Open("Filepath\Filename.xlsm"). It is crashing as soon as it is opened. When I am trying to open manually then it is not crashing. Any idea or suggestions please. Looking for help!

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top