HI All,

I am encountering some issue, which I am sure some of you can help with.

I created the csv file from excel sheet. Now I have created a copy of that excel sheet in a new sheet, and I am trying to load that saved csv in the new sheet. But when I do that I see some cells formatting mismatch (can be seen in attached picture) though I clicked on preserve cell formatting at the time of import. How can that be fixed?

Will appreciate any help.

Sal

Verify data in 2 columns
I have a large excel file containing UK post codes (> one million rows)) in column A. In a second column (B) I have > 200 possible unverified post codes (correct format). I need to check whether those unverified post codes in column B appear in column A or not.
Is this possible. Any help really appreciated. Thanks.

Hi could anyone help with this, I am trying to get a display of NA instead of #div0! but cannot get the formula correct.

formula =C3/(24*B3)(if c3 and b3 contain no data then get the result of #div0!)
I have tried =C3/(24*B3)iferror(c3/(24*b3)),"na" but it returns an error.

Any help much appreciated.

I need a macro to group & outline rows based on blank cells & loop till the last cell in a specific column. In the example below, i wanted the macro to group rows 3, 4 & 6,7. Please guide me.

Hello,

I would like to send a table in the attached file to Outlook automatically using VBA. How do I do this? I have everything set up in terms of setting up distribution, subject title, and body. I just can't get my macro to copy the table (cells B3-K16) in the attached file to the body of the email. Can someone help me?

Thanks in advance,

GNY

SUNDAY AUGUST 25 2013 600 PM EDT

HELP ME PLEASE .

I AM TRYING TO DO A SIMPLE TASK .

FOR THIS TASK , I USE OLD EXCEL 2000
WITH WINDOWS XP and SERVICE PACK 3 .

I WISH TO OPEN AN OLD EXCEL FILE ,
CONTAINING ONLY CALCULATIONS AND NOTES .
THERE ARE NO REQUIRED EXTERNAL LINKS ,
SECURITY ISSUES , PROTECTIONS , ETC .
FILE HAS ONLY : FORMULAS , NUMBERS , TEXT .

I WISH TO OPEN A FILE , BROWSE - VIEW THE
FILE , MAKE NO CHANGES AT ALL , CLOSE FILE .

HOWEVER , EXCEL CHOOSES TO MAKE SOME TYPE

Hi,

In excel on 'Sheet1' there is an image of world map on which there are few points that are AutoShapes.

On 'Sheet2' i have data from where data like Employee count by Function for each country are to be shown on MouseHover/MouseOver event over the Autoshapes/country in 'Sheet1'. This should change at selection of a month.

I have attached an excel file for reference.

Thanks
Rahul V M

I am working on this sheet since long. Thanks for helping me when it is required the most.

This time, I have some weird problem.

You can see in the attached sheet, when we clicked on button to add new sheet, the sheet name i.e. Patient number is added to the sheet “TOC” in column “B”.

Now, in the patient sheet (newly added sheet) there are many dates named Scheduled visit date, actual visit date, etc..
There are 3 phase (sections) in the attached sheet. Again, the 2nd phase is divided in 3 parts.
Each phase & part has the Scheduled visit date & actual visit date.

Kindly find the attached excel file, and i have said my problem facing on it. If anyone can find solution please the step by step procedure how you resolved.

Thanks in Advance

Waiting for your Valuable reply

I have a pivot table that for some reason is not correctly totaling the data. When I sum the count column in the data and compare to the sum column from the pivot table - I am short. The two totals should match. Any suggestions? I copied all the data as values to see if there were formulas or something I didn't see but that didn't fix the discrepancy. What could possibly be causing this? I do not want to manually subtotal 60,000 lines of data!! I appreciate ANY help I can get!!

Hi all, I do not know VBA enough.
I'm trying to automate a calculation that takes these steps.
The excel file consists of several similar sheets, but with different number of rows (until more than 2000), and a separate sheet(I will call R) in which there are the results of the model.

I have a macro that copies multiple cells from my 301 worksheets in a workbook to 1 sheet. All of the cells are consistent as far as placement and contain text value except for 1 cell that is a summation of other cells. I am not quite sure how to code that particular portion so it copies the value only and pastes it in the worksheet. This would be similiar to doing a copy paste special but since I have 301 worksheets, I don't want to manually do this. Here is my code: cell j43 is the summation cell.

'seventh macro
'copy cells
Sub copycells()
Dim WS As Worksheet, wsum As Worksheet

Hi, so I have this table with lots of data, im wondering if theirs a way to make this information easier to view, im really new at this and any help would be appreciated.

Hi, I bought a new PC a month ago with WIndows 8 and Excel 2013. It worked fine until a couple of days ago when I started getting issues with Excel. Two issues occur regularly:
1. Excel freezes for a lengthy period of time (could be a couple of minutes) even though the underlying sheet is not large and no complex calculations are taking place
2. Excel crashes, or stops working and sometimes it is able to recover files and sometimes not.

I have this chart which needs to be plotted; tree planted in years.

Found this image on the Internet but I am not sure how to plot something like this.

Can somebody help me with this? (see attached)

I have this chart which needs to be plotted; tree planted in years.

Found this image on the Internet but I am not sure how to plot something like this.

Can somebody help me with this? (see attached)

Hi,

I have a named range which unfortunately covers three columns because the cells are merged (and unmerging is not an option in this case). What I'm trying to achieve is if a cell in the FoodCategory range is blanked out, that the corresponding food item in column D is balnked out also. With the code below, if I hard code the range it works fine. If I use the named range (commented out in the sample below) it fails because the named range actually refers to the range A24:C28 due to the cells being merged for the FoodCategory range.

How I can change in cell B1, value of the A1 cell in a sample like bellow:

from A1 3355789 to B1 35789

I have this file and need to count the continuous date value (=1)

I already made for each month but cannot make for several months.

Now I need to help: how to make formula for B70 have the result as the same B71

Can someone help for this file. Note that the format could not break for some reason

Good morning all,

Hi All

I need assistance with a macro that will delete Column A and Column F [in every worksheet] of the workbook

Also one that will delete Row 1 to Row 5 same conditions as the columns

Thanks in advance

I'm trying to make a macro that will search out an email address from a specific cell in a sheet and then send a pre-made email message to that address. It would be best if it used a script that allowed for sending without using outlook. (I've read a lot of codes that use CDO?)The message of the email will be on a hidden sheet in the workbook. Any help?

I am lost with an if statement and need some help.

What I'm trying to accomplish:

=if(J:J=1,sum(K:K),0)

I want if there is a 1 in column J, to add all the things in column K together, otherwise put a zero.

I am creating an open to buy tracking PO's cut, so I have a budget lined out and if in quarter 1, on a PO I spent 200.00, then I spent 200.00 again, I need it to add to 400 in another cell for me.

What am I missing?

Hi all,

I am an okay user of excel but I am trying to make a big impression on my boss. I am interning now and think I could solidify this into full time employment by pulling this off.

I have 4 data tabs, each tab has 5 columns (and a ridiculous amount or rows), 4 are the descriptors and the 5th is the information I want back.
On the result tab, I have 3 entry points and one fixed data point. I would like to be able to change the 3 entry points to produce a lookup from the data tabs.

I have a column of 200 mobile numbers.

I need to convert these into row of text in set of 4 mobile numbers

eg

12345678, 12345678, 12345678, 12345678

12345678, 12345678, 12345678, 12345678

12345678, 12345678, 12345678, 12345678

Plse give your expert advise.

Thanks

HI, I have a quick question concerning combining two cells to create a new formula.

In cell E5 I have a formula: =A1+B1+C1

In cell F5 I have: -1

I am looking for a formula that would give me the formula =A1+B1+C1-1 in cell G5

Thanks in advance!

Hi there!

I decided to make a couple of videos about MS Excel 2010. Could you please advise does it seem useful for you? Any comment is highly appreciated!

YouTube:
http://www.youtube.com/watch?v=ExfOQQscTyQ

Vimeo:
https://vimeo.com/69804135

My website:
http://brutalcapital.com/?cat=11

Regards,
Alexey

Hi, I've been trying to do a sumif with data from another excel file, I want to sum data from the other fille with a criteria based on dates from this same other file here's what i've done, but i get a error 13 type mismatch:

Private Sub Workbook_Open()

Dim XL As Excel.Application
Dim WBK As Excel.Workbook

'Date for comparision criteria
Set DateAc = Sheets("06-17").Range("E8")

Set XL = CreateObject("Excel.Application")
Set WBK = XL.Workbooks.Open(ThisWorkbook.Path & "\Budget-2013-14.xlsx")
Set Sh = WBK.Sheets("Transactions !")

Hi I need help calculating the sales per hour for a large amount of staff, for example I have a salesman working for 6hrs 46mins (06:46) and he sells 22 units. I need a formula to calculate how many units he sold per hour. I have tried a basic division but it doesn't work. I think I need some if functions but I am just not that good at excel.
Any help would be much appreciated.

Hi, doing a lot of work with charts and often need to copy charts from one worksheet (ws A) to another (ws B) to be reused using ws B data. Excel always refers back to the original data on ws A. Is there a way to copy the charts so that the worksheet references are not copied over but just the cell references so they could immediately be reused on the new worksheet (ws B) with data in same format as original (ws A). Thanks.