Microsoft Excel Project, Lookups, Macro
Project ID:
468683Project Type:
FixedBudget:
$30-$250 USD
Project Description:
HiI am looking to have a very small project done. I have two spreadsheets titled customer and customer account. The customer account spreadsheet has information we get monthly about our monthly transactions. The number of rows on this spreadsheet changes frequently. While the customer spreadsheet has account information. Both spreadsheets have a column called PK that displays on both of them. a macro that I can use to look in the Customer spreadsheet and if the PK column matches one of the tabs in the customer account spreadsheet it returns not just the PK column A on a different tab but the entire row from the customer account spreadsheet A-X. I need a quick turn around on this Thanks
Skills required:
C Programming, Data Entry, Data Processing, Excel, Visual BasicAdditional Files:
Customer.xls customer account.xls
Public Clarification Board
Awarded Bids
johnsinit
|
johnsinit
From Israel
Offline
|
US English Level 1 (90%, 45th percentile)
General Freelancer Orientation (85%, 95th percentile)
Foundation LimeExchange Member
Foundation EUFreelance.com Member
Accepted
$38
in 1 day
over 2 years ago
Dear NOLA! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.
All Bids ()
svet63
|
svet63
From Bulgaria
Offline
|
General Freelancer Orientation (80%, 90th percentile)
Foundation EUFreelance.com Member
$45
in 0 days
over 2 years ago
VBA developer since 1997. Can do it today. Regards, Svet.
usamacpp
|
usamacpp
From Egypt
Gold Member
Online
|
General Freelancer Orientation (75%, 81st percentile)
Foundation EUFreelance.com Member
$30
in 0 days
over 2 years ago
I can do it now in a few hours.
Wonderer
|
Wonderer
From Belarus
Offline
|
Foundation EUFreelance.com Member
$75
in 1 day
over 2 years ago
Can be quickly done. Thanks, Al
Hello Sir. This is easy project I can deliver ready solution fast and to your satisfaction
oFAZo
|
oFAZo
From India
Offline
|
US English Level 1 (98%, 88th percentile)
Freelancer Orientation (85%, 99th percentile)
SQL Level 1 (83%, 45th percentile)
General Freelancer Orientation (95%, 100th percentile)
Foundation EUFreelance.com Member
$40
in 1 day
over 2 years ago
Exceptional quality & Fast work. Please refer to Profile & PMB for details. Thanks FAZ
SoftSandila
|
SoftSandila
From Pakistan
Gold Member
Offline
|
Foundation Freelancer.co.uk Member
Freelancer Orientation (85%, 99th percentile)
HTML Level 1 (83%, 88th percentile)
Freemarket.com Foundation Merchant
General Freelancer Orientation (90%, 98th percentile)
Foundation LimeExchange Member
Foundation EUFreelance.com Member
$49
in 1 day
over 2 years ago
only $49
Excel expert. already did many macro projects.
can deliver in just few hours after the selection.
awaiting for selection to start work.
Thank you
imran
edatawiz
|
edatawiz
From India
Offline
|
General Freelancer Orientation (80%, 90th percentile)
Foundation EUFreelance.com Member
$30
in 2 days
over 2 years ago
HI -
I can do this for you very quickly. Please check your PM for some questions.
primetechnosoln
|
primetechnosoln
From India
Offline
|
Foundation LimeExchange Member
Foundation EUFreelance.com Member
$70
in 1 day
over 2 years ago
ready to start, can do this one day
Hi,
I will be able to create the macro you need to match the data from the two spreasheets.
Kindly see my historial in GAF related to creation of macros in MS Excel.
Regards,
Monica
please have a look at pm for details
Hello, Thank you for your consideration.
Hi,
Get it done within 1 hour or so.
Kris
neelu7779
|
neelu7779
From India
Offline
|
Foundation Freelancer.co.uk Member
$40
in 2 days
over 2 years ago
hi,
Please check PMB.
Dear Sir
I don't think you need macro for this one. It could be done using a simple formula. And second, I think the explanation is wrong, the monthly data is in "customer.xls" and the account information ... more
Dear Sir
I don't think you need macro for this one. It could be done using a simple formula. And second, I think the explanation is wrong, the monthly data is in "customer.xls" and the account information is in "customer account.xls".
Winata less
crowdata
|
|
crowdata
From Canada
Offline
|
Foundation LimeExchange Member
Foundation EUFreelance.com Member
$30
in 0 days
over 2 years ago
This can be done in the next 2 hours.
Hello, I can help you. Quickly and quality.
Please check PMB for similar sample application. Can be done in no time.
FallWind
|
|
FallWind
From India
Offline
|
Foundation EUFreelance.com Member
$30
in 0 days
over 2 years ago
I can do this project. Regards.
We are expert in creating Macros in Excel and we have done many projects like this. We would require some clarification in the project, once we decided to move on we can discuss those points.
Thanks
OrangeMR
have rich experience in developping similiar software
Give me the go ahead and you will have your solution (macro) in 3 days. Please I would appreciate it if I am sent a text message on this number +2348055229339.
hi,
I am an expert in excel macro, I can do it in a few hours. I am ready to do it.
Please Check PMB
*** satisfaction guaranteed ***
csreddy100
|
|
csreddy100
From India
Offline
|
Foundation LimeExchange Member
Foundation EUFreelance.com Member
$30
in 5 days
over 2 years ago
We have very good knowledge in EXCEL,EXCEL FORMULAE,MACROS.We can do ypour project either in EXCEL,or in ACCESS.We are interested to take up your work at the earliest.
Hi.
I will do this project in one day.
Best Regards.
chandrakant136
|
|
chandrakant136
From India
Offline
|
Foundation EUFreelance.com Member
$150
in 5 days
over 2 years ago
Job will be done in give time limit and with accuracy.
Select me. I will be finish sucessfuly the macro.
i like to do that job
kitanagh
|
|
kitanagh
From Ghana
Offline
|
Foundation LimeExchange Member
Foundation EUFreelance.com Member
$30
in 1 day
over 2 years ago
I pay attention to detail, and you can be assured of good quality work done. Let me know when you need it done, and I'll surely deliver. Thanks.
Picamore
|
|
Picamore
From Canada
Offline
|
Foundation EUFreelance.com Member
$100
in 2 days
over 2 years ago
Until you feel satisfied.
Hi,
it's quite easy and will not take very much time.
I've looked the attached files. Some questions:
1) if we have some data from the column PK in "customer account" file that is absent in PK column in cu... more
Hi,
it's quite easy and will not take very much time.
I've looked the attached files. Some questions:
1) if we have some data from the column PK in "customer account" file that is absent in PK column in customer file - would you like to add it?
Or we look only to the PK column data from the Customer file?
Let's start working.
less
exceluser
|
exceluser
From United Kingdom
Offline
|
Foundation EUFreelance.com Member
$49
in 2 days
over 2 years ago
Estimate of 2 days work due to clarification of your requirements. BCS certificates prove my ability
Hi,
We have read your requirements and can deliver you macro within a day
Nikiprovadia
|
|
Nikiprovadia
From Bulgaria
Offline
|
Foundation EUFreelance.com Member
$30
in 2 days
over 2 years ago
Hello Sir/Madame, I think I'm suitable person to fill up this project.I have a big experience in working with Excel.Please, contact me.
Your required macro will be done in the mentioned period and be tested completely.
Hi I am shakil, Check sample sent through.
Dear Sir, what I can see is you want a macro to crawl through all worksheets on file customer account filling the rows with customer data using a key in column A - "PK". It can be ready by tomorrow.
i can begin now
i am an excel expert
thanks