distribute data from one workbook to multiple workbooks

K

kshitij_dch

Active Member
Joined
Apr 1, 2012
Messages
362
Office Version
  1. 365
  2. 2016
  3. 2007
Platform
  1. Windows
I have a workbook 1 in which i have 14000 count of data .from A1 till M14000

I am looking for a macro code which will distribute 14000 count of data to multiple different workbooks.

I have 50 different workbooks in the same folder name as book 1 , book 2 , book 3 and so on till book 50.

14000 divided by 50 comes 280 (macro will split 280 count of data to Each workbook)

Is it possible ?
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
You must log in or register to reply here.

Similar threads

D
  • Solved
Return Multiple Values From Two Columns In Two Separate Workbooks
2
Replies
13
Views
296
Fluff
Fluff
C
  • Question Question
Updating both sheets in two workbooks from either sheet source
Replies
6
Views
220
chazrab
C
A
  • Question Question
Code for copying data from multiple workbooks
2 3
Replies
24
Views
740
AbhishekJain
A
itsrich
  • Solved
Indirect Syntax - Outside the workbook
Replies
7
Views
209
itsrich
itsrich
G
  • Question Question
Select an Open workbook and apply a macro1 contained in the new book to the new book
Replies
1
Views
380
LazyBug
LazyBug

Forum statistics

Threads
1,223,909
Messages
6,175,315
Members
452,634
Latest member
cpostell

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top