Macro Help

A

aekowalski

New Member
Joined
Sep 9, 2011
Messages
1
I am trying to create a master spreadsheet that contains only specific information from multiple workbooks all located in a single folder. Unfortunately, the range of information that I want to copy into the master worksheet is not consistent so I would like to be able to tell Excel the specific range for each workbook that it opens. Any help would be greatly appreciated. I am an attorney and have no working knowledge of VBA or any computer programming. I am also working on Excel for Mac 2011. Thank you.
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
You must log in or register to reply here.

Similar threads

F
  • Question Question
Excel Help with VBA Code
Replies
6
Views
156
mumps
mumps
J
  • Question Question
Pulling Data From ~300 Individual Sheets Onto a Master Sheet
Replies
1
Views
186
ranman256
ranman256
Y
  • Question Question
VBA Code to activate the tab and and transfer data
Replies
1
Views
250
Joe4
Joe4
T
  • Question Question
How do I write Code for an API key call using Blank Query on legacy Excel/Mac
Replies
1
Views
52
Ron de Bruin
Ron de Bruin
G
  • Question Question
Using a set date to prevent access to Excell tabs and macros
Replies
1
Views
230
Micron
M

Forum statistics

Threads
1,224,545
Messages
6,179,432
Members
452,915
Latest member
hannnahheileen

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