Hi Experts

I am stuck with something and I am not able to find the solution for it from last week. I tried many option and sirf net, but the end result is Zero.

I have created a Macro in VBA which send multiple mail for a go from excel to outlook. I somehow manage to get a code from Ron website to add a table in the body of the outlook. I am stuck with last option. I am looking for something like the value of the table should be changed for each mail.

Hi,

I need an VBA to Transpose the Data from excel to word based on given criteria(status)

I have an excel sheet “Properties”

I want to transpose the few records from sheet “Properties” from to msword as per given below format by clicking Macro button (EXPORT PROPERTIES)

*RESIDENTIAL PROPERTIES ON *RENT
(*RESIDENTIAL/COMMERCIAL/AGRICULTURAL)
(*RENT/SALE)
Property Code:Column “C”
Property Type:Column “F”
Flat type:Column “G”
Area:Column “H”
Location:

Hi
I have a list of 4 suppliers for a business i would to everytime one certain supply is selected and the invoice total is entered for it to add them together and give me a total for a month on a separate sheet is this possible? E.g. If I select Microsoft on my drop down menuand enter 110 pound as a invoice total when I enter it again in week 2-5 with different invoice totals I would like it to be able to give me a total relating to the selecting supplier rather than the amount hope you understand this

Thank in advance
:)

I have an excel data sheet which is divided into data blocks of variable number of rows.
Data blocks are separated from each other with an empty row.
What I am in a dire need for is a macro that highlights the last row of each data block; which is the row above the empty row.
Can someone help me with this request please?
Thanks in advance

Hi everyone,

I wanted to get my file lighter but i noticed that when I supress all the sheets, the file still has a 324kb memory.

I spent a lot of time on forums to look out why and none of the techniques described have worked with my file. To recap, I already tried to supress all lines and columns, formats, names and hidden names. I also emptied the clipboard and the working memory of the file as so as macros.

You can find attached the file I'm talking about.

Thank you very very much in advance,

Have a great day,

Xta

Hi All,

I have company name in Column A and their respective address in Column B. I want to check, how many companies / what are the companies that share same address.

For example: Microsoft and Yahoo have same address as 1 Microsoft Way.

Regards,

Nirmal

have an inventory sheet for a clinic id rather not have to re-create, anyone know of/used any software/vendor to restore excel data quick and easy? free is obviously preferable but if its cheap i cant complain, 3 hours of work in it so if its expensive ill just redo the inventory.

/havent had time to google yet, maybe tonight

I want to enter a number into a cell, press enter, and have that number searched for on Amazon.com automatically. Is this possible in Excel? Would 2 sites be possible?

Thanks.

I have several excel files stored on my system. I used these files from the same computer daily. Yesterday, when i tried to open several files in Excel 2007 then i found following error on my co,puter screen: "Excel connot open file (filename) xlsx because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file" How fix it?

I have ''x'' set of numbers (say { 1.3, 2.7, 3.8, 1.9, 8.2, 1.5, 18.4, 22, 5.3}) which I want to group in ''y'' (say 3) sets with each set totaling to an approximate value of ''z'' (say 7).

How can i do this using excel?

Hi,

I have a problem with some excel VBA. I describe it in this link:
http://stackoverflow.com/questions/27171840/delete-row-button-deleting-o...
Please , take a look and help.

Thank you.

hi,
i am trying to get data from website into excel, but i am facing problem, can you please help me here is my code.

Sub VerifyVatTinFromMahavat()
Dim RowCount As Long
Dim sht, ele As Object, TIN
Dim objIE

Set sht = Sheets("Sheet1")

RowCount = 1
sht.Range("B" & RowCount) = "Name as per Dept.Record"
sht.Range("C" & RowCount) = "Active/Cancel Dt"
eRow = sht.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row

Set objIE = CreateObject("InternetExplorer.Application")

With objIE
.Visible = True

Hello all - new to the forum here and look for some help with a formula I am struggling with. I am looking to get a weighted average based on 2 different columns with a lookup on a variable in a 3rd column. For example.

A B C
Text 1 100 80
Text 1 80 20
Text 2 150 30

What I am trying is to match to a text value in column A and then take the weighted average of the values in column C based on the values in column b.

Currently, I am using =SUMPRODUCT(A:A="Text 1",C:C,B:B)/SUM(B:B)

Hi,

I was wondering if someone can help!!

Excel 2010

you have 2 sheets,

In 1st sheet you have a stock list of equipment etc.. with a status tab (New or Deployed, DOA etc...) and a status date (This is the date the action was imputed)

In 2nd sheet you have a list of the device name for example, then you want a list of all the changes to the status tab and date (like a time stamp)

Ideally every time you change the status tab not only will it change the date on sheet 1, but i want it make a copy in sheet 2 over several column,

SHEET1
--------

A B C

hi,
for speed, different users need to copy & paste text from various spreadsheets into
cells a:1 to a:10. the various spreadsheets have different formats which ruins the look of cells a:1 to a:10. how do i protect the format of a:1 to a:10? am aware that you can click the down arrow to the right and select values only after pasting but not every user knows or cares about this so it needs to be automatic.

hi..
i want to appear expire date in day.., question is "sheet2=mly or qly or sly or yly, sheet3=act_date, sheet4=expired date" i need to appear if sheet2=mly then add 30 days, and appear how many days remaining to expired in sheet4 automatically from today, and if sheet2=qly + 90 days, and appear how many days remaining to expired like that,,, and sly=180 days and yly=360 days, so how can i make this report,,,,

Hi,

I need help to create a macro that would auto refresh the Digital workflow application every 15 mins and take a screen shot of the application and send an email to a specific email address.

would that be possible to do ?

As I was doing calculation for future value; all the numbers turned red. I right clicked the number to format cells; after I clicked numbers tab. The only other options were in parenthesis or negative sign. I also went on to text color and tried changing it to black and it still wouldn't. I got the calculations right, it is just that the color turned a different color. Is there a reason to why this happened? What can I do to fix it?

I am looking for way to match the data from Sheet 1, Column's B & C to Sheet 4, Cloumn H. If there is a match, return the value from Sheet 4, Column C in the same row as the match to Sheet 1, Column A beside the info that matches. Please tell me that there is a formula for this?

I need to track slippage on projects. I have a 'baseline' date and a 'latest forecast' date, so can easily identitfy that slippage has occured and when, using TODAY(). However, I need to record the date the slippage FIRST occurred - in other words, I only want to do the date comparison once. If I do an 'if the date slippage first occurred cell is blank do the comparison' I get a circular reference. I'd be grateful for any suggestion as to a workround.

=IF(C3<=2,150,IF(C3<=5,B3*0.11%,IF(C3<=10,B3*0.1375%,IF(C3<=50,B3*0.165%))))

how do i add a rule that if B3=0 the (IF calculation) wont take place-(the above formula is in D3) so if B3=0 D3 =0

I have two sheets. Sheet 1 and Sheet 2.

If the data in Sheet 1 Column A matches the data in Sheet 2 Column C, then I want the corresponding data in Sheet 2 Column D to populate into Sheet 1 column E.

Can anyone help with this? Too vague?

Greetings!
I am having issues with an index/match formula and I am hoping to receive some guidance on how to fix it.

I need to look up a value, say in cell F7 that goes to a table of data (table range is I7:AO64), MATCHES the value in cell F7, and returns the name of a country associated with the value in F7 - the names of the countries are listed in the range I4:AO4 (single row).

The formula I have right now, that is not working is:
=INDEX($I$4:$AO$4,MATCH(F7,IF($I$7:$AO$64=F7,$I$4: $AO$4),0),7)

Can anyone help me correct this formula?

Thank you!

 Hi, I have two tables like this:

I have unlocked all cells except headings. When I protect sheet, The Format cells tab won't let me delete rows, but I can insert rows. Also, after sheet is protected I cannot right click to get the format cells anymore. They all work before I protect the sheet and I have checked the unlocked cells, insert rows, delete rows and use auto filter. Can anyone tell me what I may have done to lose these items after sheet protection?

Hello,
I have a spreadsheet containing over 400 rows of data and 7 columns. The number of rows change from each week. I need to create a macro that can create a new sheet for each row. Also, on the new sheets data would begin on row 13, and new sheet would be named whatever the ID number is. See below for example.

Example sheet 1
ID Name Nickname Position Department Sub-department Q1 2015 Score
210033 James Franco Jimmy Cost Supervisor Finance Accounting 97

Hi ,

I wan to separate the name from text to another cell as Ashworth Neil for the below text

Ashworth Neil08-12-2013STD
Bell Joseph08-12-2013STD
Bin-Dory Mbarak08-12-2013STD

Please provide the formula..

Thanks

Karunakar

In class, we were given a set of data which we formatted into a data table. We were instructed to extract data using a number of different criterion. Some of the values were numerical, such as age, sales, etc. and other values were letters which represented sex, District, etc.

HI, I am trying to make a table using other worksheets as references.
I am very new to excel and doing this for company. I am having difficulty using the VBA cuz this is my first time ever to use VBA. Here's what I need to make code for.

-Find matching chemical element from main worksheet in my reference worksheet ( "C" for 1st run)
-Copy the values on the same column of matching chemical element and paste them onto my main worksheet table
-Go to Next chemical element and do the same (now it will be "Mn")

Hi Folks

I have a problem! After being pointed in the direction of the Microsoft pages for assistance with Check out & Check in documents via VBA.

After some investigating and general searching I have managed to nearly get what I need but need asistance with the following

Please could someone advise how to change the following to apply to a number of other excel files on Sharepoint at the same time? i.e check out the file mentioned plus others named "Planning Team" for example

Sub test()
Dim docCheckOut As String