• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    UserForm putting data in the wrong row

    Works perfectly - thank you so much!
  2. A

    UserForm putting data in the wrong row

    Hi, I have created a UserForm that adds forecasted staff in post figures to specified columns in a spreadsheet and also allows the user to view and edit any existing figures. It identifies the correct row to put the data in by looking at the Job Type that has been selected in the JobListBox...
  3. A

    Adding UserForm data to existing Rows

    Thank you so much - all working now!
  4. A

    Adding UserForm data to existing Rows

    Many thanks - I've got it to work now - somehow! I wondered if you could also help with getting the UserForm to display any existing figures in the textbox, whilst still allowing me to overwrite if I want to? For example, the spreadsheet might have 3.0 in column B for Admin & Clerical Band 1...
  5. A

    Adding UserForm data to existing Rows

    I have a spreadsheet named 'Overview' where cells A4:A129 are already populated with job types (eg Admin & Clerical Band 4, Maintenance Band 2). The remaining columns are for projected Staff in Post figures over a variety of years/months (so Column B may be for Staff in Post in April 2014, C for...
  6. A

    Christmas Trees with Multiple Data

    Hi, I have a data table which shows the number of employees by pay band, and am displaying this in a 'Christmas Tree' type bar graph. (So 0 on the horizontal axis is in the middle of the graph, and the bars are of equal lengths on either side). However, I now need to show this data split by...
  7. A

    Using Wildcards with SUMPRODUCT

    This works perfectly - thank you so much!
  8. A

    Using Wildcards with SUMPRODUCT

    Hi - I've been trying to work this out for ages, and would be grateful for any help - I have a spreadsheet that shows sickness - there are 31 columns for each day of the month, and if someone is off sick, an 'S' is entered in the column for the corresponding day. I have a formula that works...
Back
Top