vba macro

So I need a bit of help with an existing macro. I need to split a workbook's multiple worksheets into multiple files (not based on worksheet name). The project: It deals with very sensitive HR/performance data, and I need to send 1000s of employees' data to their individual managers (about 100...

Option Explicit Sub InsertRowBelowNegativeEntriesInFGHI() Dim lLastColRow As Long Dim lLastRow As Long Dim lColIndex As Long Dim lRowIndex As Long Dim bInsert As Boolean Dim bIsBalanceRow As Boolean Dim...

Hello Experts, I need help with a macro that cycles through one column ("Week-Ending Date") of a formatted table that users are updating each week to find unique values (e.g. "6/25/2016 or "7/9/2016") in that column and then highlighting the first row with that unique value up and through...

Hi, I have a sheet containing duplicate employee ID in column B. So what I would like to do next is to delete those duplicate entries (by row) and will just retain the last entry in the sheet. Row Column A Column B Column C Column D 1 PHMBIA Maricel A. Chemical...

Hi Gurus, I want to find the cells with dates using vba macro. I'm hoping to find dates under column Q which contains dates formatted as "m/d/yyyy hh:mm" and a text "---". After that, the return value is in column B which I plan to use offset function. I just also want to add that I'm a...

Hello, I want to select the rows based on the date and past it in other sheet. for ex: lets take today's date 24/06/2016. So now select the rows that is < 8 days and >8 days from 24/06/2016 on wards and paste it in the other sheet. Below is pic. Thank You! Regards Wither

Programing a procedure which opens a .ppt template and copies in charts and tables from Excel for multiple generation of presentations (a Do Loop) for a new .ppt per record on a specific worksheet. What appears to be an every-other-time/record event, the pasting of an Excel chart is interrupted...

I am doing data entry in the excel sheet starting from column A to AB, I want a macro that if in the F column I put a text "C" then when i will press enter then the cell will move to K column then with next enter Q column then with next enter to W column in same row. I got a piece of code...

I have a excel sheet where there are many Balance rows I want a macro that if in any Balance row there are negative value in FGHI column followed by any positive value a new row will be insert above the balance row.

I have a excel sheet where there are many Balance rows. In Column A there are Demand Collection Balance Rows, where Balance = Demand - Collection. So there are multiple Balance Rows are there in that sheet. Column FGHIJ are inter related. I want a macro that if in any Balance row there are...

I want to copy data from a web site in a excel sheet, in the website I need to click a list box then a click then a page will load & from that page I need to copy certian things & paste in a excel sheet then back to previous page again click the next number from the list box and so on.... can I...

I am using the following code to calculate the Balance from the data, Balance = Demand - collection <code> lRowLastDemand = lRow ElseIf bFoundCollection Then bFoundCollection = False If c.Value <> "BALANCE" Then c.EntireRow.Insert lRowLast = lRowLast + 1 Set c =...

Off to a good start but need some help finishing this... Here's the situation: I am working between two workbooks; WB1 is used for the collection of data and although the workbook will have different data, the cells the data is entered in will remain constant, on WB2 I have 2 WSs (FPPI-Routed...

Hi All, I have tried various ways and still finding problems so I hope you are able to assist. I currently have a new macro which pulls a text file. In turn adds various points to a leading track. The end points may have 1/2/3/4 different end points and inn turn the leading tracks may also...

I have a macro that sums column C with varying numbers of rows. It works great with no problems. I would like to also have the macro take that sum and divide it by the value in cell M and paste the new value in cell D. My current formula is below. Const SourceRange = "C" Dim NumRange As Range...

I use this VBA in a macro. Excel2016.: Option Explicit Sub LastRowWithData() Dim lastRow As Long lastRow = ActiveSheet.Range("E" & Rows.Count).End(xlUp).Row Range("Control!B2") = lastRow Range("J1") = lastRow End Sub The debugger indicates that the red highlighted row is the problem. I can't...

Hi, I've got a big file broken down into manageable sizes - about 4500 rows each. Each Unique Identity may have 1 to maybe 10/15 rows (varies). Mostly, each row contains one column of non-blank data (some have more than one cell that is non-blank). I want to merge/roll up these rows into 1...

Hi all, Thanks in advance for your help. I found a lot of nice tips and tricks on this forum! Situation: I have created a dashboard based on a pivot table. I use different macros to filter data and change the dashboard. I have made different rectangles where I assign macros to. I have two...

The macro goes through 89 different items but rather than me type in 89 in VBA how can I link the 89 part to a cell (which is a name range called CounterW) which is doing a countif function and will change regularly? thanks in advance x = 1 To 89 Sheets("Summary").Select Range("e6") = x...

I have 3 sheets Sheet1 name - Demand Sheet2 name - Collection Sheet3 Name - Balance Demand means A user is having some Due for a particular product Collection means the amount collected from that person for that product Balance means the person is due the rest amount i.e Balance = Demand -...