logic flaw

  1. C

    SUMIFS with IF and AND functionality

    Team, the code and formulas i have typed into a few of my cells trying to figure this out has turned into a monster i have lost control of. Details are below. This spreadsheet is used to summarize overtime for everyone on a shift for a single day. Column F gets numbers manually entered. Column...
  2. G

    Excel Macro - If Cell contains a character go to the next row and STOP when Empty

    Hi All, I Am reading and excel sheet using macro. I have Put a condition already if the code come across ani ISNummeric = false Skip it to next line. I wanna know if the code comes a line where Column A B and C is empty Code should end DO Not go Beyond that row. Below is the table as per table...
  3. L

    RunTime err when using now()

    Hi there! I'm trying to make an "Index" page that will update the time a sheet in the workbook was edited. so far the code I put in each worksheet is Private Sub Worksheet_Change(ByVal Target As Excel.Range) Range("A1").Value = Now() End Sub Then I'm calling the Value of A1 in the Index sheet...
  4. T

    Need VBA Logic Help

    I am running Excel 2007 and am trying to create a macro to prevent page breaks in the middle of a row that has merged cells. I have looked high and low for an existing method to no avail. I got to thinking and may have come up with a way that will work for me but I'm not knowledgeable enough...
  5. A

    Help with saving a Final date with logic statement

    I have a workbook that is titled "Results". It has 2 columns that I need help with, a 'status' column (B) and a 'finalized date' column (C) Column B is the 'status' column: Formula: ('[May Database]Summary'!$B$1) The May Database B1 column is a dropdown with options "In Progress" and...
  6. F

    Need Vlookup experts on this string

    Hi, I am looking for some suggestions on why this string isnt working. Background: This code used to be three nested if statements that sepperated people out by thier shift when searching for them using a id (this searched for shift was in a different file, "welder Database") Then I...
  7. T

    New Excel User - Simple Word Count Tracker Help

    Hello all, This is probably a very simple challenge that I've run into, but I am a writer, and I am currently trying to create a spreadsheet that tracks how many words that I type daily. I am currently using Google Docs spreadsheet application online, but have access to Office 2007 on a...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top