Hi All,
I am looking for someone to Complete AND FIX the project below. I get a set of data on a daily basis, and would like to write a Macro/VBA to filter and sort it, so that it will be easier report.
So far.. I have the below marco written for the project.
1) Need to format ALL cells, to row height 12.75 , zoom to 75% , and Adjust Columns to Autofit - So I wrote the below in VBA
Sub FORMATTING()
[login to view URL]
[login to view URL] = 12.75
[login to view URL] = 75
[login to view URL]
End Sub
2) I need to delete all ROWS with Purchase Date 60 days from "today's date" so I wrote the below:
Sub DELETEDATES()
lr = Cells([login to view URL], "a").End(xlUp).Row
Range("D4:D" & lr).AutoFilter Field:=1, _
Criteria1:="<" & Date - 60
Range("D4:D" & lr) _
.SpecialCells(xlCellTypeVisible).[login to view URL]
End Sub
3) I need to highlight entire row, with Paid = " Y" so I wrote the below. *Is there anyway to adjust this formula, so that it highlights the whole row, up until the last column with data? How about up until the last column with data + 1 more column?
Sub HIGHLIGHT()
Dim cell As Range
Range(Range("H4"), Range("H4").End(xlDown)).Select
For Each cell In Selection
If cell = " Y" Then [login to view URL] = 6
Next cell
End Sub
***IS THERE ANYWAY TO COMBINE THE MACRO INTO ONE LARGE MACRO? OR IS IT BETTER TO HAVE SEPARATE MACROS FOR EACH FUNCTION.
*Inquiries where I need help*
-Need Macro/VBA to look in Client column, and highlight/bold the row that contains the word "LEO", so if you referring to the file attached, there is also KhanLeo and I would like to have that one picked up too.
-Need Macro/VBA, if first 2 character of the invoice starts with 99, delete the row.
-Need Macro/VBA, if the 6th character of the invoice starts with 9, delete the row.
-Need Macro/VBA to change column J "Days between Purchase Date/ Invoiced Date" to Numbers, as some of them are currently "Numbers Stored as Text"
-Is it also possible to create a Macro/VBA formula, to do the following:
*If client type is in the range of 52000 to 53999 AND has a discount code of FAM2 OR 805P AND Days between purchase date and invoice date is 7, then delete row, if not leave it alone and do nothing.
*If client type is in the range of 58000 to 58999 AND discount code cell is BLANK AND the Days between purchase date and invoice date is 90, then delete row, if not then leave it alone and do nothing.
*If client type is in the range of 58000 to 58999 AND has a discount code of FAM2 OR 805P AND Days between purchase date and invoice date is 30, then delete row, if not leave it alone and do nothing.
Hi, I can do it, please send the file with sample data so I can write a demo for you. What excel version do you use?
Looking forward to hearing you,
Cuong NH