Excel Macro

已完成 已发布的 Jul 9, 2011 货到付款
已完成 货到付款

Good Day,

I am looking for a Macro that will do the following.

1. I will have a .xlsx spreadsheet in a FOLDER: Ex: C\foo

2. I will open [url removed, login to view]

3. Find the value in COLUMN O Ex: 101245 - Corn Farmers

4. Open a new 101245 - Corn [url removed, login to view] Spreadsheet

5. Copy ALL ROWS with the SAME value in COLUMN O to Newly [url removed, login to view]

6. Save Newly [url removed, login to view] to Value In COLUMN O Ex: 101245 Corn [url removed, login to view]

7. Close Newly [url removed, login to view]

8. Repeat until ALL values in COLUMN 0 have been processed.

This will leave a folder with:

1 - [url removed, login to view]

2 - Newly [url removed, login to view] files with unique names based on COLUMN O

项目ID: #3432838

关于项目

6个方案 远程项目 活跃的Jul 9, 2011

授予:

soft1serve

See private message.

$38.25 USD 在3天内
(79条评论)
1.6

有6名威客正在参与此工作的竞标,均价$115/小时

Lotusdeveloper

See private message.

$85 USD 在3天内
(96条评论)
2.6
quickprogexpert

See private message.

$170 USD 在3天内
(243条评论)
2.8
dpune

See private message.

$127.5 USD 在3天内
(242条评论)
2.0
dominique1

See private message.

$97.75 USD 在3天内
(537条评论)
1.7
nobugz

See private message.

$170 USD 在3天内
(27条评论)
0.0