Käynnissä

Excel "Macro" Project.

Excel “Macro” Project.

I need a “macro” or subroutine, or whatever they are called these days, to automatically transpose spreadsheet BEFORE to spreadsheet AFTER, both attached. (FreelancerSampleBEFORE to FreelancerSampleAFTER).

Hopefully, the macro will automatically select the number of records with the same column A, (e.g. select 2 columns for Adamstown, and 4 for Albion Park), and then do a “PasteSpecial/Transpose before going down to the next column A entry. Obviously, where there is only 1 record for a particular column A entry, then selection and transpose is unnecessary, such as with Aarons Pass and Abbotsford.

Each “real” spreadsheet contains up to 5,000 records, which is why I need the macro.

Taidot: Excel

Näytä lisää: excel macro project, transpose, macro e, excel contains, excel record, project macro, excel 2013 macro, macro spreadsheet, record excel, excel record macro, excel record project, ozbiz, loop transpose macro excel vba, macro transpose, number excel macro, excel column column, excel macro columns, need excel macro, project next number excel, excel selection, park project, macro project excel, macro project, import msp project data excel macro vba, project 2003 macro excel report

Tietoa työnantajasta:
( 20 arvostelua ) Edgecliff, Australia

Projektin tunnus: #4226227

Myönnetty käyttäjälle:

pierreho

Dear OzBiz, please have a look on my macro which does what you want. Kind regards

40 $ AUD 1 päivässä
(24 arvostelua)
4.8

5 freelanceria on tarjonnut keskimäärin 32 $ tähän työhön

bharanisrihari

Mate, Excel VBA expert here. Consider it done. Please check PM for details. Thanks!

30 $ AUD 1 päivässä
(57 arvostelua)
6.3
mrbrave

Expert Excel developer here...Lets start and get it done in 2 hours..

30 $ AUD 0 päivässä
(67 arvostelua)
5.3
Gooroo

Hello! *SEEK NO MORE!* This is 'a piece of cake' for me! I'll do it VERY FAST and ACCURATELY! Let me help! Highly experienced in Excel macros (high-school IT professor and programer! THANKS!

30 $ AUD 0 päivässä
(11 arvostelua)
3.8
sujeewaT

Let me help you for this simple & interesting project!!! Please see Pm for more information...

30 $ AUD 0 päivässä
(0 arvostelua)
0.0