Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. "Text Box" to enter an answer, and will highlight when matches

    Is it possible to have a spreadsheet, whereby in cells B3:B22 (for example) you have "Hidden" answers, and in A1 you have a text box, you put an answer in, and press enter. If it matches, then it...
  2. Upon Saving Workbook, Reset Filters in Shared Workbook

    I have the below code which will automatically reset filters when saved.
    However, I need this to operate in a Shared Workbook.

    How can I get the filters to reset when the workbook is saved, in a...
  3. Replies
    5
    Views
    155

    Re: Conditional Format

    These are purely column headers with the dates of the month. Effectively they will be 01/04/19 01/05/19 01/06/19 etc
  4. Replies
    5
    Views
    155

    Conditional Format

    I know this should be simple, but my head won't work this out!
    In Row 1 I have months
    In Column A I have dates of work started
    What I need is conditional format to "grey out" the cell if the date...
  5. Replies
    7
    Views
    202

    Re: PIVOT Count Only " - " in table

    Yes, please, thank you :)
  6. Replies
    7
    Views
    202

    Re: PIVOT Count Only " - " in table

    so I want to create a Pivot with Names in the rows, and the categories as columns



    Name
    Contacted
    Appointment
    Sale
  7. Replies
    7
    Views
    202

    Re: PIVOT Count Only " - " in table

    sss
  8. Replies
    7
    Views
    202

    PIVOT Count Only " - " in table

    Is there anyway of creating a Pivot to count the number of occurrences of "-" when the columns and rows match?

    I know I can do this by INDEX MATCH MATCH (or similar) but would prefer it in a...
  9. Re: Highlight indivudual cells in ROW if same value

    Thank you that works perfectly
  10. Highlight indivudual cells in ROW if same value

    Is it possible to highlight duplicate cells in ROWS only whereby any text or numeric value is highlighted?

    So in the below table

    Row 1 - nothing highlighted
    Row 2 - Cat highlighted
    Row 3 =...
  11. Return maths anser whereby numbers in A and C and symbol in B

    Is it possible to have Excel do an equation whereby, in Column A you have a number, Column B you have a +, -, *, / etc and in Column C you have another number. I have tried a simple =A1&B1&C1 etc but...
  12. Re: Create Report(?) to report on rows with empty cells

    Thank you so much for all this and being very patient with me,- sorry for all the confusion. Ironically, it has helped me understand the code more though having seen certain bits run, and then the...
  13. Re: Create Report(?) to report on rows with empty cells

    REPORT TAB)

    External REFERENCE

    <tbody>
    External Reference

    Analyst

    (Blank 1)
  14. Re: Create Report(?) to report on rows with empty cells

    Hi DanteAmor

    Firstly, thank you for all your help so far. The code is running "perfectly", ie is is bringing up the column headers for anything that is empty.

    So for the columns listed (Columns...
  15. Re: Create Report(?) to report on rows with empty cells

    Excellent - that does the job, just I need it to only do Columns A through to K, and Columns R, S, T, U, V, W, X, Y, X, AA, AB, AE, AF, AK. AL. AM. AN

    Is it (as an afterthought) possible to...
  16. Re: Create Report(?) to report on rows with empty cells

    1234 - has been fully filled out so the Lookup (renamed Report) should not return anything

    1235 - In Data Tab all fields except "Type" and "Price" have been...
  17. Re: Create Report(?) to report on rows with empty cells

    Ah. okay thank you. I have done that and it is populating data (running when in lookup tab) - however, it just seems to be a carbon copy of my data sheet, and copying text from cells that have text...
  18. Re: Create Report(?) to report on rows with empty cells

    Hi There

    Thank you for this, although I am still confused.

    All my data is in "DATA" tab.
    The tab "LOOKUP" is where I want my results and is currently blank.

    I have run the Macro and it just...
  19. Re: Create Report(?) to report on rows with empty cells

    <tbody>
    (DATA TAB)
  20. Re: Create Report(?) to report on rows with empty cells

    Hi

    Sorry, will try and explain again

    In a separate tab, I need it to look up (run Macro etc) if there is any value in column B (which will be the reference number)
    In this tab, if, for example...
  21. Create Report(?) to report on rows with empty cells

    Is there anyway, if there is a value in a row in Column B, on a separate sheet to create a report (or whatever) that will display Columns A through to L, and then any blank cells from Column R, S, T,...
  22. Re: Conditional Format - Highlight only blank cells in row if empty (Not entire row)

    thank you - works perfectly
  23. Conditional Format - Highlight only blank cells in row if empty (Not entire row)

    In conditional format, if I want to highlight any cell in a row that is blank , IF Column A states "Rejected" (Cells go from A: BG ) how do i do this please?
  24. Replies
    1
    Views
    513

    Reference another field using VBA

    I am trying to develop something in Access when you press a button, it brings up a msgbox (fine) and you enter a reference number.
    This then launches Outlook, and in the subject field enters the...
  25. Re: Post NOW() in column that has header of todays month

    Sorry, please ignore my previous post, this is correct
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4