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.
58 freelance font une offre moyenne de £37 pour ce travail
Hello, Excel VBA / Macro expert here. I've done similar projects. Please check PM for details. Thanks!
Hi I am an expert in Excel and VBA Programming in Excel. I have 5 years of experience working in this field. I have experience in Excel Designing, Excel VBA Programming, Providing Business Solutions in Excel and Crea Plus
10 minutes to write the code, some time to wait for the code to be executed. We'll be happy to help here.
Driven American worker prepared to meet the stated requirements in the most efficient and effective manner.
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
Hi kolovai, hope you're well! I've attached a limited but working prototype of what you're after. If this works for you, I'd be happy to provide you with a fully functioning spreadsheet in no time at all! Please check Plus
Hi, I am available immediately to work on your project. Rest assured, if you work with me once, you will come back to me for further work as has been the trend with other employers. Hope to get a positive respon Plus