Search:

Type: Posts; User: jayped; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Re: Update columns with summation based on criteria in multiple sheets

    Thank you. You have been a great help.
  2. Re: Update columns with summation based on criteria in multiple sheets

    Thank you. Can I put a range in there like C4 to O240?
  3. Re: Update columns with summation based on criteria in multiple sheets

    HI. I have one request for a change to the macro above "Update_Columns".

    If I want to run the macro again based on new information I don't want the calculations already calculated by the macro to...
  4. Replies
    18
    Views
    271

    Re: Add Totals Column on multiple sheets

    That works. Thank you for your help.
  5. Replies
    18
    Views
    271

    Re: Add Totals Column on multiple sheets

    Thank you for your help.

    In response to your question: if the ID of a sheet does not exist in the Summary sheet, what to do? - Normally this should not happen and i can't think of what can be...
  6. Replies
    18
    Views
    271

    Re: Add Totals Column on multiple sheets

    Good day,

    I have a workbook containing 5 sheets and a "summary" sheet.

    In each sheet (including Summary) "Name" and "ID No." are contained in columns A and B respectively, headers are in row 5...
  7. Replies
    18
    Views
    271

    Re: Add Totals Column on multiple sheets

    Good day,

    I have a workbook containing 6 sheets and a "summary" sheet.

    In each sheet (including Summary) "Name" and "ID No." are contained in columns A and B respectively, headers are in row 5...
  8. Replies
    18
    Views
    271

    Re: Add Totals Column on multiple sheets

    "Total"
  9. Replies
    18
    Views
    271

    Re: Add Totals Column on multiple sheets

    The header is on line 5.
  10. Replies
    18
    Views
    271

    Re: Add Totals Column on multiple sheets

    Ok. In the sheet below 'Total' is column DG

    'Credit Card'

    <tbody>
    Name
    ID No.
    Total
  11. Replies
    18
    Views
    271

    Re: Add Totals Column on multiple sheets

    What should I change the "C" to if the column letter for totals will vary across the workbook?
  12. Replies
    18
    Views
    271

    Re: Add Totals Column on multiple sheets

    Thank you for your reply.

    What if the Total column in each sheet is not in the same column?
  13. Replies
    18
    Views
    271

    Add Totals Column on multiple sheets

    Good day,

    I have a workbook containing multiple sheets and a 'Summary' sheet. I have a column in the Summary sheet named 'Balance as Per Schedule' and I want to sum the amounts in the 'Total'...
  14. Re: Update columns with summation based on criteria in multiple sheets

    Hi again,

    I have multiple sheets again and a 'Summary' sheet. I have a column in the Summary sheet named 'Balance as Per Schedule' and I want to sum the amounts in the 'Total' columns on each...
  15. Re: Update columns with summation based on criteria in multiple sheets

    This is great. Thank you!
  16. Re: Update columns with summation based on criteria in multiple sheets

    I have a Summary Sheet with a list of names (In which column? - A) and ID numbers (In which column? - B) vertically and each month of the year horizontally (In which row? - 3) as columns - e.g Jul...
  17. Update columns with summation based on criteria in multiple sheets

    Hello,

    I'm not sure if this is possible and I have limited knowledge of macros. Here is what I want to achieve:

    I have a Summary Sheet with a list of names and ID numbers vertically and each...
  18. Can Microsoft Access improve efficiency for the task described? Advice needed

    Hello

    I am trying to cut down on the amount of time spent on a very manual task which is performed on a monthly basis using Excel. The account is a receivables type account and it starts off by...
  19. Re: Update column in worksheet based on criteria with data from another worksheet

    That worked. Thank you very much !
  20. Re: Update column in worksheet based on criteria with data from another worksheet

    Also, can you provide something similar for a single worksheet if i had the same 2 worksheets in one side by side?
  21. Re: Update column in worksheet based on criteria with data from another worksheet

    Thank you for your help!

    Just one problem which I think lies at "If Not f Is Nothing" - I don't want dates that may have been entered previously to be deleted when I run the macro because the...
  22. Update column in worksheet based on criteria with data from another worksheet

    Hi there,

    I'd like help creating a macro that allows me to essentially copy and paste information from one worksheet to another based on criteria that will save a great amount of time were it...
  23. Re: Multiple criteria one range using SUMIFS, EOMONTH and blank cells

    Perfect. Thank you!
  24. Re: Multiple criteria one range using SUMIFS, EOMONTH and blank cells

    Thank you. It has worked so far. However, I need another criteria in the formula - that is Data!B3:19="W". How can I incorporate this into the formula? What I have below isn't working. It's including...
  25. Re: Multiple criteria one range using SUMIFS, EOMONTH and blank cells

    What if a date hasn't been entered and the cell is left blank. I'd like the corresponding F row to be included in the sum total as well.
Results 1 to 25 of 31
Page 1 of 2 1 2