onwards

Hi all, I would like to record when data is added in my excel file. Tricky thing is that it has to start from row 548 and onwards. If data is in cell B548 i get the date of when the data is entered in cell A548. How do i do this?

I have data in Col A to Z from row2 onwards on sheet3 I have branch names in Col Y I would like a macro to extract the first two items for each branch (data in Col A:Z) , except BR10 and paste these in row2 onwards on sheet4 Your assistance in this regard is most appreciated

I have data in Col A to Z on Sheet 3 and values in Col O I would a macro to extract data from Col A:Z from row2 onwards the values in Col O add up to approximately 1,000,000 and paste these on Sheet4 from row2 onwards Your assistance in this regard is most appreciated

HI i have created an excel gantt chart. Horizontally on row 5 it has days as dates from row 6 onwards you can put a 1,2 or 3 in a cell and it changes its colour and by doing this you create the sort of Gantt chart. I wanted to if possible find a formula to populate a start and end dateby...

I have data that is in yellow in Col D on sheet6 Where this is the then the item in Col A:D where there are yellow items are to be copied into A2 onwards I have written code to do this, except that it is copying this after the last row containing data I need this amended as I need this...

Hey guys , I got his code to filter the sheet based on cell value in range "X1:AA2" Thanks to PCI and Richard for this code, <code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;">Private Sub Worksheet_Change(ByVal Target As Range) If...

Hi. I have a filter on column "A" with Enable and Disable options via Data validation list. I would like to create a macro that removes all rows flagged "Disable" and place them in rows 200 onwards. So as we disable a row that disable row just goes onto the bottom of the list from row 200...

Hello, can you please help share an excel VBA macro that deletes columns F onwards except the last column. Last Column changes, it can be the column F or AZ.

I would like to filter Col B on all sheets from sheet 6 onwards and to exclude zeroes in the filter It would be appreciated if someone could kindly amend my code below Sub auto_filter_all_sheets() Dim ws As Worksheet Application.ScreenUpdating = False if selection.Rows.count < 3 then...

I have written code to delete rows containing zeroes in Col B from sheet 6 onwards from row 2 onwards When running the macro, it goes into a loop and after a few minutes, I need to shut it down It would be appreciated if someone could kindly assist me Sub Delete_Rows_With_Zeroes()...

I have written a macro to hyperlink to sheet summary on S2 on each sheet from sheet3 onwards, button hyperlink on the active sheet, but in a different cell Kindly amend my code to only hyperlink sheet "summary" on cell S2 from sheet 3 onwards Sub Hyperlink_Summary() For I = 3 To...

I have written code to delete that rows from row 2 onwards from sheet 3 where there ia nothing in COl A when Running the macro I get run time error "For without Next" It would be appreciated if someone could kindly amend my code Sub Delete_Blank_Row() Dim lr As Long, I As Long, R As Long...

I have data in Col F1 to M10 (max) that contains Data I would like a macro or formula to transpose this data in Cell F15 Onwards See Sample data below that needs to be transposed Excel...