vba macro

Using VBA or excel but mainly vba I have code that depending on number a entered in will make copies of a chart created in excel. I have a formula in a cell in sheet 1 that equals a value in sheet 2. Same workbook. sheet 1 is show below sheet 2 looks like I am trying to use VBA to keep that...

For example i have a code that will select a cell on the startup of the workbook. i want the user to see which cell is currently activated by highlighting it for 5 seconds in a different color. Is that possible? And if yes, how?

Hi, I have master sheet called "ENTITY" In column "A" if there's a text "NEXT" but in the same Row column "B" is empty. now there may be 3 or 300 or 3000 Rows with same criteria, I want last entry to be found with same criteria & right below that row column "D" ,"G" & "K" must be cleared...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...