Annulé

Label Template

Hi,

I am trying to manipulate some address data so that it can efficiently be printed onto labels. I copy and paste it from the source into my excel file. The problem is that the addresses are either 5 or 6 rows each and there is then 9 blank rows between each address. Currently I manually go through the data and delete one of the blank rows below any 6 row addresses. This results in the start of each address being 15 rows apart, and from there I have no issues in getting them printed onto labels nicely.

Therefore my query being, is there a way to get excel to manipulate the data so that I can avoid having to carry out the manual task of deleting rows as this is quite time consuming?

Cheers

Simon

Compétences : Excel

Voir plus : address label template word, microsoft word address label template, address label templates, avery address labels 5160 template, label templates for word, free printable label templates, free printable address label templates, free printable label templates for word, script run mysql query write results csv file, oscommerce record label template, wine label template, free dietary supplement label template, customize civicrm label template smarty, mysql query display results csv file, php query display results table

Concernant l'employeur :
( 1 commentaire ) Burton-On-Trent, United Kingdom

N° du projet : #15179459

Décerné à :

renandurkar

Hi, Yes there is a way to reduce this manual task using Excel Macros as small piece of code, could you please share a sample excel file .I have 4 + yrs of Experience in Automation Testing . Relevant Skills and Experi Plus

18 £ GBP en 1 jour
(1 Commentaire)
0.8

14 freelance ont fait une offre moyenne de 18 £ pour ce travail

P0L

Hello, I’m an Excel expert and I would like to help you automate this process. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm still working on this proposal.

20 £ GBP en 1 jour
(203 Commentaires)
6.8
avinav606lx

Hey Simon, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/word/outlook VBA automation professional having 7+ years of experience Relevant Skills and Experience Next ste Plus

18 £ GBP en 0 jours
(131 Commentaires)
6.3
MohsanEijaz

I am excel expert, I can automate it for you. Relevant Skills and Experience Excel Proposed Milestones £18.5 GBP - d

18 £ GBP en 1 jour
(58 Commentaires)
5.7
bilalmaher053

hi, can i ask you from which website you copy past data in excel? Stay tuned, I'm still working on this proposal.

10 £ GBP en 1 jour
(58 Commentaires)
5.1
riccardopepe

If I understand what is your expected result, I can develop a macro that delete blance spaces automatically. It is an easy task, I can do it in few time. Contact me if you are interested in my offert Relevant Skills a Plus

12 £ GBP en 0 jours
(2 Commentaires)
2.5
20 £ GBP en 1 jour
(3 Commentaires)
2.1
18 £ GBP en 1 jour
(2 Commentaires)
0.6
articreations

My Goal is to producing a High Quality Work that will make my all clients 110% satisfied. I am Interested To do that Your Project. Thanks Arti Relevant Skills and Experience My Goal is to producing a High Quality Wor Plus

18 £ GBP en 0 jours
(0 Commentaires)
0.0
NextTask7

Dear client, Have a nice day. I have look up your requirement that's perfect for me.I will fulfill your all demand perfectly. Relevant Skills and Experience typing,data entry Proposed Milestones £18 GBP - 2 hour . Plus

18 £ GBP en 1 jour
(0 Commentaires)
0.0
GraficxDesigner

Hi Experienced Graphic designer with Creative Touch. Your Label Template will be designed in an EYE CATCHING Style. **Unlimited revisions. **Stipulated time Contact me for my Previous Work! Thanks! Relevant Skills and Plus

30 £ GBP en 1 jour
(0 Commentaires)
0.0
15 £ GBP en 1 jour
(0 Commentaires)
0.0
shahidabro8

A proposal has not yet been provided

23 £ GBP en 2 jours
(0 Commentaires)
0.0
chaitanyananawre

its my pleasure to do that Relevant Skills and Experience i have done some skill course on the same Proposed Milestones £18 GBP - its my first timme

18 £ GBP en 1 jour
(0 Commentaires)
0.0