Register
Log In
Unanswered
Home
August 27, 2016
Offline
Here is the code I am using to import sheets into new workbook.
worksheet Day 5 will change daily. Is there a way to place a value on sheet or have it read tab so it will change daily as I need it to.
Workbooks("Pioneer Natural Resources Trinidad 134 Dickenson 7B 2H Inventory.xlsx").Worksheets("Day 5").Range("A1:K90").Copy
Workbooks("Report Help.xlsm").Worksheets("Inv").Range("A1").PasteSpecial Paste:=xlPasteValuesAndNumberFormats
See Answer
October 5, 2010
Offline
Hi,
Yes probably, but if you could supply some sample workbooks including your code and explain how the sheet name will change it would be helpful for us to work out a solution.
Regards
Phil
August 27, 2016
Offline
Here are the 2 Sample files.
The days change along with the tab. Importing it into help file to distribute numbers elsewhere accordingly on daily basis
Dashboards
June 25, 2016
Offline
Hi
There are no attachments.
August 27, 2016
Offline
Sorry forgot to upload
Dashboards
June 25, 2016
Offline
Hi, see if this is what you want.
You will need to open both the Help and Inventory file.
Click on the Import Data button and select which sheet you want to import from the combobox.
Answers Post
Most Users Ever Online: 57
Currently Online: azri adrin, Mark Lund, Rudi
25 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Joy Berryhill
Ajay Mukhi
Stephen Motte
Rodney Hoyle
michael pitre
Samantha Burleson
Krishnaa Kurugod
David McSwain
Shameem Nassiree
Alanna Henderson
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
