En cours

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.

Compétences : Excel

Voir plus : 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

Concernant l'employeur :
( 1 commentaire ) Mullion, United Kingdom

N° du projet : #1067399

Décerné à :

koolsidz

Please see PMB

30 £ GBP en 0 jours
(110 Commentaires)
6.0

58 freelance ont fait une offre moyenne de 37 £ pour ce travail

bharanisrihari

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

30 £ GBP en 1 jour
(65 Commentaires)
6.4
mrbrave

Available now to start off..

30 £ GBP en 0 jours
(123 Commentaires)
5.9
vserv

Pls see your messages. Thanks

20 £ GBP en 1 jour
(60 Commentaires)
5.8
nagybatonyi

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

25 £ GBP en 1 jour
(53 Commentaires)
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 Plus

20 £ GBP en 1 jour
(47 Commentaires)
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 en 1 jour
(21 Commentaires)
5.2
northwolves

Ready to start,see PMB please.

22 £ GBP en 0 jours
(41 Commentaires)
4.9
chriskerpini

Please check PMB.

20 £ GBP en 1 jour
(20 Commentaires)
4.8
telemarketing555

Hi, please check your PM. Thank you.

35 £ GBP en 0 jours
(22 Commentaires)
4.4
JRussSingletonII

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

50 £ GBP en 1 jour
(1 Commentaire)
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 en 1 jour
(25 Commentaires)
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 en 1 jour
(10 Commentaires)
3.9
muthumuni

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

33 £ GBP en 0 jours
(7 Commentaires)
3.8
muhmuuh

Hello! Please check PM for details. Thanks

30 £ GBP en 1 jour
(8 Commentaires)
3.6
OniNeko

I already have scripting that can do this!

20 £ GBP en 0 jours
(1 Commentaire)
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 Plus

20 £ GBP en 0 jours
(5 Commentaires)
3.2
milledl

Please see PM. Looking forward to it! Dave

30 £ GBP en 1 jour
(3 Commentaires)
2.4
TheTaj

check pmb thanks

20 £ GBP en 1 jour
(2 Commentaires)
2.3
Sree1975

hi i can do this job. please give me.

30 £ GBP en 2 jours
(2 Commentaires)
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 Plus

34 £ GBP en 1 jour
(1 Commentaire)
2.1