Færdiggjort

Excel macro. Re-arrange data into new worksheet. -- 2

Re-arrange data. Move the values from rows to columns in a new worksheet.

Read worksheet "explanation" for description of the boxes.

Name the new worksheet using the value from FORECAST DATE (cell I1).

1. Read every box from the worksheets 3-7-14days and 1-3-12months.

2. On the new worksheet place FORECAST DATE (cell I1) to column A

3. Place the TIME HORIZON in column B

4. Place the STOCK NAME in column C

5. Place the SIGNAL in column D

6. Place the PREDICTABILITY in column E

7. column F = D * E

8. If the STOCK NAME is blank, do not create a row

9. Keep doing this for every TIME HORIZON

10. The output is one worksheet. All TIME HORIZONs re-arranged in one worksheet. See the Transform Before and [login to view URL] to see the input and the resulting output.

11. The working copy of VBA macro source code must also be submitted.

12. If you have questions, don't hesitate to ask. If you have other suggestions, let me know.

Evner: Visual Basic, Dataindførsel, Excel, C# Programmering, Excel VBA

Se mere: excel macro next chart data, excel macro copy paste data application, excel macro copy paste data, excel macro script insert data spreadsheet, excel macro lookup web data, excel macro copy site data, excel macro extract table data website, excel macro display table data, excel macro download copy data, excel macro refresh web data, excel macro copy paste data list websites, excel macro yahoo historical data, excel macro paste clipboard data format, excel macro extract webpage data, excel macro import lock data refresh, excel macro view row data form, excel macro extracting pdf data, excel macro browse copy data, excel macro to filter data and copy to new sheet

Om arbejdsgiveren:
( 4 bedømmelser ) LOMPOC, United States

Projekt ID: #31045806

Tildelt til:

(4 bedømmelser)
3.0

16 freelancere byder i gennemsnit $56 timen for dette job

(454 bedømmelser)
8.3
(156 bedømmelser)
6.3
(88 bedømmelser)
5.7
merinsinha

VBA expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfrom Flere

$50 USD på 1 dag
(132 bedømmelser)
5.5
raoarslan56

Here sir! Muhammad A. we have discussed the project .... i will write you vba code... text me so we proceed further...

$50 USD på 1 dag
(19 bedømmelser)
5.0
techplusintl

Hi there, ★★★ Data Processing / Entry (Word/Excel/PDF Expert ★★★ 8+ Years of Experience ★★★ I've read requirements and ready to re-arrange data into new worksheet. I can do any type of excel,Data science,Data processi Flere

$50 USD in 2 dage
(10 bedømmelser)
5.3
lapshovaanna

Thank you for your post. I have read your post carefully and I think I can do this project perfectly. I am sure I will give you perfect result in time. I have great skill and experience in this field. ** Java, Matlabav Flere

$200 USD in 7 dage
(5 bedømmelser)
3.2
mcollinscalz

Hello Dear, I am an expert in Data Entry, Excel, Research, Excel Web Search and I am really interested in your project. I am available to start working on it now. I work efficiently and will finish in a timely manner Flere

$70 USD in 7 dage
(2 bedømmelser)
2.7
gryndanya

vb developer experience over 2 years I can start working immediately. Let's discuss details in chat. Thanks

$30 USD in 7 dage
(10 bedømmelser)
2.5
dopyong3235

Hi, It seems a very interesting project for me. I have a deep understanding and experience in the areas of Excel, VBA, Macro... ****************************************************************************************** Flere

$50 USD på 1 dag
(1 bedømmelse)
1.1
tarunsangwan2

i am right person for this project i know everything about excel als have a great expereince of 1.5 years

$30 USD in 7 dage
(0 bedømmelser)
0.0
udsab04

Hello I am a new freelancer. It would be a great pleasure for me if you provide me the job. i will try my best to do the job. I have gone through your attachment and i believe i can do the work and submit it in time. w Flere

$30 USD in 7 dage
(0 bedømmelser)
0.0
hatou1227

Hi, How are you today? Thank you for posting this project, and I'm very happy to bid your project. I've read carefully your project details. I have a tons of experience in Excel, Excel VBA, Visual Basic. Your satisfac Flere

$20 USD på 1 dag
(1 bedømmelse)
1.0
Sheikrehan555

I work fast and get the job done as soon as possible. I will also adjust according to the preferences of the client.

$20 USD in 7 dage
(0 bedømmelser)
0.0
jindevmaster0101

Hi Dear! I already check your description with carefully and very interesting your project. I have a development experience of project like your project. I have more than 10 years of experience in software development, Flere

$30 USD på 1 dag
(0 bedømmelser)
0.0