Excel Consolidation of Multiple Spreadsheets to Master File, and Pivot Table with Multiple Consolidation Ranges

In Progress Posted Dec 5, 2013 Paid on delivery
In Progress Paid on delivery

Need to take 8 individual excel files, copy 1 entire spreadsheet on every file to a master spreadsheet. Then I need a Pivot Table with multiple consolidation ranges to summarize the data.

Visual Basic

Project ID: #5200994

About the project

18 proposals Remote project Active Dec 9, 2013

18 freelancers are bidding on average $342 for this job

jaylancer43

Hello - I am an Expert Techno-Functional Analyst in lots of arenas of IT industry including Excel Macros. I am an Engineering Graduate with an MBA degree. If you see I am among the niche bidder who has 0 failed pro More

$255 USD in 10 days
(475 Reviews)
8.1
zExcel

Happy to help you with this project. Please send me the file so I can review the scope and probably offer a more competitive bid

$250 USD in 2 days
(116 Reviews)
7.1
alekscoder

I can complete this work, because 20% of completed by me works were done in VBA (Visual Basic for Applications) and 43% in Visual Basic. I know, how to: 1. Select desired data Workbooks for main Workbook using Dial More

$255 USD in 4 days
(73 Reviews)
6.1
finecodervw

Hi, It would help if you can share the Excel files so that I can have a look at the same. Also a quick discussion with you will be really helpful. Let me introduce myself as an expert VBA programmer. I have used More

$700 USD in 12 days
(85 Reviews)
5.9
expertatwork

hey Allison, please share any one of the 8 excel files and the master sheet. We like to have a look at it. I guess you have posted the project in a wrong budget (250$ and above). Please reply and we can discuss furthe More

$250 USD in 3 days
(115 Reviews)
5.6
meparashar

Hi Allison, I can do this job for you using VBA and I can deliver it in 5 days. Please let me know if you're interested. Regards, Rahul

$300 USD in 5 days
(37 Reviews)
5.3
srinichal

I like to discuss further about the details and deliver the software to your specifications and needs.

$631 USD in 6 days
(37 Reviews)
5.6
piyushdpatel

I have 8 yrs of Exp in VBA,VB6,VB.net and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Ready to start Can You send me your Sample file ? if you want i will also send demo of my work or yo More

$277 USD in 3 days
(22 Reviews)
5.1
eugene2006

Hi. I have a lot expirience in macro for data consolidation. Can you provide a sample of excel files? Can you tell what Excel version do you use? And what operating system system supposed to be in use? I set 3 More

$250 USD in 3 days
(6 Reviews)
3.8
duksmth

Hello, I am very interested in your project. I have BBA degree, management in IT, I work in sales and I am ms office/vba expert. I would like to know more details prior to awarding/accepting project. You can check m More

$270 USD in 3 days
(5 Reviews)
2.7
vibink

Hi I am an Excel VBA Programmer and a designing expert , with 5+ years of experience. I am very much interested in this project .But being a beginner I don’t have a high profile here. But I will make sure to make you More

$555 USD in 3 days
(1 Review)
1.4
NizamM

Hi, Are these spread sheets having the same data structure or different structure? Do you need pull the data from those sheets to master sheet regularly? or is this one time job? I can export this data to access More

$300 USD in 3 days
(0 Reviews)
0.0
prasannakpl1

I understand the Job. But the Skill is mentioned as VB. Do you want a macro to do this? My Bid is based on this assumption that i need to only the consolidation, manually. Note : I am also good at VB macros in EX More

$300 USD in 3 days
(0 Reviews)
0.0
darian83

A proposal has not yet been provided

$555 USD in 3 days
(0 Reviews)
0.0
syahawang

A proposal has not yet been provided

$250 USD in 3 days
(0 Reviews)
0.0
krishnaidesign

I worked on a similar requirement, where we will consolidate 27 excel sheets to one master copy (all excel sheets are placed in a single folder) and once consolidated to one single master excel sheet, w do add mathemat More

$255 USD in 5 days
(0 Reviews)
0.0
AVKDevelopment

Предложение еще не подано

$250 USD in 1 day
(0 Reviews)
0.0
saktulga

Hello, I am an excel expert, who can do this project in a very short time with high accuracy. Please contact me if you need good job done in a short time.

$250 USD in 2 days
(0 Reviews)
0.0