Avatar of mato01
mato01Flag for United States of America

asked on 

Copy Paste multiple worksheets

I have several worksheets that I receive that have formulas.  I need VBA to copy/paste special all worksheets in a workbook.
Microsoft ApplicationsMicrosoft ExcelVB Script

Avatar of undefined
Last Comment
mato01
Avatar of softpro2k
softpro2k

I think you want to copy all sheets and create a master list in another sheet. Right ?

Will you please upload the sample file, so that we can have a look and work on it.
Avatar of ckivml
ckivml
Flag of India image

All the Worksheets are in Same file..
Avatar of softpro2k
softpro2k

Hi,

If the data is not really sensitive then it would be helpful if you upload the sample file.

Otherwise you can change the data and put dummy data and change the column names and upload.

Because the code that you want is entirely depends on how your tables are arranged in different sheets.

Regards.

A. Roy
Avatar of mato01
mato01
Flag of United States of America image

ASKER

I've attached a workbook  with 3 different worksheets, For this purpose I've already copy and pasted out the formulas.  But what I need is to be able to copy paste each of the worksheets, Wire 1, Wire 2, Wire 3.
TEST34.xls
Avatar of mato01
mato01
Flag of United States of America image

ASKER

Maybe I can clarify.  I need to loop thru several worksheets in a particular work book in which some of the worksheets have the word "WIRE" in the names, I.e. 1 WIRE, 2 WIRE, 3 WIRE, etc. I need to loop thru these worksheets and delete all the formulas (i.e. COPY & PASTE VALUES), and then save file.
ASKER CERTIFIED SOLUTION
Avatar of softpro2k
softpro2k

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of mato01
mato01
Flag of United States of America image

ASKER

Perfect.  Thanks a lot.
Microsoft Excel
Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo