Đang Thực Hiện

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 thêm: excel 16, simple macro, numeric, macro, 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, excel product stock system, macro report

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

Mã Dự Án: #1067399

Đã 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 Giá)
6.4
mrbrave

Available now to start off..

£30 GBP trong 0 ngày
(123 Đánh Giá)
5.9
vserv

Pls see your messages. Thanks

£20 GBP trong 1 ngày
(60 Đánh Giá)
5.8
nagybatonyi

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

£25 GBP trong 1 ngày
(53 Đánh Giá)
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 Giá)
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 Giá)
5.2
northwolves

Ready to start,see PMB please.

£22 GBP trong 0 ngày
(41 Đánh Giá)
4.9
chriskerpini

Please check PMB.

£20 GBP trong 1 ngày
(20 Đánh Giá)
4.8
telemarketing555

Hi, please check your PM. Thank you.

£35 GBP trong 0 ngày
(22 Đánh Giá)
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 Giá)
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 Giá)
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 Giá)
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 Giá)
3.8
muhmuuh

Hello! Please check PM for details. Thanks

£30 GBP trong 1 ngày
(8 Đánh Giá)
3.6
OniNeko

I already have scripting that can do this!

£20 GBP trong 0 ngày
(1 Đánh Giá)
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 Giá)
3.2
milledl

Please see PM. Looking forward to it! Dave

£30 GBP trong 1 ngày
(3 Đánh Giá)
2.4
TheTaj

check pmb thanks

£20 GBP trong 1 ngày
(2 Đánh Giá)
2.3
Sree1975

hi i can do this job. please give me.

£30 GBP trong 2 ngày
(2 Đánh Giá)
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 Giá)
2.1