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
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 Experience
QTP/UFT
Selenium
Excel Macros
Autoit
Proposed Milestones
£18 GBP - Project Delivery
If you could provide me sample excel i will make a macro which you can easily use for your daily work
£18 GBP v 1 dnevu
5,0 (1 ocena)
0,8
0,8
13 freelancerjev je oddalo ponudbo s povprečno vrednostjo £18 GBP za to delo
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.
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 steps:
Lets discuss/validate the complete requirement, budget and I can start to get this done with required quality output.
Lets discuss more online on chat.
Thanks,
Aman
Proposed Milestones
£18 GBP - 1
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 and Experience
Working since 10 years with several IT technologies. Great experience on Excel and how to use advanced functionality
Proposed Milestones
£12 GBP - -
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 Work that will make my all clients 110% satisfied.
I am Interested To do that Your Project.
Thanks
Arti
Proposed Milestones
£18 GBP - d
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
.I have fast and advance skill in excel.I want to start work ASAP
cheer
Mike
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 Experience
graphics
Proposed Milestones
£30 GBP - ,