insert new lines

  1. T

    exclude options in drop down menu's; insert lines after specific combinations

    Hi guys and girls,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I'm working on a new excel form and have the input ready, now the layout needs some more attention and i'm confused:confused:. I tried to understand the posts on the forum and...
  2. M

    Getting a macro to compare to lines of data.

    I have the ability to populate a report in excel, giving me two months worth of data for employees one after the other - if theres only one line then the employee is new. E.G Excel WorkbookABCDEFGH5Employee No.Employee NameSalaryBasic DaysBasic HoursBasic PayBounty PaymentBounty Payment...
  3. W

    Copy data between w/sheets and insert new line

    Hiya, I have a time sheet database (Excel 2000) that calculates Time In Leiu (TIL) and sends the info to a specific TIL tab for each employee. I need to be able to have the "Staff 1 Hours" worksheet automatically populate a second worksheet ("Staff 1 TIL") with the "week ending date" and the...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    • Replies: 31
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    • Replies: 26
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    • Replies: 24
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    • Replies: 23
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    • Replies: 23
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    • Replies: 23
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top