hey guys!, so i was having trouble figuring out a formula in vba which copies a whole row to a different sheet.
for example, I have a list of names and data in a sheet called "data" what I want it to do is
1.) check the names in column 4 against data in column 4 of a different sheet called...
I've been having a problem with creating mail sending macro from my report using MS Office 2010.
I have come up with an idea to put header of the report in separate sheet “buffer” and then create a macro which will copy row’s range underneath it and then send it all in msg body...
Hello, I am looking for macro to copy and paste the unique values in one cell to below cells till next new value found. Plz help on this Thank you
Here is the example:
Output Should be.
I wanted to know if it was possible for me to be able to copy a whole row into a different sheet based on a column value. For example, if B6 = CLOSE, the whole row would be coppied to the sheet name CLOSE. If B6 = OCCUPIED it would be copied to sheet name OCCUPIED. I also need if W7 = to...
Currently, I am running the marco below:
Dim ColHead As String
Dim ColHeadCell As Range
Dim iCol As Integer
Dim iRow As Long 'row index on Fan Data sheet
Dim lRow As Integer 'row index on individual destination sheet
Dim Dsheet As Worksheet 'destination worksheet
Dim Fsheet As...
I am in the shipping industry and often have shipments from not so popular places. I am looking for a way that excel will identify the status as "active", recognize the origin city/state and create 3-5 rows with other predetermined city/states that I have placed on another spreadsheet. On the...
Hoping someone can help with this complicated Macros. I need to Macro help - copy row, split data into multiple rows to create multiple entires for each row.
I need to create a new row that copies model, type and size data and splits color code and quantity into separate rows.
This is the...
basically, I have a main data dump sheet named ContestReport. I'd like to create sheets based on Culumn B (minus the header) and then copy the row to the appropriate sheet based on the value of B. This is correctly creating the sheets, but I'm running into an error with the copying and I am...