Completed

I need two simple Excel macros

Hi,

I am looking for someone to write two very simple Excel Macros for me

a) Store data macro macro should copy data to first empty row below row number 44 (I populated row 45 with data so you could see it as an example) following data should be copied:

-value from cell A1 to first available row (in this case A45)

-values from range B11:B33 to first available row (in this case B45:X45 - USE TRANSPOSE FUNCTION)

-values from B35:B42 to Y45:AE45

-values from C11:C33 to AF45:BB55

-values from C35:C42 to BC45:CJ45

-values from F38:H38 to BK45:BM45

-N39 to BN45

when macro is ran again, procedure should be repeated (using next free available row, so in this case row 46, then row 47 etc)

b) LOAD macro This macro should identify data from which row should be loaded back to the table on top so if value in cell A1 is MilanWisla, if MilanWisla is in cell A46, data from row 46 should be loaded same as in the first macro just other way around :)

B46:X46 to B11:B33

Y46:AE46 to B35:B42 and so on and so on

PLEASE ONLY APPLY IF YOU CAN FINISH THIS PROJECT IN NEXT 60 MINUTES! BUDGET IS 10$!

Please also include in your application the name of the attached Excel file (I'll automatically reject all applications without that - don't want to work with people who didn't even bother to read post description and to open attached file!)

Skills: Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps

See more: excel vba run multiple macros simultaneously, assign multiple macros to one button excel, excel macros for dummies, excel macros for beginners, how to assign a macro to a button in excel 2013, excel macro tutorial for beginners, excel macro tutorial pdf, how to use macros in excel, i need simple logo, i need simple app, I need simple poster, i need a phd research proposal writer who can write 3 4 research proposals on potential phd research topics in the following are, i need an excel freelancer, i need an excel expert to come and fix up our spreadsheets for a few days johannesburg, i need to do a wap that people can get my music pictures and videos

About the Employer:
( 4 reviews ) Krakow, Poland

Project ID: #16408618

Awarded to:

vlayausa

[login to view URL] Hello, I can make this macro for you. I am proficient with Excel and VBA. Please contact me.

$15 USD in 1 day
(126 Reviews)
5.7

5 freelancers are bidding on average $24 for this job

AnumZia

I'm Ready It does not matter how much you pay after the work is finally delivered We will work on it now I will deliver you the same day Quick execution Dealing seriously Work 24 hours a day Relevant Skills More

$25 USD in 0 days
(31 Reviews)
5.0
FerriSoft1

ExcelMacroSheet, Hi I can do this in the following 60min, in fact if you give me you GO word through chat, I'll start and you can award me after I show you its working. I'm sorry I can't do it for $10, remember Free More

$25 USD in 1 day
(7 Reviews)
3.6
varvapalli

I can develop very fast, give me chance to do it, this is very simple teak. the requirements are very clear.

$25 USD in 1 day
(0 Reviews)
0.0
TuwokHowardii

I think I have a fair idea of what you want. The table on top is for inserting new records (using store data macro) and to retrieve a record you type values on top and code checks and retrieve it. (load data macro). More

$30 USD in 1 day
(0 Reviews)
0.0