Fermé

Need Macro to Turn Rows of Data Into Columns of Data

At my old company one of my staff members built an Access macro that would take multiple records for the same entity and display that data horizontally on one row. His macro allowed for up to 20 fields per record (30 would be great but 20 is fine).

Step 1. Macro imports a .txt file or Excel worksheet (he set up 2 different macros depending on import file type but for expedience if just a tab delimited text import macro is developed that's fine) that has two fields only. The duplicate field (say employee ID) and the field that needs to be displayed horizontally (say employee committee name). I would be the one generating the input file each time. It's content agnostic. Always text fields only with standard text field limits (250 characters I believe?).

Step 2. Macro does its job and produces an Access table with the resulting data.

Input file looks like this (this is just an example not the actual field names):

Employee # Committee Name

1234 Finance

1234 Volunteer

1234 Recycling

1234 Employee Survey

5511 Volunteer

5511 Recycling

Output TABLE (housed in the same database) looks like this:

Employee # Committee 1 Committee 2 Committee 3 Committee4

1234 Finance Volunteer Recycling Employee Survey

5511 Volunteer Recycling

Now this is purely a tool I need to do other work in Excel. Function over style. Doesn't have to have any slick interface (or any interface), just imports a txt tab delimited file in from a specified location (preferably from "Documents" folder on my hard drive - Windows 7 OS). Even the output fields on the table can be called Field 1, Field 2 etc. This is just a tool to do data manipulation. Input file will never exceed the row limit in Excel (just to give you an idea of scale).

Not sure how this works (first time) but I assume bids come in to my e-mail. I need this ASAP. Someone may already have something like this built, fine with me. As long as it works per the specs above I'm good.

Using MS Access 2010

Thanks.

Todd

Compétences : Excel, Microsoft Access, Microsoft Outlook, Serveur SQL Microsoft, Sharepoint

Voir plus : up to standard, survey interface, i need employee, how excel works, first volunteer, excel macro how to, excel macro file location, exceed database, data access interface, need macro compare data, excel macro match data columns, macro pasting data columns, compare rows macro columns, need excel macro input data, excel macro copy data column, excel macro move data existing cell, macro extract data, macro gets data website

Concernant l'employeur :
( 0 commentaires ) United States

N° du projet : #8487981

30 freelance ont fait une offre moyenne de 100 $ pour ce travail

illuminesoft

ID : 8487981 Greetings, We are interested to work on this project, please find my comments inline with yours, [url removed, login to view] my old company one of my staff members built an Access macro that would take multiple records for Plus

155 $ USD en 3 jours
(213 Commentaires)
7.3
mrbrave

HI, This seems to be hardly couple of hours work for Excel/Acess expert. I am available to start work on this now and will provide output in couple of hours. Lets discuss the project in bit more detail. Thanks

66 $ USD en 1 jour
(159 Commentaires)
6.2
prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excei :) via VBA macro Sir :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You Sinc Plus

30 $ USD en 1 jour
(128 Commentaires)
5.8
mail2vimalarora

Hi, I have gone through your project details and would like to take an opportunity to work on it. I have worked on writing several Macros and can help you out with the requirement. Waiting for your response to talk Plus

35 $ USD en 0 jours
(73 Commentaires)
5.7
expertatwork

hello Todd, this is doable...please share your Access file, we can get you a macro for this....thank you..

39 $ USD en 0 jours
(120 Commentaires)
5.6
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Plus

250 $ USD en 14 jours
(70 Commentaires)
5.7
dipakmoliya

Hi! there, My name is Dipak Moliya. I’ve read your project description and can see that you’d like to built an Access macro that would take multiple records for the same entity and display that data horizontally o Plus

35 $ USD en 1 jour
(38 Commentaires)
5.1
mirniyazuddin92

Hi, I hv an idea about this work.. I can do it very well I hope u ll like to discuss more.. awaiting for ur response,, thanks & regards Mir

150 $ USD en 3 jours
(46 Commentaires)
5.2
havit

Dear Client, I am like to purpose to upgrade your current system, so it can export those records to MS-Excel. Your old system will work as usual and there will be export functionality which will open the MS-Excel Plus

100 $ USD en 2 jours
(6 Commentaires)
5.1
dev3dworx

Hi I am an experienced Excel/Access vba developer having expertise in smart data solution development. I can create an amazing tool which will import data and create output as per your specs. Please check my feedback Plus

194 $ USD en 2 jours
(21 Commentaires)
4.7
AlexandrK1

i can complete it within 24H and can send first draft for your test within ~2-4 hours after awarding if my proposal is ok with you please send the txt examples and create milestone payments

155 $ USD en 1 jour
(17 Commentaires)
4.9
kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 40 projects, almost 35+ are complex VB/VBA projects, hence i can definitely deliv Plus

54 $ USD en 3 jours
(31 Commentaires)
4.9
abhinovpankaj

Hello, I have been working as freelancer since last ~ 2.5 years, prior to this was working with a MNC as a Sr. Software Professional. The project is Product based development and integration of the product with v Plus

155 $ USD en 3 jours
(12 Commentaires)
4.3
rajafaizan

I am very interested in working online for you. I am interested in long term work. I have had 5+ years exp. in Computers, MS word, MS excel, Quickbooks, Office Management , PDF, Google spreadsheet Powerpoint, Vba and t Plus

61 $ USD en 2 jours
(19 Commentaires)
4.2
rsliter

Hello, I’m newer to this freelancing website and am just beginning to build my online reputation and client base. Over the past 17 years, I’ve worked in a variety of functions spanning Information Technology, Suppl Plus

50 $ USD en 1 jour
(6 Commentaires)
4.2
NeilSargent

I think this can be done directly in Excel without the need for Access at all. What you are doing is pivoting the data. A simple pivot would create a table with a column for each committee and loads of empty columns Plus

225 $ USD en 3 jours
(5 Commentaires)
4.1
akrikun

Hi Todd, As far as I understood, you need an Excel macro which would read tab-delimeted txt file and populate Excel sheet with data which has rows transferred into columns. If that's your requirement, then the projec Plus

111 $ USD en 2 jours
(8 Commentaires)
3.4
zu02

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Plus

155 $ USD en 3 jours
(2 Commentaires)
3.5
sumeet00

A proposal has not yet been provided

200 $ USD en 3 jours
(3 Commentaires)
3.1
mmuthamilselvan

I have implemented several complex macros. I would like to work with you. please let me know further. Regards, Selvan

35 $ USD en 1 jour
(4 Commentaires)
2.5