If I have a list of names in an excel spreadsheet, how can I title powerpoint slides from that list in excel, using VBA?

I am trying to find a more efficient way to create a sales report with forecasts and Quarterly totals for each sales rep.
• I will need to update monthly actual sales (sales people assignments may change)
• I will need to create a separate worksheet & file for each sales rep (19 sales reps w/up to 200 customers each)
• I will receive the files back from each sales rep to update forecast and prospects

I received original data in excel with columns for monthly sales and rows with the salesperson’s ID (each has several), the customer ID & Name

Morning,

I am sure there is an easy formula to do this, but basically I have Column A that contains a huge list of various Makes and Models of Cars in this format:
Ford Focus 1.6 Ghia LX

I need to split this so that just the Make goes into Column B and then whatever is left of the data goes into Column C as the 'model'.

Hi there,

Thank you for your time in advance.
I have a 2 part question.

1. I have a combo box on a multipage called "cmbx_Last_User_Name" which has a list of people. The user has to make a selection from the list, or if the name is not listed, the user needs to be able to enter it in the combo box.
The new name should then be 'added' to the list, which is a Named Range ("LastUserName") which is contained in the worksheet code named "ws_Validation_List" (not the sheet name).

How do I create a formula to do the following:

If C3="Flour" and B6="all purpose", "strong bakers" or "pastry" then string the following text into one cell: Flour+B6+H11+D13+J11+G11+F11+D14+M11+B11+K11+L11+C11 OTHERWISE, string the following text into one cell: Flour+Flour+H11+D13+J11+G11+F11+D14+M11+B11+K11+B6+L11+C11

The difference between the true and false is where cell B6 is located in the text string; so in the first condition B6 is after Flour, in the second condition it is closer to the end.

Have two columns of data that are ASIN numbers. I need to paste the ASINs into the two columns and be able to run a macro that will do a look up on column one ASIN to see if it is duplicated in the in the second column and if it is needs to alarm and turn ASIN red.

Please help with attached file. I want to calculate with formula the red,yellow and green marked areas. What I need help with is written in each marked cell. Thanks in Advance!

i have two grouped of columns in one worksheet like below:

(before)

i want a macro do the algorithm like below:
when (code=new-code) then (code=new-code && serial=new-serial && amount=new-amount)

after macro sort table i want get below result according to algorithm:

(after)

I'm the Information Technologist for a manufacturing company and have a Dell workstation running 32-bit Windows 7 and MS Office 2007. When the user attempts to open a particular Excel file, Excel complains that the file is corrupted. Yet other employees running Excel 2007 under either Windows XP or Windows 7 have no problem accessing that file. I've researched this on the Net and discovered it to be a rather common problem --- yet I cannot find its solution!

Hi, I have items that are only available in multiple Distribution Centers. Currently I have them in columns with each distribution center as a different column and each item that is available is marked with that distribution centers code. I need to have one column, then have one distribution code in the column. The only way I can think of doing this which would be time consuming would be to copy the item number into multiple rows and in the column that has the distribution code I would change code for the item that is available in each distribution center.

Hi,

Hope to get an asnwer here. I have given below table to show you example, what I want is set of strings in column B (sheet 1) should match its words with sheet 2 column a and sheet 3 column a if any word is found in sheet 2 column a which is also found in sheet 3 column a then that word should be excluded from the out put like for examples you can check the first column of sheet 1 column C - ideally it should have copied alina, tim but since alina is found in sheet 3 column a it is excluded from the output and only tim is copied. Hope I made myself clear. Thanks in advance.

Hi there, I've come across a most frustrating issue recently (using Excel 2007) regarding named ActiveX controls that reside on a Worksheet. Everything compiles and runs perfectly on my PC (Windows 7 32-bit/Office 2007) The file(s) in question are .XLS files, and when opened on another PC (Windows 7/Office 2007) as soon as the macros are enabled, it immediately opens the VBA code window up with one of my control names highlighted (e.g. "txtLName1") and shows the error message "Compile error - Variable Not Defined."

Please find attached Image I need to distribute Per day Qty in adjacent cells automatically with formula

Thanks and regards

I have two worksheets. One for accounts that are active or are pending account. The other worksheet is for inactive, cancelled or rejected accounts. (I use this file to keep account status up to date and for different reports on separate worksheets.)

i need a way to create a new separate file with just the active and inactive sheet I have two files that list all our contract sales so we have columns titles:
Date booked
acct status
customer name
acct number
Contract start and end date
contact info
etc

I have code VBA code written in MS Access 2010 (.mbd file) to write data into an Excel file (.xls file). Below is the code to write data into that excel file. When you run this code, it always throws Error#1004 "Application-defined or Object-defined error". When you debug the code (F8) or run it (F5), it runs absolutely fine with out any issues. I am still not able to figure it out on what exactly the issue is. This code works fine when executed in MS Access 2007.

Below is thr code that's getting executed and when it fails, the focus is set on the 3rd last line of the code marked in double astriek mark.

Your company is planning on purchasing a new stadium using a loan. The stadium price is $2,500,000 and
they plan to put $275,000 as a down payment. They have arranged to pay the loan off over 10 years using
monthly payments due at the beginning of the month. The Bank of America is ready to offer them a loan at
an APR of 3.75%
Part One:
1. In the worksheet called “Data Tables,” use the information above to fill in cells C3:C7, and
C10:C12.
2. Use PMT, CUMPRINC and CUMIPMT financial functions to fill in cells C12:C14. Have the

I would like to import data from event code 100 from the Microsoft-Windows-Diagnostics-Performance/Operational log into a workbook. I want to get 2 columns, one of the date/time and the other of the boot time. The know the log file exists in C:\Windows\System32\winevt\Logs as an .evtx type file. I don't know how to do this or what the VBA command is to do this. I have done a little VBA programming.

Hi Experts,

I have an excel like below,

Name Status Dates

Record 1 /Saved/Previous step/My Q/ Rework/ MY Q/ SAved/ Next step /01.03.2015/05.03.2015/07.03.2015/09.03.2015/11.03.2015/15.03.2015/25.03.2015
Record 2 /Previous step/My Q/SAved/ Next ste /02.03.2015/05.03.2015/09.03.2015/22.03.2015
Record 3 /Previous step/My Q/ Rework/ MY Q/ SAved/ Next step /05.03.2015/08.03.2015/12.03.2015/19.03.2015/22.03.2015/25.03.2015

Hi, Being self taught excel I am setting up my worksheet but cannot create an equation to get the correct answer. I wish to enter in a cell a number or a letter that will represent a costing value, that appears as this value correctly on another sheet i.e.
Sheet 1 Cell A2 1,2,3 or a,b,c etc to appear on
Sheet 2 Cell A2 as 30, 27.5, 25 etc

As I am setting up a pricing sheet I do not want the user to know the discount percentage.

I have played with "If" etc but get stuck due to wishing to have 9 referencing values. Multiplication does not work. Can anyone help please?

Help needed to fix spreadsheet.

I'd like to multiply two columns (let's say column A (A1:A706) by column B (B1:B706) so that in column C the answers appear as

C1 = A1*B1
C2 = A2*B2
C3 = A3*B3
etc.

I hope I've made myself clear. I'm a novice at Excel.

A1= 48 B1= 9 The result want in Cell G1 to K1 9 and the reminder Will be the 3 in L1

kindly tell me to save as a file in MS Excel 2007 by run/ record a macro, VBA or any other method.
File should be save in one folder with different names automatically or by entering file name manually. Please send me its coding or related video

Thanks & Regards

Hello guys I have a condition that I'm trying to get my posted amount is matching with posted/under post amount or not Please help me to solve my problem thanks.

Hey guys, I came across this forum and it seems like a nice place to ask those questions a bit too long for a Google search.
I haven't really used Excel much for anything else than simple scatterplots and simple linear regressions.
Now I've come across a task that I'm pretty sure can be done in Excel, but I don't know how to.

I have two large datasets. I need to sort this data in a way that I can't figure out how to do. I'm not expecting someone to do it all for me, but it would be nice with some suggestions as to which formulas I need to check up on.

Hey

The sheet I made has some weird error somewhere but I just can't find it. It is supposed to calculate a number depending on different values like object name and level. The first few entries work fine but then it starts to only work for levels around 5 and above. So if I select level 10 it works fine but returns N/A when I choose level 5. The thing is that for the first entries it doesn't matter which level I choose and it works perfectly fine.

Would be awesome if somebody could help me out here. Maybe I've been starring at it for too long I just can't find the error.

Hello All,

- i wanna link or videos teach me how to create tools and arrows which change tables and values by pressing on
- i wanna course link to teach me how to make advanced sheets

Hi
I have to urgently fix my report for this problem. Please help! :(

My report is as attached. My problem is that the WoW variance is calculated based on my two different pivot tables.
If I filter my Pivot1 my Pivot 2 is also filtered because of my slicer settings. Because I'm then hiding my Pivot2 which has previous week data which I use to calculate week on week variance.

Hi,
I am looking for a code to loop through cells and add them to the selection, in order to merge them all at end of loop.
Regards.

Hi I'm new and trying to learn VBA.

I am trying to make my code so that when A2 has some text in it, A1 displays "X" until A1="Y" (then the code stops).
But my code doesn't seem to be working and is causing excel to crash... Maybe it's too long?

My code is:

Sub test2()
Worksheets(2).Range("A1").Select
Do
If Not IsEmpty(ActiveCell.Offset(0, 1).Value) Then
ActiveCell.Value = "X"
ActiveCell.Offset(1, 0).Select

End If
Loop While Not ActiveCell.Value = "Y"
End Sub

Thanks a bunch