En cours

Macro / VBA Needed to Sort Data

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()

[url removed, login to view]

[url removed, login to view] = 12.75

[url removed, login to view] = 75

[url removed, login to view]

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([url removed, login to view], "a").End(xlUp).Row

Range("D4:D" & lr).AutoFilter Field:=1, _

Criteria1:="<" & Date - 60

Range("D4:D" & lr) _

.SpecialCells(xlCellTypeVisible).[url removed, login to view]

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 [url removed, login to view] = 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.

Compétences : Saisie de Données, Traitement de Données, Excel

Voir plus : sort data cell vba macro word, vba macro sort data, vba needed, vba macro filter sort, sort filter data vba macro, sort data vba macro, write get paid today, write and get paid today, vba with, vba fix function, sort sort sort, sort sort, sort function c, paid to do data entry, how to write report format, how to write a written report, how to write a project report, how to write a field report, how to get someone to write a text for you, get someone to write a report for you, get paid to write code, get paid to do data entry, data entry macro, c sort function, vba for word

Concernant l'employeur :
( 0 commentaires ) New York, United States

N° du projet : #1636389

3 freelance ont fait une offre moyenne de 100 $ pour ce travail

vbexcel

Excel / VBA pro - ten years experience.

49 $ USD en 1 jour
(25 Commentaires)
5.3
Nhcuong

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

50 $ USD en 5 jours
(21 Commentaires)
4.9
paolocortes

Excel Data Calculation / Manipulation and Reports Generation Personalized Solutions Can Now Be Yours.

200 $ USD en 5 jours
(0 Commentaires)
0.0