How-tos - Sharing Tips and Tutorials for Microsoft Office
Here we share the tips and tricks we know about Microsoft Office. It's sharing all those things that we learn and experience along the way of developing Office add-ins and using Microsoft Office.
Latest Articles
- Use formula or defined function to auto fill text based on the cell filled color in Excel
- Quickly create a positive negative bar chart in Excel
- How to split the total payment across months in Excel?
- Generate random number with the given specific length in Excel
- Compare two columns and add missing values in Excel
- How to merge two or more tables into one based on key columns?
- How to sum unique values based on criteria in Excel?
- How to filter multiple values in only one column in Excel?
- How to return multiple matching values based on one or multiple criteria in Excel?
- How to count the number of unique and distinct values from a list of column?
To insert the page break but skip the first 20 rows, you just need to change one parameter as below code:
Sub insertpagebreaks()
'updateby Extendoffice
Dim I As Long, J As Long
J = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row
For I = J To 21 Step -1
If Range("A" & I).Value <> Range("A" & I - 1).Value Then
ActiveSheet.HPageBreaks.Add Before:=Range("A" & I)
End If
Next I
End Sub
Please try, thank you!
To use the cell references instead of the specific text value, you just need to apply the below array formula:
=SUM(SUMIF(A2:A10,E1:E2,B2:B10))
After entering this formula, please press Ctrl + Shift + Enter keys together to get the result.
To split the data into multiple separate workbooks based on the column value, the code in the following article may help you:
https://www.datanumen.com/blogs/2-fast-means-to-split-an-excel-worksheets-contents-into-multiple-workbooks-based-on-a-specific-column/
Please try it, thank you!
when i choose something on list and send file to my colleague, then when he open file and want to check my list then list has cleared and cell "ListBoxOutput" was cleared too.
help please :)
I deleted it, but If I try to create it again the same error msg appears, my only guess is that I set the time as 0.5 and in the code, so no idea how to modify it now.
Thanks Again for your help.
Can you suggest ?