Hi everyone,
I have no luck searching the internet looking how to count the number of colored cells based on conditional formatting.
Please see attached file for better understanding what I wanted to achieve.
On column O, i wanted to count the number of red cells (overdue date) on its adjacent...
I am thinking of adding this code. How do I loop (copied formula to "adjust") so when a new row is inserted, the formulas above them get copied?
Range("L2:P2").Copy Range("L3:P3")
Hello Ajesh!
Yes there are no exclusions on that code because I don't know how to do that in VBA. I'm pasting to a normal range (not a table). I have uploaded the file for reference.
I'm relatively inexperienced at VBA code and was hoping someone could help.
The code below copies data from range B2:AC2 from the "Release" sheet and inserts a new row and pastes the data to the "Record" sheet. Problem is I now want to exclude L2: P2 so when it pastes to the new row inserted, it...
OMG! bosco_yip, it worked like a charm! But how do i start from row 3 all the way down? I am getting error if the cells from the columns are empty. The amount of non-blank cells from those columns may vary daily so I must define the range to infinity.
PS: The blank cells contain formulas that...
Thanks for the insight Eloise but this is not just merely cosmetics since I am dealing with a large file with multiple tabs (daily). Attached is the actual file. I'm trying to add hours rendered (elapsed time) column on the dashboard which would also capture efficiency by dividing elapsed time...
Hello guys!
Is there any way to get the total elapsed time without having to use helper column D? Data in column B are not sorted and may appear anywhere within the column. A blank cell means there is only 1 order.
Thanks in advance!
Thanks much! But i have a question, is it not possible to terminate the input box after clicking cancel? Why do we have to have another box to cancel it? And for clicking ok with an empty string, can we have a personalized message rather than the default "We found a problem with this formula..."...
Sub NewPage()
Sheets("Master").Visible = True
Sheets("Master").Copy After:=Worksheets(Worksheets.Count)
NewPageName = Format(Date, "mmdd")
ActiveWindow.ActiveSheet.Name = NewPageName
Sheets("Master").Visible = False
Range("B3").Select
End Sub
This code will copy my MASTER sheet, rename it to...
thanks so much shrivallabha! it worked, however, if i click cancel on the input box, the execution doesn't stop and the whole sheets get deleted except the first two and when i click ok without any input, i want the error message to be personalized like "please input the last amount of sheets to...
userform can be useful but i want a command button where it will delete all sheets except the first two and the last x amount of sheets. The first two sheets are very vital (Dashboard - visible and Master - hidden) and the rest sheets vary (daily tracker). At the end of the month, these sheets...
How do I delete all sheets except the first 2 sheets and the last X amount of sheets? I also want to have a pop-up message asking the user how many last sheets they don't want to get deleted.
Note: 2nd sheet is hidden - so i don't want to delete the first visible, the 2nd (which is hidden) and...
Hi,
I'm just starting to learn VBA. Can you help with the codes I need to use so column L (starting from L3) will auto-calculate (L3-C3) and so on and so forth.
Currently I have codes on my worksheet to automatically create timestamps based on data entered on columns B and J and column L...
Hi,
I would like Excel to measure the amount of time(in minutes) elapsed when data is entered between two cells( Columns B and E). I don't want previous time to update especially when they update values on columns B or anything that prevents them from manipulating the data. I just need to track...