I am making an invoicing sheet. for the Invoice# I am using
=CONCATENATE(RIGHT(YEAR(TODAY()),2),"-",MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256))
thinking ahead.. when th...
I am trying to write a macro in Excel VBA, and i've created variables (global variables), as Excel Worksheet objects.
Then, in one sub procedure I'm using the "Set" statement to assign a pa...
I have an Excel workbook that I have password protected. I cannot remove the password. When I unprotect the workbook and save it I continue to get asked the password when re-opening. Any id...
Hello Experts,
I am using the following formula =IF(VLOOKUP(H63,'DATA INPUT'!$A$6:$EV$28687,MATCH($O$64,'DATA INPUT'!$A$5:$EV$5,0),FALSE)=0,"",(VLOOKUP(H63,'DATA INPUT'!$A$6:$EV$28687,MATCH...
Dear Expert,
It looks like the Excel built in data validation dialog box under "Data" menu can accept only lists residing on the same worksheet as the validating input cells. Is there anywa...
Using excel VBA, want to be able to automate getting historical market data from finance.yahoo.com/q/hp?s=qqqq for example, into a worksheet named qqqq in myWorkbook.xls (one wonders how they...
In range "data1", the following code is used to locate the first occurrence of strSt. In this sample data, the first occurrence of "NV" (strSt) is in row 886 but the code below shows it as 921...
Hello.
Is there a macro that could scan all the rows and look for any instance of " > " and remove any text that appears after the " > " symbol?
For instance,
Old Row 1: Football > Spo...
I have a complex workbook with over 50 sheets with many macros all working well (thanks to help here!).
One new sheet uses a goal seek technique to calculate the payment due on a funding lo...
I have a VBA function that creates text inside a range of cells. How do I tell "on the fly" that the text going into that cell should be a hyperlink? Id like to be able to set the destinatio...
This is probably an easy for all you excel experts - Have a column with a company names - need to have the first 8 characters of the name extracted and placed in another column. Can anyone he...
Experts-
I am trying to run the Essbase Zoom in function through VBA in Excel but for some reason the zoom in fails. I think it has to do something with the way I have defined the range but I...
I need to unhide a worksheet with a button while keeping the workbook protected.
Okay this is probably the most dificult question I have asked the Experts here. I need a year long calendar for 2007 and need to be able to change it easily to 2008 and so on. Alright here is ...
I am trying to sum a table. Columns B,C and D contain Region, Country and Customer. Column H contains the values.
What I want is a SUMPRODUCT type formula so I can have totals underneath t...
Hello to All!
Sounds simple, but here goes:
Can you create a function that deletes all Non- Alpha Numeric characters from a string?
For example: I frequently import Excel files into A...
Hello to All!
<This is not a Re-Post!) but a different Question!
This has got to be simple, but I can't figure it out right now.
Assume In Cell A1:A25 are the numbers 1 through 25
...
I have a long spreadsheet and a macro that assigns the print area and formats some needed page breaks... but when the data is updated, some rows may be added or removed, and so my needs to cle...
I have an autoshape with this macro assigned:
Sub Iinternal_Use_Only()
ActiveSheet.Unprotect '"1234"
Application.ScreenUpdating = False
Rows("65:81").Select
Selection.En...
Hi - I need help calculating a future date but skipping weekends.
What should happen
Start Date Days to add Ending Date
10/3/05 10 10/17/05 ...
I am writing a macro that performs an autofilter based on variable critera, finds the range for one column of the result and copies that column into a transpose function in a named range.
M...
Hello experts i need to make some changes to a module within an excel 2000 spread sheet, the problem is that it is password protected and the guy that put the password on, no longer works here...
Is there any way in excel to delete rows where there is no data?
basically i paste in data to a sheet, but want to remove the rows where there is no data...
i.e. turn
row
row
...
Hey Everyone,
Up until last night I was always under the assumption that changing a cells .NumberFormat was for looks only, but now I realize that isn't true. I was wondering if someone mi...
