Hello!

I am pretty new to VBA. Here is a rundown on what I am trying to do:

I have a function which writes to EXCEL every other time
It is unstable
There is a range in a Sheet, say Sheet1, called solution

there is a 2D matrix which I need to write to excel, let's call it matrix
The dimensions of "matrix" are n x 2

Worksheets("Sheet1").Activate

dim i as integer
dim n as integer

n =UBound(matrix)
for i = 1 to n
Range("solution").Cells(i,1).ClearContents
Range("solution").Cells(i,1) = matrix(i,1)
Range("solution").Cells(i,2).ClearContents
Range("solution").Cells(i,2) = matrix(i,2)
next

I have duplicate data in column A however each relates to a part unique record. I need to get data from columns C - F & I for all the unique records in A. In the second pass i need the data from columns B,G,H for all the records in A

So I'm a little bit lost as to how I can do this.

Thanks in advance

There is a cell named guess. A1
There is a cell named function which holds tfunct(guess) (ie links to the guess cell) A2
I then run "testsolve()" from another cell A3

Sometimes the error reads
"An internal error has occurred or memory was exhausted"
and sometimes it reads
ERROR 1004
method 'range' of object' _global' failed

see attachment

Hi All
This is my 1st time here and 1st post.

I got 0 knowledge on VBA code. Pertaining to the subject above, i had searched through google almost more than 8 hours. And i got this code,
Sub Create_PDF()
Dim MyFullName As String

Application.ScreenUpdating = False
MyFullName = Left(ThisWorkbook.FullName, InStr(1, ThisWorkbook.FullName, ".") - 1)
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:=MyFullName, _
Quality:=xlQualityMinimum, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=True
Application.ScreenUpdating = True
End Sub

Please help me to
11010
11011
11014
21020
21022
251010
101011
I want to get a result which will give roman i, ii,iii,iv etc if the diffence of succesive row is <10 and 2nd digit from right is same in two succesive cell.
Result Should be
1
i
ii
2
i
3
4

HELP ME PLEASE TO EXTRACT NUMERIC FROM A ALPHANUMERIC TEXT LIKE AB1234C, 123 NO, A123B456 ETC

I want to copy a range of data/blanks in one column of one worksheet to a second worksheet, eliminating any blank rows. Can this be done?
Tom Collins

Hello,

I would like to know if there are links on how to connect data in making invoice,summary,saving it to another workbook and doesn't slow your excel using VBA and without VBA. Example.How to make userform that transfer it to a data worksheet then make nice looking summary report.Best example for this is issue invoice with look up outstanding balance then less inventory. Better if the report have alarms like change color,pop up or message box that inform your needs.
I am looking on how to make one.how to connect them all together. It would be nicer with video.

Dear All, I have a problem with two excel sheets, which I need to synchronize. For example: Sheet1 and Sheet2

I have a table in Sheet1 from row 72, which is automatically get an information from another sheet(call Products). It has a VBA code which take the rows with product details with a specific logic. (Sometimes the table in Sheet1 has 1 row, sometimes has 10 rows). I need to synchronize that specific table with the Sheet2, which will be the main one and we can add all the information from Sheet1 everytime we include information from "Product" sheet.

Hi ,

Can i make an excel button, on the click of which the link EXCELEXPERTS.COM will be added to my favorites and sending an email(outlook) to ABC@EXCELEXPERTS.COM heading LINK ADDED.

Please anyone can help.....

Regards
Ruth

Respected Sir!

1... There is a requirement to make a "User-feedback Application" for the performance and teaching skill evaluation of the class room teachers. The feedback form will be e-mailed to each student and he/she is required to input the picture, and fields like, name, ID, remarks and the opinions, and, choose some options.

2... The feedback from all students would be received via e-mail, and is requried to be tabulated including picture and all the selected options/ remarks.

Hi,

I had a workbook with the following tabs of reports/data:

Employee Detail Info,
Wk1 Detail Time Sheet,
Wk1 Recap,
Wk1 Invoice,
Wk2 Detail Time Sheet,
Wk2 Recap,
Wk2 Invoice,
Payroll Working File, and
Payroll Summary.

The file was sooo big and was taking too long to process because of all of the formulas, so I decided to separate the tabs in the following workbooks:

A. Employee Detail Info,
B. Week One Detail Time Sheet,
C. 1) Week One Recap and
2) Invoice,
D. Week Two Detail Time Sheet,
E. 1)Week Two Recap and
2)Invoice, and

Hi, I'm student.
I'm looking for which are the best online course Microsoft Excel 2010 for Beginners?
Who know tell me.
Thanks!

how to attach hyperlink by using "cell" function...........?

Hello friends!!

I have a list of entries of people and their personal data which also include their birthdates. I also have an empty cell in each of their lines which i would like to have their zodiac sign automatically filled (through a formula)

I would like to have a seperate sheet with date ranges for the zodiac signs

THNAK YOU!!

In VBA i want to compare a cell value in one sheet with a cell value in another sheet using VLOOKUP (see below).

If (Cells(ResEnd.Row, rFind.Column) <> Application.VLookup(9400, ThisWorkbook.Sheets("Sheet1").Columns("F:G"), 2, False)) Then

MsgBox "Doesnt match"

End If

I am looking for a formula that includes total hours worked from 2 separate invoices located on 2 separate worksheets. I used the formula below:

[code] =INDEX(INV.A.WK.1[[Standard ]],MATCH(1,(INV.A.WK.1[Last Name]=$A17)*(INV.A.WK.1[First Name]=$B17)*(INV.A.WK.1[Location]=$AK17)*(INV.A.WK.1[Division]=$AJ17),0)) [/code]

however, instead of leaving the cell at "0" or leaving it blank, the cell contains "#N/A" which does not allow me to total the column with a value. I have attached the file for better understanding. Please refer to the BLUE tab titled "Bi-Weekly Summary Report".

Hello friends! i have a google docs excel file that i want to make some changes.

i have some hundreds of lines that consist of 3 rows. They are entries of some expenses and incomes of my company.
an example of a line would be 16/09/2012, Gas, -30 (3 rows which means that at 16/09/12 i spent 30 euros on gas),
another example would be: 17/09/2012, got paid from john, 50 (which means that at 17/09/12 i received 50 euros from john)

What i want to do is create a formula that would automatically create 2 set of lines (of 3 rows again).

Here's another CHALLENGE:

I am trying to extract data from a separate table in a separate worksheet to feed another table in another worksheet. I have attached the file so you can see what I am working with. Currently in the RED tab I have attempted one formula; however, this is not what I am looking for, completely. I like the formula; however, I would like to only update this table with individuals whose work status is "Active" as listed in the YELLOW tab. this is the formula that I tried; however, it did not work....

I need some help with a formula, but I am uncertain where to begin my search.

I have 2 worksheets labeled: "RECAP" and "INV". They both have tables labeled: "RECAP" and "INV.A" respectively.
Table "RECAP" has the following named columns (as defined by me): "RecapLocation", "RecapLast", "RecapFirst", and "RecapClass".

Table "INV.A" has the following named columns: "INVLocation", "INVFirst", "INVLast", and "LaborDesc".

(There are other rows; however, they are unnecessary for this formula.)

Hi,

I'm looking for a way to copy a graph from Excel, go into an open word document (with or without a particular name), paste the graph using the paste special "Windows Metafile" option, and then return to excel to continue with the excel macro. Is this possible?

Thanks!

hi everyone,

i will be really grateful if you could help me on a issue.actually i have to download an excel file from a website given below
http://www.mcb.mu/en/include/popup/download-forex
automatically.can you please suggest me how i can do this.another problem is that the file gets downloaded to excel in xml format.How can I change it to .xls format.Please find the excel sheet attached.i need the table in spreadsheet in xls format to carry out certain operations, please see if you can help me.

thanks,

shenaz :) :)

Hello Guys
This is a quick question but maybe with an complicated answer

Im making a very simple survey , this documents has a scale from 1 to 5
There's a way when i type there 0 "zero" or N/A (no apply) , the formula can be set automatically to calculate the resuelt without editing the dividend

A quick example will be:

Question 1: 4
Question 2: 3
Question 3: 1
Total = 8 divide / 3 = 2.666

But i want that calculate automatically the result without editing the formula
Example
Question 1: 4
Question2: N/A
Question 3: 2
Total= 6/2 = 3

Hello...Can someone help me in writing a macro which fulfils my requirement. I have an excel file contains around 10 worksheets named a,b,c and so on...... In "C" drive there is a folder where 10 workbooks (say 1, 2, 3 and so on) are stored. Every workbook there is a sheet named "price". format of price sheet in every file is same. Price sheet contains column A to Y. Workbook which has 10 worksheets is associated with 10 workbooks in such a way that worksheet A and workbook 1, worksheet B and workbook 2 and so on, are to be connected with each other.

Hi
I have two arrays say Xi(1000) and Yi(1000), I want to use match function in vba and find Match(Xlval,Xi(),-1),Match(Xlval,Xi(),1) so that i have x ordinate and in the same way I will find y ordinate and interpolate. Can i do this and how I should go to achive this

Please help me

HI everyone!

I'm new to the forum and need some urgent help with analyzing my master's thesis data. I've stumbled across the following problem and don't find a solution anywhere on the web.... :s

I have to calculate the duration of certain events using both date and time, since some can span from the evening of one day to the morning of the next, for example: "2012/01/01 22:00:00" to "2012/01/02 04:00:00".

I'm a beginner and have very less knowledge on VBA.

There are 2 worksheets in the attachment - 'Sheet 1 and Sheet 2'.

Once I run the Code on 'Sheet 1' I would like to see Data as on 'Sheet 2'.

Basically, I thought to write a lot of stuff here and ended up writing a lot and had everything deleted.

My thanks in advance to all the experts.. I using Excel 2007

Thank you...

Afternoon,

Im sure that this is most likely easier than it seems to be to me but what I am trying to do is the following

I have 2 Tabs in a spread sheet.

I want to populte the second tab with information from the first tab based on a certian criteria.

In sheet A i have 4 bits of information

Account
order number
service
date

In Sheet B I have
Order number
Service
Date

What I need to do is populate Sheet B but only with the accounts in the name of smith.

Hi,

I am using excel 2010 and my question is that I have data in many columns. Lets say I have to compare date of column B with Column A ,if(data of Column B) is found in Column A then delete entire row of column A.... if not found then column B highlighted with some color