Đã hoàn thành

Excel Macro

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.

Kĩ năng: Excel

Xem nhiều hơn: excel 16, simple macro, report from excel, numeric, macro, macro excel, macro + excel, Excel report, Excel Formatting, excel automate, excel 7, automate report excel, excel contains, excel row column, excel macro row, automate excel code, excel delete row, excel report macro, excel column row, macro spreadsheet, stock spreadsheet excel, stock excel, macro report spreadsheet, header large, column row excel

Về Bên Thuê:
( 1 Nhận xét ) Mullion, United Kingdom

ID dự án: #1067399

Được trao cho:

koolsidz

Please see PMB

£30 GBP trong 0 ngày
(110 Đánh Giá)
6.0

58 freelancer đang chào giá trung bình £37 cho công việc này

bharanisrihari

Hello, Excel VBA / Macro expert here. I've done similar projects. Please check PM for details. Thanks!

£30 GBP trong 1 ngày
(65 Nhận xét)
6.4
mrbrave

Available now to start off..

£30 GBP trong 0 ngày
(123 Nhận xét)
5.9
vserv

Pls see your messages. Thanks

£20 GBP trong 1 ngày
(60 Nhận xét)
5.8
nagybatonyi

Such jobs are my daily practice, please see PMB for details! Regards!

£25 GBP trong 1 ngày
(53 Nhận xét)
5.7
FIBIN

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 Thêm

£20 GBP trong 1 ngày
(47 Nhận xét)
5.4
Krusche

10 minutes to write the code, some time to wait for the code to be executed. We'll be happy to help here.

£20 GBP trong 1 ngày
(21 Nhận xét)
5.2
northwolves

Ready to start,see PMB please.

£22 GBP trong 0 ngày
(41 Nhận xét)
4.9
chriskerpini

Please check PMB.

£20 GBP trong 1 ngày
(20 Nhận xét)
4.8
telemarketing555

Hi, please check your PM. Thank you.

£35 GBP trong 0 ngày
(22 Nhận xét)
4.4
JRussSingletonII

Driven American worker prepared to meet the stated requirements in the most efficient and effective manner.

£50 GBP trong 1 ngày
(1 Nhận xét)
4.2
vgrichards

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.

£20 GBP trong 1 ngày
(25 Nhận xét)
4.1
Barns

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

£20 GBP trong 1 ngày
(10 Nhận xét)
3.9
muthumuni

Hi I am happy to do it for you. Kindly see my massage. Thank you.

£33 GBP trong 0 ngày
(7 Nhận xét)
3.8
muhmuuh

Hello! Please check PM for details. Thanks

£30 GBP trong 1 ngày
(8 Nhận xét)
3.6
OniNeko

I already have scripting that can do this!

£20 GBP trong 0 ngày
(1 Nhận xét)
3.4
seanmdale

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 Thêm

£20 GBP trong 0 ngày
(5 Nhận xét)
3.2
milledl

Please see PM. Looking forward to it! Dave

£30 GBP trong 1 ngày
(3 Nhận xét)
2.4
TheTaj

check pmb thanks

£20 GBP trong 1 ngày
(2 Nhận xét)
2.3
Sree1975

hi i can do this job. please give me.

£30 GBP trong 2 ngày
(2 Nhận xét)
2.2
sagnikpal

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 Thêm

£34 GBP trong 1 ngày
(1 Nhận xét)
2.1