In Progress

Excel macro/program for copying selections from multiple files

I need a macro/program that can copy a selection (e.g., C4:C38, in attached file) from a series of identically set-up excel files (e.g., could all be in the same folder) and that pastes them (transposed) in one and the same (new) excel file. As this is something we need to do regularly, I would, ideally, prefer a program/macro which, for input, I could specify a selection (like C4:C38, usually from one column) and take that from selection from a selection of files or files in a folder, and put all of those selections (transposed) in one new file. So, column becomes row (copy -> paste transposed) and each row is taken from a different file from a selection of files/folder. I am not experienced enough with Excel to know if this is something for a macro or a small program. If the basic idea is clear (a specific selection in an excel file, from various files,which should all end up in a new file, copy/paste transposed, with different rows for different source files). Possibility of a program in which a selection (or selections) and source folder can be specified would be ideal.

Skills: Data Processing, Excel

See more: new excel, macro, macro e, copying, multiple excel, file multiple files, excel row column, excel macro row, excel macro program, excel column row, data program excel, column row excel, excel column copy, program paste, copy data excel file, excel file program, copying program, input files excel macro, small excel, program input data, end program, excel rows, processing program, excel small, inventory macro program excel

About the Employer:
( 3 reviews ) Bloomington, Sweden

Project ID: #2575440

Awarded to:

FIBIN

Hi, your project can be easily achieved using excel Macros. I am interested to work for your project. I am an expert in excel and VBA Programming in Excel.I have experience working on lot of Excel based projects. I More

$40 USD in 1 day
(35 Reviews)
5.2

37 freelancers are bidding on average $67 for this job

mrbrave

Excel macro expert here....lets start.

$45 USD in 0 days
(74 Reviews)
5.4
bouslimi1979

Please check PM. Thanks

$80 USD in 2 days
(34 Reviews)
5.4
Krusche

Hi, our solution offering is to create an admin worksheet where you can a) choose the files/folder(s) to process, b) choose the target file where the data is output, c) choose the selection of the cells to be copied/tr More

$120 USD in 7 days
(21 Reviews)
5.2
pkcyber

Hi, Please see your PMB, important information regarding project.

$30 USD in 1 day
(18 Reviews)
5.1
tdSolomons

Let's Start. Please see PM.

$90 USD in 3 days
(32 Reviews)
5.0
Nhcuong

HI, i can do it quickly. I'm programmer for years and very familiar with VBA for excel automation. I can propose maximal flexible workflow for you: ... Please check the PMB for detail! What is your excel version? More

$40 USD in 1 day
(22 Reviews)
4.9
DeepSyaal

Having a team of Professionals. We Provide High quality work with accuracy.

$100 USD in 3 days
(41 Reviews)
4.7
shanki161

Expert in Excel. Read everything.Let me start. Thanks Karan

$50 USD in 1 day
(14 Reviews)
4.6
Imranatmoon

I have a working solution for you very simple.

$35 USD in 1 day
(25 Reviews)
4.4
Engineer85

Hi I am an Engineer and Excel professional and can handle this job for you. Thanks

$51 USD in 1 day
(13 Reviews)
4.4
microk

Expert Here.. Please check PM..

$30 USD in 2 days
(19 Reviews)
4.1
Pichart

I am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with excel more than 10 years. Of course, this we can deal with macro...I explain more in PM.

$50 USD in 2 days
(13 Reviews)
3.9
FLtowhid

Please see my PM

$30 USD in 3 days
(4 Reviews)
3.8
vgrichards

Very Good at Excel 2003-2010 and Excel VBA Macros. Please allow me to do it. Will ensure everything is as per your requirement.

$30 USD in 2 days
(18 Reviews)
3.6
vikashgadia

we have ur project ready...

$60 USD in 1 day
(15 Reviews)
3.6
expertatwork

We have understood your needs and we are very confident ! can we discuss ?

$30 USD in 1 day
(15 Reviews)
3.6
jaylancer43

Please give me an opportunity Sir..!!

$30 USD in 0 days
(13 Reviews)
3.6
him76

hi, pls check pm.

$50 USD in 0 days
(11 Reviews)
3.6
ramlak

I can do this project with expected quality.

$60 USD in 3 days
(6 Reviews)
3.2
JScottArnold

Afternoon- I've had years of experience building macros and tools for clients. I've sent you a mockup of a program that would do something close to what you asked, and if you accept my bid I can code it up fairly quick More

$30 USD in 1 day
(1 Review)
2.8