Re: Macro for placing numbers between two numbers in other sheet
Just change the RFI_No variable from an Integer to a String.
Re: Macro for placing numbers between two numbers in other sheet
Just change the RFI_No variable from an Integer to a String.
Re: Merge Multiple Sheets to one Master sheet
fixed
Re: Macro for placing numbers between two numbers in other sheet
Try this.
Re: Take elements from Dynamically Array for Select Case
As is being noted, a case statement needs a comparison. Consider it a different form of if/then.
Understand you don't know the values, but, what do you want to do when you do know it? Are you trying to ensure they are within certain parameters? Even numbers? Difference between two elements?
If you are trying to do something with each element individually without knowing how many there are, you'll need to run a loop around your select/case and evaluate each element based on the loop variable.
Re: Merge Multiple Sheets to one Master sheet
You need to provide just a bit more information. When do you want the master populated? Just once a month? Every day? Are there any calculation cells on the original sheets (your example is very sparse). What about duplicate data between multiple sheets? Copy all the entries?
Re: Take elements from Dynamically Array for Select Case
What are the values in the array and what are you trying to "Select" on? The value in the element or how many elements there are?
Re: Macro for placing numbers between two numbers in other sheet
Have you tried anything yet and are stuck/getting an error or are you wanting someone to do the entire program for you?
Re: how to retrieve the internet time and paste it in Excel
The link you provided does not accept (from what I can tell) requests for time. You'll probably have to look up one of the NIST sites and determine what the format of the requests needs to be in.
Re: Macro for combining all worksheets in a folder including subfolder and do a vlook
Can you upload a copy of the worksheet that has the code and error in it?
Re: automatically refresh workbook links every minute
Take a look at the RaiseEvent and Timer functions in Excel VBA.
Re: run macro only when cells are visible
There is a "Hidden" property of the range object you could test to see if the row/rows are visible or not.
Re: Copy and paste a value of 0 as a blank cell
Do you have a sample sheet you could attach? That would help.
Re: Populating sheets information into 2 sheets; 2 different ways, times, formats
While you provided a good explanation and a sample, you didn't indicate what part you were having trouble with. A copy of your current effort would be helpful.
Re: Open text files in excel separate in columns
Yes.
Re: Log external data to new column at X intervals
Not knowing how you are getting the data and putting into the sheet it's difficult to say exactly, but, simply moving the selection after you put the new data in should solve the problem.
Re: Dynamic Charts formulas.
I think you'll need to attach a sample file showing where the error is and your expected/desired results.
Re: Forecast final score using updates made at intervals of X minutes
Best I know is to use the forecast function of Excel. You say it isn't working but don't indicate if it's giving you an error or just not the expected value. Do you have an example worksheet clearly indicating the desired/expected result?
Re: dynamically add rows to a excel template
Did you want inline formulas or VBA? How are you importing the data from the database? Would it be easier to just create a data connection to the database from Excel?
Re: Hide message box when updating workbook, this workbooks contains links that canno
There is a preference/option that you can turn on/off for updating external links. Have you tried turning that off for this document?