Completed

Macros, Excel Formatting

Summary:

- The spreadsheet has 2 tabs, select and report

- Select includes a list of data, report is where I need to apply a macro

- I’ve highlighted all columns and buttons in Yellow that I need worked on

What I need:

1. The report tab: I need a macro, connected to button I7:J8 to pull the listed columns (these are in the same order and name as in the select tab and highlighted in yellow) in the Select tab. This macro should simply re-organize those columns in the select tab into a vertical sheet as outlined in the report tab. The tables in the report tab should expand/shrink based on the amount of data in the select tab.

2. In the video here: [url removed, login to view]

this guy does something similar to what I need, but I need the macro to be oriented and spaced according to the entries I’ve outlined in the Select tab.

3. I also need another macro attached to the button: I10:J11 to print the range A1:G(to end) as well.

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

See more: https://www.freelancer.com/projects/Excel/Fill-Spreadsheet-with-Data-14343803/, MS Access ,excel , PowerPoint with pivot tables and macros, source ceop exposed https www youtube com watch v 4ovr3ff_6us&feature youtu be uploaded 26 april 2016, https www freelancer com projects data entry some excel work 10628254 utm_campaign latest_project_contest, https www freelancer com mobile app deep link php url https 3a 2f 2fwww freelancer com 2fprojects 2fdata entry 2fsome excel work, freelancer https www freelancer com projects data entry data processing build excel published books from html utmcampaign lates, freelancer https www freelancer com projects data entry data processing build excel published books from html utm_campaign lates, formatting macros excel, converting lotus 123 macros excel macros, building macros excel, macros excel data database, populate summary agregate tables using informatica, excel formatting macros, macros excel paypal, macros excel info web, convert lotus macros excel

About the Employer:
( 1 review ) Toronto, Canada

Project ID: #16345705

Awarded to:

alexanderrubtsov

Hello. I propose to complete the project (VBA macro in Excel for Windows) on terms specified in my bid. Please contact me if you are interested. Best regards, Alexander.

$60 CAD in 1 day
(17 Reviews)
4.5

18 freelancers are bidding on average $110 for this job

P0L

Hello, I’m an Excel/VBA expert and I would like to help you with your project. I'm fully available and I can start right away. Please check my profile and contact me to discuss. Regards.

$150 CAD in 3 days
(237 Reviews)
6.9
sonarkaushik

I am very able to create this macro and ready to start I have all the resources ready to do your project as per your requirement I am very much able to work on this. ***I am ready to start Messageme for further disc More

$144 CAD in 2 days
(98 Reviews)
6.2
usmanhassan123

A proposal has not yet been provided

$250 CAD in 1 day
(26 Reviews)
5.1
polarjin2017

Hello? How are you? I have good skills in Excel macro. You can see my reviews. I will never disappoint you. Thanks.

$155 CAD in 3 days
(27 Reviews)
5.3
$70 CAD in 1 day
(21 Reviews)
4.7
RushService

Feel fee to contact me forMacros, Excel Formatting .Shoot me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the [url removed, login to view] payment only aft More

$150 CAD in 3 days
(6 Reviews)
4.1
qasimalikgmail

Dear client, I have read the description and can build VBA macros for you. I can also showcase you my previous such work. Looking forward

$88 CAD in 3 days
(10 Reviews)
3.9
Ahmed818

Hello, i am expert in this kind of jobs samples of my excel VBA jobs https://www.freelancer.com/projects/Excel/VBA-loop-code-sum/ https://www.freelancer.com/projects/Excel/Complete-Some-Advanced-VBA-Microsoft More

$30 CAD in 1 day
(19 Reviews)
3.5
FarhanmGood

Hi, I have read your description thoroughly. I can build a macro for you using your spreadsheet and it will automatically pulls and formats the information like your desired. Feel free to contact me anytime. Tha More

$50 CAD in 3 days
(13 Reviews)
3.8
$100 CAD in 2 days
(2 Reviews)
2.0
sunprah2018

I am an MBA, and ex-investment banker. I assure all my clients a high quality work in a stipulated time period. My skill set includes the following:  Excel  Financial Modeling  PowerPoint Presentation  Marke More

$190 CAD in 3 days
(1 Review)
1.2
nizamulamy

Hello! I am Amy At your service. I want this job! I can begin immediately! I'm sure that I will be able to complete everything for you very swiftly and professionally!Please write back soon if you are interested in More

$155 CAD in 3 days
(1 Review)
1.3
venkat5652

Good knowledge in excel and VBA macros and have relavant experience in handling this type of projects very easily.

$45 CAD in 0 days
(1 Review)
0.1
KashifQadir

I read your details and would like to work for you and gain experience and show you my work at best within the tight time frame ! Everyone needs first step and no one forgets there first Work ! But everyone forgets the More

$150 CAD in 5 days
(0 Reviews)
0.0
MK04588

I can do in 2 day

$45 CAD in 2 days
(0 Reviews)
0.0
pablor88

A proposal has not yet been provided

$111 CAD in 3 days
(0 Reviews)
0.0
drshivpratap23

A proposal has not yet been provided

$45 CAD in 3 days
(0 Reviews)
0.0