I need a Macro for Excel to modify a large Spreadsheet about 4k to 6k rows.
It is a report output from a Stock System that is only available in paged form.
This produces formatting rows, blank rows and repeated Titles etc.
However ALL Products have a Product Code in Column A with mainly Numerics.
Only Product Rows have any Numerics in the A Column.
I require the Title row (7) followed by a consecutive listing of just products.
The recipe is to Delete Rows 1 to 6 then Keep Row 7 because it contains Column Title/header.
Then Delete ALL Rows after Row 7 that do not contain any numeric characters in the A Column.
I may require 3 Column Titles to be renamed after these operations.
This is a relatively simple operation to do manually, but would automate it if the cost is low enough.
Được trao cho:
58 freelancer đang chào giá trung bình £37 cho công việc này
Very Good at Excel 2003-2010 and Excel VBA Macros. What you have described is easy to do. Please allow me to do it. Will ensure everything is as per your requirement.
Hi, We use Excel and VBA macros regularly as part of our data processing projects. I have uploaded a sample Excel file in the private message board for you to check out. Regards, Arijit