View Different Tabs In Same Document At Same Time?
Mar 25, 2012Is it possible to view different tabs in the same document at the same time?
View 4 Replies
ADVERTISEMENT
Hide Tabs In HTML View
Jun 28, 2006Does anyone know of a way with VBA to hide the tabs when saving excel as a web page?
View 7 Replies View RelatedTaking Data From Document To Rename Tabs
Apr 21, 2013There is a folder in a shared location which many people use at work. Within this folder, I have an excel document with all current stock (called "Current Stock"). There will never be more than 20 items in current stock. There is also other documents within this folder which relate to lots of other things, Interest, Deals etc.
What I want to do is every time a new item is added to the "Current Stock" document, a tab is created with that Item name within all the other documents.
Create Documents Based On Cell Values And Input Tabs In New Document
Sep 12, 2013I want to create a macro that creates a new .xlsx document based on cell values. And input 4 tabs into each document with specified tab names. I have a document that pulls from external sources and fluctuates with amount of data per day. I envision something that will make a new document named for the contents in cell A1, then function as a control+down to create a new document for A2, then A3 until there is no content left (should mention these are lookup formulas, and if there is no data it pulls a value of "0")
Is there a way to put in the code, the tab names it would create in each new document, or would that have to look to a cell value for the naming? The tab names would be "GS", "MYSS", "COLL SHEET", and "WIRE".
View Two Worksheets At The Same Time
Jan 7, 2008way to keep one of my tabs visible all the time while looking at other worksheets in the same workbook, almost like a spilt screen.
View 9 Replies View RelatedView Different Ranges At Same Time
Aug 1, 2007if it is possible (and if so how) to add a scroll bar to excel (currently using 2003). What I am attempting to acheive is to have two areas on a work sheet, the first of which contains data that is much larger than the second but both of them need to appear on the screen at the same time. If it was possible to apply a vertical scroll bar to the first range which is named this would be possible.
View 6 Replies View RelatedImported Document Time To Seconds
Sep 22, 2006 I have an imported docment that stores the data as excel time. I need the data in seconds. I changed the format to [s]. This was great, exactly what I needed until I imported the document in to Access. Access changed the data back to time format. So here is my question: Is there any way to paste [s] data and save it as an text? or Is there a formula that I can change the data into seconds? I have searched the forum for a couple of days and went to the formula help page, but there was nothing that addressing my issue.
See Example below
Original imported data:
0:17:57; 1:53:00
10:04:11; 34:54:36
127:19:04; 804:26:33
297:58:37; 127:10:07
72:59:56; 273:31:29
Changed to [s] (desired values in Text or number format):
1077; 6780
36251; 125676
458344; 2895993
1072717; 457807
262796;984689
Searching For Mistakes In Document While Using Another Document As Reference
Feb 2, 2014I am processing a fair few Invoices, which are being sent to me via e-mail as excel documents, very often they contain mistakes, a decent amount of mistakes. Usually the prices are wrong.
I keep track of every single entry on the invoice on my own document - Tracker, which I consider to be the superior/more correct document to the Invoice presented to me by my contractor.
Both of the documents have a reference number, which is a specific docket number, and horizontally, in the invoice, there is going to be a price for this docket. In my document, there is going to be a separate column for the total price.
Is it possible (I guess with VBA) to check for mistakes in the Invoice, but use the Tracker as a reference for this check.
Tracker has
columns
A - Name
B - Department
C - Date
D - Docket No.
C - Total price for the docket (calculation of E to Z)
E to Z - all smaller entries
Invoice has
columns
A - Date
B - Docket No.
C to E price for that docket, but it is spread, because departments are separated out, so each VAT account can be charged accordingly. I guess it is possible to do a separate column for the price, if it is easier to do a script that way.
Basically, I need to check if in the Invoice document, the price (C to E) for Docket No. (B) is the same as the price (C) for the Docket No. (D) in the Tracker.
I would like the wrong entries to be highlighted on the Invoice Document, so I can see straight away, that this needs attention.
Not always the price is wrong, sometimes the Docket No. is spelled incorrectly (Dyslexic contractor), hence the highlighting.
Script That Will Turn Excel Document Into A Txt Document
Feb 17, 2009I need a script that will turn a excel doc into a txt doc. Thats the easy part. The hard part (at least I think it is), is I need it to be in a certain format and I'll do my best to explain that fomat below.
View 9 Replies View RelatedDocument With Two Tabs, One "data" One "offer"
Jul 25, 2008i have an excel document with two tabs, one "data" one "offer"
can select parts from a list in "data" (putting a quantity next to the part number) then hit a command button and have the part number, description, quantity and price added to the "offer" tab
(i have a smaller version/sample doc if anyone wants to take a look )
Excel 2010 :: Macro For Replacing Text In HTM Document - Text To Change Different Every Time
Mar 18, 2014I am my excel worksheet (excel 2010) I have one cell that changes every day (number). I want this number to open my htm document and replace the same number in a string in the htm and save/close this.
An example:
My htm document is located at C:/ and named XX.htm
The number I want from excel is in cell A1 in sheet1, and the worksheet is located in D:/ named yy.xlsx
And the text(number) I want to replace is in the following string in the htm document, in this string it is 72, next day it can be 30:
src="Bilder/72.png"
Excel 2007 :: How To Adjust Protected View Settings But Protected View Tab Is Missing From Trust Centre Settings
Dec 12, 2013Excel 2007 - need to adjust protected view settings but the protected view tab is missing from my Trust Centre settings - have the following tabs - trusted publisher / location, add-ins, activeX, macro, message bar, external content and privacy options. Document is a revenue authority download and without being able to adjust the protected view settings, can't input data.
View 3 Replies View RelatedExcel 2007 :: Change Colour Of Tabs To Match Other Tabs In Workbook
Sep 22, 2012I have been trying to get Excel (2007) to change the colour of tabs to match other tabs in the workbook
Using this code I get the colour code of the current tab
Code:
x = ActiveSheet.Tab.ColorIndex
But when I use this value in a procedure like this:
Code:
ActiveSheet.Tab.ColorIndex = x
The tab is a different colour!
Use The Names Of The Tabs In The Summary Page And Create It Into A Formula To Lookup Fixed Cells Within The Various Tabs
Oct 12, 2009I have a summary page that includes the titles for each tab within the excel 2003 workbook. I want to use the names of the tabs in the summary page and create it into a formula to lookup fixed cells within the various tabs. Sorry for not uploading an excel doc but I was at work earlier and the thread did not load for some reason, so I am reposting it.
View 3 Replies View RelatedOld Tabs Not Behaving Like New Tabs
Jun 25, 2008I'm using Excel '03SP2 on Win 2000sp4. I believe I have a case where old tabs originally written in Excel ' 97 behave differently than new tabs in the same workbook, which is saved in 2003 format.
Specifically, the formula ="PLAN" & budyr-1 where budyr is a named range on a different tab containing 2008 . This formula yields PLAN 2007 on a new tab and #VALUE! on an old tab.
How do I get Excel to update the old tabs so that they behave as Excel 2003 tabs?
View But Not Print Out
Aug 15, 2009if there's a way to either define what columns or rows are printable or to somehow leave columns (or rows) as visible within the print area but omitted from printing as if they were hidden.
In my CAD package I can simply elect to have certain collections of information "non-printable", is there any way I can do this with columns without having to rely on people managing to laboriously (sic) hide and unhide columns either side of printing a document.
View A Worksheet With VBA
Feb 8, 2010I've design a small little excell program that brings up a form and hides the excel workbook upon opening. By using the form the user is able to input data to a worksheet in running in the background. I've added a button on the form where I want the user to be able to open the worksheet which is password protected and view or print the data. I've already got the code to hide the workbook, protect and unprotect the sheets, I just can seem to get the code to view the one worksheet.
View 3 Replies View RelatedView Locked Add-Ins
Sep 18, 2002In keeping with their monopoly on code, Microsoft has, of course, locked all of the included XL add-ins (the code part).
I was interested in looking at how some of these add-ins functioned, seems like it could be fairly educational.
how to unlock the modules that come with XL's add-ins?
Changing The View
Feb 17, 2007i was wondering how i can get excel to hide everything except for the worksheet, as soon as it starts and then put it all back when you quit.
View 2 Replies View RelatedCannot View Sheets In 2003
Aug 11, 2008I am using some protected workbooks and cannot see the tabs at the bottom of the screen.
I have tried going to tools/options/etc
I have tried viewing full screen
If I copy the current sheet 1 and paste it into a new workbook I can then see tabs (but only sheet 1 has copied data).
View Two Worksheets Simultaneously.
Nov 11, 2008I use a two monitor setup driven from a Radeon 9550 graphics card, but the problem I have occurs on a single monitor as well. When I open multiple workbooks or worksheets I can only view one at a time the other remains embedded behind the open window. Nothing I know of will let me view both at the same time.
If there are two open worksheets full size on the screen and I minimize one they both minimize. If I decide to close one workbook/sheet down all open workbooks/sheets close down as well. Can I view two workbooks at the same time? Can I close one down while keeping one open?
Fix Sum Cells To Always Be In View? Even When Scrolling
Feb 10, 2009Ive seen on someone elses workbook the first 6 columns are fixed (always in view) then you can still scroll across but those first six columns always stay in view.
View 3 Replies View RelatedView The Date In The Formula Bar
Apr 30, 2009i was doing something in Tools -> Options -> View, & suddenly the dates in my sheet disappeared & some numbers came up, i can view the date in the formula bar, but can't be viewed in the cell, & i am also unable to do the alignment for the cell.
View 3 Replies View RelatedTransposing A Table View
Oct 29, 2009see attached WB.
Preferable solution using only Sheet Formulas only.
View Addin's Worksheet?
May 11, 2009I'm stuyding the book "Professional Excel Development" which has a Project Template and an addin with several modules and a worksheet. I can view the addin's modules but not it's worksheet - is this normal for addin's? I haven't worked with them much before.
View 2 Replies View RelatedView Website Tags?
Dec 21, 2009I am building an application through Excel to update specific internal website information. My question is, is there an easier way to identify and view the tags on a web page without having to right-click and "view source"?
View 2 Replies View RelatedDefault View Of VB Windows
Feb 18, 2010Having trouble setting VB windows views back to deafult ...
View 14 Replies View RelatedHow To View String In Msgbox
Jun 30, 2014i'm having issues with my macro, and trying to view the string in a msgbox ,but having issues doing so:
how can i view strSourcePathname in a MSGBOX?
Code:
Sub CopyPaste()
Dim strSourcePathname As String, Report As Workbook
Dim ws1 As Worksheet, ws2 As Worksheet, ws3 As Worksheet
[Code].....
VIEW CODE Deactivated
Apr 28, 2007I work With Excel 2003
When Creating Data Sheet And Making Pivot Table
When I Make A right Click On The Pivot Sheet
The " View Code " Is Deactivated
As In the Pic
Spreadsheet View In A Userform
Oct 22, 2007i am trying to use this code to view the workbook (WK) in the userform named WK
it can not reconize .spreadWK
Private Sub UserForm_Initialize()
Me.SpreadWK.Cells.Range("A1:E10").Value = ThisWorkbook.Worksheets("WK").Range("A1:E10").Value
End Sub
however this is saying that it can not reconize
.spreadWK