Freelancer needed to write excel macro

Closed

Hey everyone,

I have an inventory sheet that I need to update daily. I have several excel files that need to talk to each other. Basically I just need a button that will create an "End File" which is just a file that will tell my sales channel what listings need to be removed. I think it is called a macro but I am not sure that is the correct term. Every day I will download the most up to date Products file and Active Listings file, then I will click the button you are creating.

3 Workbooks / Files:

MasterFile (Contains older inventory items)

Products (Contains up to date inventory items)

ActiveListings (Contains Listings for Products)

Button Actions:

a) Finds Item IDs that ARE in MasterFile but NOT in Products (meaning that they are no longer offered by the supplier). The Item IDs need to be added to a list of Item IDs to remove from ActiveListings (let's call this LIST A), then the row needs to be deleted on the MasterFile

b) Adds all Item IDs that have the stock value as "N" within Products file in LIST A

c) Finds all listing#s within ActiveListings sheet, then Creates an "end file" which is a CSV file that has the listing# of products that are out of stock

Example:

MasterFile File (NOTE - These are the old inventory from the previous day)

TITLE, ITEM ID

Baseball, 001

Basketball, 002

SoccerBall, 003

Football, 004

Products File (NOTE - 001 and 002 are out of stock. 003 is missing, meaning it is discontinued. Row corresponding to 003 needs to be removed from the master file)

TITLE, ITEM ID, IN STOCK?

Baseball, 001, N

Basketball, 002, N

Football, 004, Y

ActiveListings File (NOTE - I currently have 2 active listings for 001 which is out of stock, and 1 listing for 003 which is discontinued)

LISTING ID, ITEM ID

LISTING#1, 001

LISTING#2, 001

LISTING#3, 004

LISTING#4, 004

LISTING#5, 003

Created EndFile CSV (NOTE - This CSV file contains which listings need to be removed)

ACTION (STATIC), LISTING ID, REASON (STATIC)

End, LISTING#1, NotAvailable

End, LISTING#2, NotAvailable

End, LISTING#5, NotAvailable

This is the first job of many, so I would love to work with someone who can help me with more macros / buttons / Excel work in the future. If you are interested, please let me know a price estimate and if it is a good price then we can talk further and I can provide more details. If you need clarification, please ask. Thanks!

Skills: Excel

See more: y freelancer, write every day, work up freelancer, who to create id on freelancer, who is the freelancer, who created freelancer, which freelancer are you, what write in freelancer, what to write on freelancer, what the meaning of freelancer, what's up freelancer, what's freelancer, what's a freelancer, what is the freelancer, what is freelancer freelancer, what i need to know to be a freelancer, what i need to be a freelancer, what if the freelancer end the job, what freelancer am i, what freelancer, what every freelancer needs, the meaning of freelancer, the freelancer files, talk to a freelancer, talk freelancer

Project ID: #6122815

30 freelancers are bidding on average $72 for this job

zExcel

Hi, I'll be happy to help you with this project. Please feel free to message me if you need to discuss any questions

$100 USD in 1 day
(86 Reviews)
6.2
deepbluetech

Hi, I am an Excel expert and would be happy to take on your project. Let me know and we can discuss further. Regards, Arul

$100 USD in 2 days
(115 Reviews)
6.1
nagybatonyi

I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contain More

$72 USD in 1 day
(53 Reviews)
5.7
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou More

$96 USD in 1 day
(52 Reviews)
5.5
FIBIN

Hi I am interested to work for your project . I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% ac More

$55 USD in 1 day
(47 Reviews)
5.4
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at http://bit.ly/Lta2EN Looking for further discussions in this regard. with than More

$58 USD in 3 days
(33 Reviews)
5.4
wsh2

Greetings from Easton PA.. {smile} Highly experienced (20+ years) MsExcel Business programming and database expert with Guru / Mentor level technical credentials at www.experts-exchange.com and www.vbcity.com. St More

$94 USD in 1 day
(16 Reviews)
5.3
carivera

Hello, I've been this type of project for more than 6+ years. I have great experience automating complex and repetitive excel tasks. My previous contractor's feedback, can give you a clear Idea of the quality of More

$100 USD in 1 day
(20 Reviews)
5.0
ethicalboy

Hello ready to start asap to deliver you, If you can give me your notes and conditions, I can deliver it to you fast, also about me: I am m.s of systems engineering and b.s of industrial engineering, and excel and vba More

$59 USD in 3 days
(38 Reviews)
4.8
abdellatif81

Aucune proposition n'a encore été fournie.

$79 USD in 3 days
(4 Reviews)
4.7
sawangupta

Hi, I can help you in your requirement. Probably instead of one button we can have 3 buttons for all the task. regards Sawan

$60 USD in 3 days
(12 Reviews)
4.7
abdolah2014

HI I am an excel-vba (macros) expert and I can help U with your project pm me to discuss more................................................................

$111 USD in 2 days
(19 Reviews)
4.5
Wonderer

A proposal has not yet been provided

$55 USD in 1 day
(19 Reviews)
4.4
vikas0903

Hi, I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on pricing models, income statements, value-pricing projects etc. I have worked extensively on excel and VBA in my job and here on freelanc More

$64 USD in 1 day
(9 Reviews)
4.2
tomislav1975

I have done inventories, so pls check my profile and portfolio. If I still have your attention pls contact me and award with your project.Thanks, Tom

$94 USD in 1 day
(11 Reviews)
4.1
JonNxt

Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing code / debugging Excel VBA code. You may check my More

$80 USD in 2 days
(12 Reviews)
4.0
paris2785

Excel and VBA expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: 1.Real Estate (video demonstration) 2.Orders (video demonstrat More

$99 USD in 5 days
(22 Reviews)
4.0
BDtW

Hello Thank you for explaining the the project in details. I perfectly understand what you need. If you take a look at my profile you'll find that I have successfully completed several jobs here in freelancer whe More

$45 USD in 1 day
(13 Reviews)
3.8
danielrinf

Hello. It's an interesting project. I have experience with Macros and would be happy to help you. Please check my profile and Feddbacks to see the projects I've done. I would like to see first the original Files More

$94 USD in 1 day
(8 Reviews)
3.8
Midlander

I designed dashboards, reports and interactive spreadsheets, and managed databases for twenty years at a leading multinational. Now work from home in the UK across five freelance sites with good reviews from internatio More

$122 USD in 3 days
(6 Reviews)
4.0