Concluído

Excel Customized Reporting

I need to combine data from two excel reports. I would like the following data pulled (by using the item #) from the report named "Inventory List" and added to report named "Item Summary." COL Qty, MOL Qty, Regular Price, and Last Rcvd. (I want to keep all existing column headers on Item Summary report) The final report should only have items listed that are on Item Summary Report. The new data headers added to Item Summary can start on Column J in this order COL Qty, MOL Qty, Regular Price, and Last Received With "UPC" header being the last header. Can this be done without saving and naming these 2 reports as a file? I would rather just generate the two reports then immediately close them after I get the needed data. Thank you.

Habilidades: Excel, Visual Basic, Visual Basic para Apps, Captura de dados na web

Veja mais: oscommerce order received email, excel charts start end graph, customized excel, reporting php excel, need customized excel spreadsheet, excel macro start external application, excel vba start external application, reporting access excel, start amoount order oscommerce, reporting sample excel aspnet

Acerca do Empregador:
( 16 comentários ) BATON ROUGE, United States

ID do Projeto: #10639866

Concedido a:

joeltl

Hi, yes. This can be done by vba for excel and don't need to save the file. Please pm me for discussion.

$150 USD em 2 dias
(4 Comentários)
3.3

34 freelancers estão ofertando em média $66 nesse trabalho

jaylancer43

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among Mais

$150 USD in 3 dias
(830 Comentários)
8.8
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your pr Mais

$50 USD in 3 dias
(357 Comentários)
8.0
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$100 USD in 3 dias
(475 Comentários)
8.0
mantislin

Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi

$75 USD in 2 dias
(365 Comentários)
7.9
$100 USD em 1 dia
(260 Comentários)
7.7
TonmoyRoy111

A proposal has not yet been provided

$83 USD in 2 dias
(457 Comentários)
7.3
zebracaro

I can do it for you quickly and exactly

$70 USD in 2 dias
(132 Comentários)
7.2
Attractionnet

Hello. I checked both files, they are clear and ok to combine. I will create a small program that will read both of them and create a new excel -or add to the item list- and combine the data you need. It's simple and w Mais

$55 USD em 1 dia
(217 Comentários)
7.1
rohitagarberg

Hi sir, Please send the two files and I will combine them as per specification. thanks..................

$30 USD em 1 dia
(424 Comentários)
6.7
finecodervw

Hi, I am well versed with Excel and its various features and keen to work on the assignment. I have handled various excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of gr Mais

$50 USD in 2 dias
(144 Comentários)
6.6
shikhamehta

Hey, I reviewed the two spreadsheets you shared and can create a macro that will allow you to combine the data from the two reports on click of a button. You would simply have to select the two files and rest will b Mais

$72 USD in 2 dias
(172 Comentários)
6.7
ShaunKleinOnline

Hi there, Your project sounds interesting - I have over 13 years of corporate experience working in Excel with advanced functions and formulas and I know I can help you bring in all of the data from the Item list fi Mais

$40 USD em 1 dia
(93 Comentários)
6.6
koolsidz

Hello :) My Credentials: 20+ of Excel/VBA Experience. [login to view URL] I am an MS-Excel Expert besides being an MVP (Microsoft Valuable Professional). If you see my reviews by navigatin Mais

$66 USD em 1 dia
(176 Comentários)
6.6
vsprybhanu

Hi, Experienced Excel VBA and VB.Net Programmer. Expertise in Exchange data between sheets, Critical Programming, Developing System for Management and Creating Reports. I've read and understood your project d Mais

$45 USD in 3 dias
(113 Comentários)
6.0
renesontiongson

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.

$35 USD in 0 dias
(72 Comentários)
5.7
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear fr Mais

$98 USD in 3 dias
(59 Comentários)
5.8
kchg

Hello, sir. My ranking is TOP 5TH in freelancer.com as you can see my profile: (https://www.freelancer.com/u/kchg.html). I'd like to discuss with you in detail. Kind Regards

$150 USD in 3 dias
(4 Comentários)
5.1
surekash7096

I have the expertise in Excel and can complete this task quickly and accurately. Ready to start work immediately.

$55 USD em 1 dia
(67 Comentários)
5.4
prabakarm23

I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I Mais

$83 USD in 3 dias
(58 Comentários)
5.0
KenKnack2012

Hi Boss. I'm Karthikeyan, a virtual assistant and a Certified Lead Researcher for UK leads through scrapping data.I'm expertise in Typing(70+ WPM), Data Entry, Form Filling, powerpoint presentation and MS Excel fo Mais

$48 USD in 0 dias
(18 Comentários)
4.7