Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 02-11-2016, 08:03 AM
manilara manilara is offline need vba code export data to closed workbook sheets Windows 7 32bit need vba code export data to closed workbook sheets Office 2007
Banned
need vba code export data to closed workbook sheets
 
Join Date: Apr 2015
Posts: 7
manilara is on a distinguished road
Default need vba code export data to closed workbook sheets

Dear sir



i have one file saved in [Master] file with multiple sheets tab named by country ledger name.
i have another workbook [Misexpanse] with data range of A:K i want split A:A rows as per name of country ledger names move to master file sheet where sheet name and ledger name meet

if rows value is Alabama and sheet name is Alabama then 11 rows move to corresponding sheet with heading

find the attachment
Attached Files
File Type: xlsx Master.xlsx (107.4 KB, 7 views)
File Type: xlsx MIS Expense.xlsx (146.3 KB, 7 views)
  #2  
Old 02-12-2016, 08:20 PM
macropod's Avatar
macropod macropod is offline need vba code export data to closed workbook sheets Windows 7 64bit need vba code export data to closed workbook sheets Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Cross-posted at: http://www.techsupportforum.com/foru...s-1093770.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

Thread closed.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Closed Thread

Tags
excel vba xml import loop



Similar Threads
Thread Thread Starter Forum Replies Last Post
need vba code export data to closed workbook sheets Writing a VBA code for printing multiple sheets in a workbook m85miller Excel Programming 1 02-02-2016 01:41 AM
vba code for integrating particular information from different workbook to one workbook klpw Excel Programming 1 12-28-2015 09:48 AM
need vba code export data to closed workbook sheets Summarizing data in a workbook which the sheets contain verndor names in different orders. pad Excel 3 10-14-2015 07:33 PM
If two geographical data match in two sheets, copy unique id/code found in one sheet alliage Excel 1 09-01-2011 05:23 AM
need vba code export data to closed workbook sheets How do I merge data from one sheet in a workbook out into multiple sheets nolesca Excel 4 06-07-2010 08:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:50 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft