Hi, using Solver function to optimize some calculations and Excel runs the solver routine and announces it has found an answer. However this answer is the same as the starting guess even though the starting guess is not the correct optimal solution. Why is this. I can send you an example file.

I am building a macro (below) which changes the text "This is Brown colour" to "Brown" in col D. This works perfect. now in Col G (same row) I need to add "A" if the result in D is "Brown" and "B" if the result in D is "Red". Please help.

Sub Adv_Cert()
'
' Adv_Cert Macro
'
Columns("D:D").Select
Range("D2").Select
ActiveCell.FormulaR1C1 = _
"This is Brown colour"
Cells.Replace What:= _
"This is Brown colour", Replacement:= _
"Brown", LookAt:=xlPart, SearchOrder:= _

Please give me the code to prepare a consolidated report with the Titles of the books of all members as well as a report on individual Member with the Titles of the books.
The Member ID & Member's Name are in one excel file.
Book ID and Titles of books are in another Excel file.
Member ID, Date, Book ID of books either Given by the Friends Circulation Library or returned to the Library and in the last column G for Given and R for Returned are stored in another Excel file.
Thanks in advance.

Hi I have 2 set of number matrixes...

for example (A set) 1 ,2 3 ...10 and (B set (1 2, 3, ....10)

My data is in the form :
(A set) (B set)

{2 3 5 7 9 10} { 3 5 6 8 9 10 }
{2 4 6 8 9 10 } {3 6 7 8 9 10 }
{ 3 5 6 7 8 10} { 1 3 5 7 8 9 } ETC

What I need is to count how many times each one to one relationships occurs and total them ?
in a final matrix

For example
(A set)(Bset)
2 3 = 3
2 4 =0
2 5 = 2
2 6 = 2
2 7 = 2
...etc

3 1 = 1
etc...

I am really stumped & ANY help would be much appreciated

thanks Dan

In cell A1 I have value of 225
What formula to enter in cell A2 to get as result 9 (2+2+5)

How do I sort within a cell? For instance………… I have one-column table (all values in each row below are in *one* single cell).
MLDG,TOP,SIDE,PNE,384 OLD 839
EAR,POP,BLNK,106,27
EAR,POP,BLNK,106,27
EAR,POP,BLNK,106,27
EAR,POP,BLNK,106,27
EAR,POP,BLNK,106,27
CAP,FLAT,POP,BLNK,121
MLDG,TOP,SIDE,POP,120
EAR,OAK,BLNK,256,20.5
EAR,OAK,BLNK,256,20.5
EAR,OAK,BLNK,256,20.5
CAP,FLAT,PNE,BLNK,351 6/6-22
CAP,FLAT,PNE,BLNK,351 6/6-22

I have two worksheets with identical data on them but sorted by different columns. I would like to be able to enter new data in only one of the sheets and have the second sheet populate automatically.

Example:
Sheet 1 - firstname, lastname, sticker # - order by firstname
Sheet 2 - firstname, lastname, sticker # - order by sticker #

When I fill in or delete data on Sheet 1, I would like Sheet 2 to populate or delete the data automatically.

Can you please tell me how to do this?

Thanks
Mikki.

I would like to download ~150,000 text files from the internet and save these files to ~4500 different directories. If the 4500 directories complicates things, the files can all go to 1 directory.

I have the internet filepaths and the names I would like to give the directories to save these files in within an Excel file.

Is there a way to use Excel VBA to download and save these files?

Ideally Excel won't need to open the files, as I want to ensure formatting isn't changed.

Path to first 3 files is below.

I found some very useful code from an expert here, that generates a questionnaire from an inputs spreadsheet.

Is there a way to pre-populate some of the fields based on records in another worksheet? e.g. look in a database spreadsheet as it generates the form, pre-populate with fields from each row (record) and then save a copy of the form as a separate work sheet with the filename according to one of the fields (something like "First Initial - Last Name - Membership Number.xlsx")?

Hello, I'm Suzanne. Recently I need to merge two spreadsheet in Excel into
one Spreadsheet. The data in both spreadsheet is totally not the same and the
only link between both spreadsheet is the case ID. So, is there any ways that
I can merge two spreadsheet into one and accordingly?
Thank you

Hi all,

I'm currently trying to do some automatic processing of two CSV files.
What needs to happen is the following.

The CSV files come in on two weekly basis.
These need to be placed into two separate worksheets in Excel.

In the third and forth tab I want to see data that compares the information from the two CSV files.

One where it shows data that all the data that only shows up in CSV1
One where it shows data that all the data that only shows up in CSV2

Example

CSV1 CSV2 TAB3 TAB4
1 2 4 5
2 3 7
3 5
4 7

Good day All,

Hope you can help me!!! I have a sheet named template and index sheet. WHat i am looking for is on the index page i have a button that when you click it it opens a Input Box asking how many copies of the template you require. Lets say for example you put in a qty of 5 then the vba code needs to make a copy of the template and paste it 5 times on the same tab bar.

Hope somebody can help me this is quite urgent.

Regards
Wes

Hi, I am newbie here in excel VBA. How can I get the total number of days using the userform only given the ff:
textbox1-textbox2 = textbox3 (textbox1 and 2 should be in date format only)

and also how to calculate numbers in the userform only. Thanks guys in advance.

Hi,

I am trying to print different columns from different sheets on one page. I can get them to print on separate pages but struggling to find out how to get them onto one, if possible. Can anyone help with this?

Thanks

IF Select Screen Field (worksheet) Range N3 = Monthly,

I need Worksheets 'Tickets by Group', 'Top 10 Bill tos', 'Top 10 CSRs', Top 10 Categories', Top 10 Created by' to remove the value in the pivot table and then insert 'Created Month' as the new value. Then have all refresh.

IF Select Screen Field (worksheet) Range N3 = Weekly,

I have a tiny query.

I would like to have a script that create's a subfolders in the current folder of the workbook, linked to a value in a cellrange ( A1,A2,A3, .... would create 3 folders )

When I use next Script

Sub MakeDirs()
Dim MyRange As String
MyRange = Range("C1")
Dim vFolderList As Variant, i As Long
vFolderList = Range("I6:I" & Cells(Rows.Count, "I").End(xlUp).Row).Value
On Error Resume Next
For i = 1 To UBound(vFolderList, 1)
MkDir MyRange & vFolderList(i, 1) 'amend the directory as required (it must exist)
Next
End Sub

(cell C1 is empty)

Any help gratefully received. I have a s/sheet with thousands of times in a column (eg col1 below in 24 hour format) and would like these in an adjacent column in hourly intervals (eg in Col2 below
e.g.
Col1 ColB
00:23 0 - 1
02:54 2 - 3
09:07 9 - 10
15:24 15 - 16

Is there a formula I can run to enable?

many thanks
Vin

All Here is my code. I do not receive any errors but I can't seem to get it to function and make the changes needed.

First and formost, thanks for all you do. I am slowly learning alot about VBA and with your help I may learn faster.

I also have a link to the work books on my Skydrive account https:// skydrive.live.com /redir?resid= 4717926F71CD602F!109 I have spaces in between the link because it will not let me paste links on this forum.

Microsoft 2007 Excel Windows 7 Enterprise
I need Excel VBA code for the following; Main Workbook Name “Master Backshop.xlsm”

I have source file as given below.

Source Table
Name Score
Tony 12
Tony 24
Tony 10
Vinni 14
Vinni 32
Vinni 45
Babu 42
Babu 35
Babu 15
Babu 31
Ajay 16
Ajay 21
Ajay 13

The required result table has to come as
Name Sum
Tony 46
Vinni 91
Babu 123
Ajay 50

Cant get this one to work, i proberbly didt it wrong, so please help if you can.

=IF(E11=N;(IF(E12=N);IF(F11>F12);S;N;S);(IF(F11>G12);N;S))

Hope somebody can help me whit this, And thanks for taking a look.

My office has 6 branches (Br1,Br2…Br6)across India.
Under each branch there are 70 Managers(M1,M2…M70), each manager has one team(T1,T2…T70)
Under each manager there are 1 to N number of employees.(E1,E2…En)
I want to make one DB file(shared) in which these 70 Managers can update all details of each employee.These details may be put column wise ,for eg Column 1 contains Name,Column 2 contains Dob etc…Atleast there are 25 columns or details which I want them to update.

Hi,

I want to copy a range of cells from excel sheet to a text field of a web page. Below is my macro, while executing it 'm getting run time error 70. Please help me in resolving it asap

Sub GetTable()

Dim ieApp As InternetExplorer
Dim ieDoc As Object
Dim ieTable As Object

'create a new instance of ie
Set ieApp = New InternetExplorer
ieApp.Visible = True
ieApp.Navigate "http://sbm/BizSolo/OrderProcessStatusQuery/EnterQuery.jsp?dummy=false"
Do While ieApp.Busy: DoEvents: Loop

Hello Community,

Hello all,

I could really use the help of those much smarter than I.

I need help.

I need a VBA code for a worksheet to automatically insert cut paste a row from a range of unprotected rows to the range of protected rows once the user decides to do so.

I have a sheet called “Customer Stock” which has two tables called “Uncollected” and “Collected”.

I need “Uncollected” table to be unprotected and “Collected” Table to be protected.

Once the a Customer collects the goods, the user can cut and insert the collected row from the unprotected “uncollected” table to just above the first row of the protected “collected” table.

Hi all

I need help. If total day has achieved 90 days or more in G5 cell to G12, cell will change to yellow. If I wanted exact date cell achieve even 90 days and displayed in G14 cell , what formula that must be used.

Attached file for reference.

I am really new to the excel inner workings, such as macros and building xml and schemas, i have an xml that i would like to use as a template to build a spreadsheet around so the output looks like the xml file. i took the xml to an xsd generator and it spit out the (generic) file attached. the (mock) file is something along the range of what i would like to work off of. Also is there anyway that each row can be created as its own xml file? Because as you can see the xml file matches the firts row of the mock spreadsheet. any and all help would be appreciated.

Hi,

i'm really new to VBA, now i doing a stuff for myself which can track changes and move the data and store in another cells.

basically i look through the tutorial provided in the home page, and it helps me a lot, but i want to enhance it more.

- The excel sheet will auto refresh every 30 minutes
- after refresh, the value in cells changed (numbers) or maintain, then the VBA will copy the value and store it in a particular cells.
- time stamp when refresh and time stamp after copy the value to another cells.

Hi, I have not used excel for a number of years, and now that I need to I've come to the point where I'm stuck.

I've made a simple stock sheet where each stock item total remaining is taken to the next day - the next day being a new tab.

I'd like to auto create new tabs for the whole year 01 Oct 13 to 30 Sept 14

And I'd like each line item total to be carried over from the previous day.

I've tried using a micro record, and here's what it does (in Debug):

Sub Copy()
'
' Copy Macro
' create new tab
'
' Keyboard Shortcut: Ctrl+d
'
Cells.Select
Selection.Copy

Hi I have a table of information that has a list of Surnames in Column B and Column U, I need to be able to type a surname into the textbox and search by clicking the command button, resulting in the rows featuring the surname in either column will only appear. Plus when the textbox is left blank it will show all data again. Thanks, hope this makes sense.