Computer Support Forum

Simple Excel Marco Help

Question: Simple Excel Marco Help

This is my current Macro....
'
' Owner Macro
'
' Keyboard Shortcut: Ctrl+g
'
Sub FillDown()
Dim LastRow As Long
Range("P3").Formula = "Owner"
LastRow = Range("P3" & Range("P3").End(xlDown).Row).Rows.Count
Range("P3" & "" & LastRow).FillDown
End Sub

I realized after this macro worked that I need it to actually have a little more beef to it in order to work the way we need it to.

Basically if there is a date in column N then I need the cell in column P to remain blank, and i need the words "owner" to end at the last row (not of the entire excel spreadsheet but if at the last row in column M.

If someone could help me it would make life easier!!

More replies
Relevance 100%
Preferred Solution: Simple Excel Marco Help

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Relevance 68.47%

currently i'm using Marco to write some basic program to run the calculation

for example i wan to A+B
is Total= "=A" + RowRange + "+B" + RowRange ....rite ?

if i wan to multiplier A*0.12...how to write it in Marco

hope u all know what i'm talking about
any help will be appreciate...thank ^^
 

Answer:Help ...Excel marco

Total = a1 + b1 adds together those two cells on that row. To add together more cells on other rows requires a for/next loop.
to multiply is as you have written it i.e. =a1*0.12.
 

2 more replies
Relevance 68.47%
Question: Excel Marco Help

Looking for some help trying to create a macro that could complete the following example (Each row is a row in Excel, and each large spacing is a column):

Going from...
IDxxxxx Region 1xxxxx Region 2xxxxx Region 3xxxxx Channel 1xxxxx Channel 2
1xxxxxxxx Xxxxxxxxxxxxxxx xxxxxxxxxxxxxxXxXxxxxxxxxxxxxxxXxxxxxxxxxxxxxxx X

To this...
IDxxxxx Regionxxxxx Channel
1xxxxxx Region 1xxxxxChannel 1
1xxxxxx Region 1xxxxxChannel 2
1xxxxxx Region 3xxxxxChannel 1
1xxxxxx Region 3xxxxxChannel 2

Any assistance would be greatly appreciated.
Thanks,

 

More replies
Relevance 68.47%
Question: Excel Marco

I was wondering if anyone knows of a Macro for excel that logs hours?

I need to know how many hours I have worked on a certain project at work.

For example, I would like to be able to have macro which meant i could open excel, choose from a list of my current projects and it times how long i have worked on it, and how many hours I have worked in total for the week.

So when I come to entering my hours to be paid, I know how many hours i have worked in general and how many on each project?

I am using microsoft excel 2010
 

Answer:Excel Marco

Hi, welcome to the forum
Here's link I often use to look for ways of approaching things
http://www.cpearson.com/Excel/Topic.aspx
Check under the T where you'll see different topics about time handling and calculation.

If you have a sample file and want me to take a look, just attach a copy with sensitve data of course
 

1 more replies
Relevance 67.65%

I have a Macro written by another person that I can't figure out and he is not available to help. This macro makes 31 copies of a spreadsheet and saves them in one directory with the file name increasing by one (DR090401, Dr090402, etc) The fourth line has turned red which leads me to believe it is the problem. I can not find any help on the function at all. The Macro is as follows:

MAKE31DR (m)
31DAILYREPORTGENERATOR
=ECHO(FALSE)
=FOR("ROW.NUM".1.100.1)
=CALCULATENOW()
=SELECT("R8C51")

Those are the first 6 lines out of 17. I haven't a clue as to what the =For is for.

I appreciate any help or guidance you may give.
Thanks much.
 

Answer:Help with Marco for Excel 2003

I've never seen macros written with equal signs, no do I recognise those instructions. Would you upload a sample file?
 

1 more replies
Relevance 67.65%

Hey out there,
I need a vbscript or an Excel macro that will do the following. In column A there are 300 cells each with a identifier that is 8 alphanumeric characters; I need to take each cell from column A and search each cell in Column B for a match. Now the cells in column B has cells that have a bunch of text in each, which may or may not have the contents from Column A cell within it. If there is a match then I need to move the searched for value into column C, if there is no match I need to move the searched for value into column D.
I have tried a number methods but keep running into run time errors, i have not programed in years and have been frustrated by what use to be a simple task for me.
Any help world be greatly appreciated
Paul
 

Answer:Excel Marco or vbscritp

7 more replies
Relevance 66.83%

Hi All,I've got a real problem with Excel since a complete system reinstall was preformed. When ever i try and run a macro a horrible error message saying "Error 429: ActiveX Component cant create object" has anybody had this error before or know how to fix it ?

Answer:Error: ActiveX - Excel - Marco

There's quite a bit about this on the web forums, but the main implication is that Office did not install correctly.click hereclick hereor simply type <Error 429: ActiveX Component cant create object> into your favourite search engine.

10 more replies
Relevance 66.01%

Hey guys,

I've used this script that I found on a tutorial somewhere many many moons ago and was hoping I could get someone to help me update it.

Essentially when double clicking on a cell, it changes the font to Symbol and adds a tick to the cell.
Code:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
With Target
.Value = "÷"
.Font.Name = "Symbol"
.Font.FontStyle = "Regular"
.Font.Size = 11
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
End With

End Sub

Could anyone help me assign this macro to only a certain cell range? e.G. C1 to D50 please?

Thanks
Matt
 

Answer:Solved: Question on VBA marco in Excel 2010

hi

give this a try
Code:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If (Selection.Column = 3 Or Selection.Column = 4) And Selection.Row <= 50 Then
Cancel = True
With Target
.Value = "÷"
.Font.Name = "Symbol"
.Font.FontStyle = "Regular"
.Font.Size = 11
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
End With
End If
End Sub

 

3 more replies
Relevance 66.01%

hi to all,

i'm writting a marco to populate the row and col in the spreadsheet. I provide an form interface for the user to key in the data before reflect the data in the spreadsheet. my question is how do i detect the first blank row and transfer the data into that blank row in the spreadsheet.

i only have 9 columns and therefore i hardcode the colum, however, i need to find the blank rows so as to insert the data.

Cells(currentRow, 1) = txtTime.Text
Cells(currentRow, 1) = txtDate.Text

can someone tell me how to fiind the index of the rows???????

Thank in advance
 

Answer:excel marco programming detecting blank row

The code you have writes txtTime and txtDate to the same cell. Try:

newrow = Range("A65536").End(xlUp).Row + 1
Cells(newrow, 1) = txtTime.Text
Cells(newrow, 2) = txtDate.Text

, assuming you have at least one row already.

I couldn't tell you what data type to use for newrow. Zack could tho', he might drop by later.

HTH,
bomb
 

3 more replies
Relevance 66.01%

Hi,
I have a spreadsheet with columns A-F. I would like a macro that would give the user an input box to input invoice numbers (column A) and if found, put the entire row on a new worksheet. User should be able to enter several invoices, then hit a finish button to move those particular invoices to one seperate worksheet. Any help would be appreciated.
 

Answer:Excel Marco with Input Box to filter data

Welcome to the board.

In a fresh sheet, enter 123 in A1, 456 in A2, 789 in A3.

Your starter code is:

Sub test()
Response = InputBox("Enter invoice number(s) to search for, separated by ''#''") & "#"
If Response = "" Then Exit Sub
x = Range("A" & Rows.Count).End(xlUp).Row
For Each Cell In Range("A1:A" & x)
If InStr(Response, Cell) <> 0 Then
MsgBox "Row " & Cell.Row & " should be copied over."
End If
Next Cell
End Sub

If you (run it and) input 123 you'll get a message "Row 1 should be copied over."; input 123#456, you'll get 2 messages for rows 1 & 2.

Now: please think about how numbers could be entered incorrectly such that it might not work; then we can figure out how to cater for user "creativity".
 

1 more replies
Relevance 65.6%

I found this VBA code for excel marco but it is creating new sheets from a list based on the date. However, I was curious if this can be changed to loop through the data list and create a new sheet for each unique customer.Sub CreateMonthlySheets()Dim lastRow, mMonth, tstDate1, tstDate2, shtName, nxtRowOn Error Resume Next'Make a copy of the data sheet and sort by name Sheets("Sheet1").Copy After:=Sheets(1) Sheets(2).Name = "SortTemp" With Sheets("SortTemp") lastRow = .Cells(Rows.Count, 1).End(xlUp).Row Rows("2:" & lastRow).Sort Key1:=Range("A2"), Order1:=xlAscending 'Using SortTemp Sheet, create monthly sheets by'testing Month and Year values in Column A'Loop through dates For Each mMonth In .Range("A2:A" & lastRow) tstDate1 = Month(mMonth) & Year(mMonth) tstDate2 = Month(mMonth.Offset(-1, 0)) & Year(mMonth.Offset(-1, 0)) 'If Month and Year are different than cell above, create new sheet If tstDate1 <> tstDate2 Then ActiveWorkbook.Sheets.Add After:=Worksheets(Worksheets.Count) 'Name the sheet based on the Month and Year ActiveSheet.Name = MonthName(Month(mMonth)) & " " & Year(mMonth) End If Next On Error GoTo 0 'Loop through dates, copying row to the correct sheet For Each mMonth In .Range("A2:A" & lastRow)'Create sheetname variable shtName = MonthName(Month(mMonth)) & " " & Year(mMonth)'Determine next empty row in sheet nxtRow = Sheets(sht... Read more

Answer:Excel marco: Create new sheet from list of data

Where is the customer information located in the worksheet? Do you have any Named Ranges? How do you want the new sheet populated?

2 more replies
Relevance 65.6%

Hi using Win 7 Excel 2007.

I have a multi-sheet workbook. When I did a "subtotal" on one sheet, Excel created new columns (1,2,3) for those subtotals.

When I copy a row(s) from this sheet to another, Excel insert these new columns on the new sheet.

(1) I just want the data from that row, I don't what the subtotal columns on the new sheet! How do I turn off these subtotal columns?

(2) question: I'm using a MACRO to copy the data row(s) from the first sheet to the second. When I open the Excel,
It has a "security Warning Macros have been disabled." message. What do I need to change to have the Workbook open with Marcos enable? Also does it matter if my Marco is "private" or not? Now it's not private.

Thanks!
 

Answer:Solved: Excel Marco and Subtotal function issues

6 more replies
Relevance 65.6%

I have an excel workbook with a "INPUT" WkSht, and a "ACTIVE" WkSht.
INPUT has a dropdown menu that looks up a list in ACTIVE, locates a desired value, and displays several cells contents in ACTIVE, - in the INPUT page.
This is working.

Question 1:
One cell in ACTIVE contains "comments" - how do I display the comments in the cell from ACTIVE, in a cell in INPUT - so I can look at all of them.

Question 2:
How do I update the contents of a cell in ACTIVE, at the same location that was selected from the dropdown.

I am a beginner - please help.

See present MACRO below...

Sub UpdateLogWorksheet()

Dim historyWks As Worksheet
Dim inputWks As Worksheet

Dim nextRow As Long
Dim oCol As Long

Dim myRng As Range
Dim myCopy As String
Dim myCopy2 As String
Dim myCell As Range

'cells to copy from Input sheet - some contain formulas
myCopy = "D5,D6,I18,D20,D19,D8,D10"
myCopy2 = "D5,D6,D7,D8,D9,D10"
Set inputWks = Worksheets("Input")
Set historyWks = Worksheets("Payments")

With historyWks
nextRow = .Cells(.Rows.Count, "A").End(xlUp).Offset(1, 0).Row
End With

With inputWks
Set myRng = .Range(myCopy)

If Application.CountA(myRng) <> myRng.Cells.Count Then
MsgBox "Please fill in all the cells!"
Exit Sub
End If
End With

With historyWks
With .Cells(nextRow, "A")
.Value = Now
.NumberFormat = "mm/dd/yy"
End With
.Cells(nextRow, "B").Value = Application.UserNam... Read more

Answer:Excel Marco Dropdown Menu Cell Contents

please do not duplicate
As your other post is in the Business Applications forum
continue there
http://forums.techguy.org/business-applications/899510-excel-marco-dropdown-menu-cell.html

closing this post
 

1 more replies
Relevance 47.97%

I have done some elaborate things in Excel VBA before, I even automated my week's work into one huge Macro, and yet today I have turned temporarily stupid. Granted I am usually piecing together code snippets since I'm not a true programmer, but this seems so simple.

I'm trying to make a worksheet that conjugates Japanese verbs. I can do everything except this one simple little thing. When users click on a word on Worksheet C, there is a button they press that copies the word and pastes it into cell A1 of Worksheet A. For some reason I can't get it to post into A1, it throws an error and I don't know why. I have run through the process and recorded the macro several times and it records it fine, but when I run it, I get this error.

Selection.Copy

Sheets("Display").Select
Range("B1").Select

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False

The troublemaker is Range("B1").Select. Everything else works fine. I simply want the copied data to be pasted into cell B1, but it won't.
 

Answer:Simple Excel VBA question

11 more replies
Relevance 47.97%

"You can create a______ reference by deleting the $ from the row reference in the cell reference $B$6"

I have missed this question twice now...LOL....it's NOT simply "relative". I am thinking perhaps "mixed". But at this point I just am not sure.

Any help with this simple question would be greatly appreciated.
 

Answer:Simple Excel Question

10 more replies
Relevance 47.97%

I have done a simple income/expenditure sheet where f2+g2=h2, then i made the next line add the previous balance so i get a continual balance(h2) increase in the last column.

I dragged the second formula down the page to #200 but now i have a complete column of 0.00 or whatever is the last result.

Can i make it so the cells are blank until i add a new entry?

Hope that makes sense, any help very much appreciated

Thanx
 

Answer:Excel: simple sum help needed

16 more replies
Relevance 47.97%

This must be me having a bad day!

Both L2 and L35 are Number fields with 2 decimals places.

Cell L3 has:
=IF(L2<>L35,L2-L35,"")

Obviously it should return the difference or a blank cell.

Wrong its returning 0.00

Any light on this appreciated.
 

Answer:Excel Simple Problem

7 more replies
Relevance 47.97%

Hi and sorry but I have a very limited knowledge of Excel and need help quickly.I wish to count any cell in a row that has a value in it. The value is not relevant, just the fact that the cell has content.How?

Answer:Simple Excel Formula

The Function is Count. eg. =count(a1:z33) and press enter. Place the cursor in the cell you want the answer to be and type in the Function.

3 more replies
Relevance 47.97%

Perhaps it's too simple for me to understand...or I'm .....

I want to create a manual macro that will allow me to add 85 to whatever value may currently be in the cell. Nothing automatic...no if/then scenario.

One of those things that I can normally do with my eyes closed but can't seem to make work.

Any help would be appreciated.
 

Answer:Simple Excel Macro Help

8 more replies
Relevance 47.97%

hi, I just need a simple formula I have a template for an invoice here...

There is the SUBTOTAL
[email protected]%
and there is the TOTAL
The TOTAL is got by adding on a VAT @ 21%....but what formula do I put in so it will calculate the vat every time in the template?

your help would be much appreciated.
 

Answer:Simple Excel Formula Plz

The formula would be the subtotal cell (in this example we'll use C5) times .21:

=C5*.21

Then, you would likely format the cell and select "Currency".
 

2 more replies
Relevance 47.97%

Hi everyone,I am trying to use Excel for the first time for many years. I can do the formulae etc but seem to be missing the basics like how to align the decimal point in a colomb or resize a cell.Can anyone suggest a suitable source of info pleasethis is an old 2000 version and the integrated help is not very good.Thanks Ray

Answer:New to Excel, need simple starting help

click heretry this one Noldi

10 more replies
Relevance 47.97%

Good morning all,I am learning how to write a simple Macro program in Excel:A                B                 C===         ===             ===Jame        Apple           AppleTom         Orange         AppleDavid       Apple           Apple-------------------------------------------Here is the code:Sub testing()For N = 1 to 3If cells(N,2).value=cells(N,3).value ThenRange(corresponding-value).copyRange(corresponding-value).pastespecialEnd IFNextEnd Sub------------------------------------------------------------------------The program will copy specific rows when the cells in colum  B equals those in column C,and then it will paste the specific rows of data somewhere in the same worksheet.The program works but it returns empty cells.Here is what the result looks like:=====JameEmpty cellDavid=====Is there any method to skip the empty cells?Please kindly help if you could!KittyP.S. I am using Excel 2002

More replies
Relevance 47.97%

But I am so tired toniht that its slipping awayHow to set up a sheet with percentages in B(4%) C(4.25%) etc and the ammount in the A column, A2(100), A3 (200) so that B2 will show 4 and A3 will show 8 etcAndy

Answer:Probably a simple Excel question

With:B1 set to 4%, C1 set to 8%A2 contains 100A2 contains 200In B2 enter=$A2*B1Hover the cursor over B2, when it turns into a + drag to right and down to copy the formula.

2 more replies
Relevance 47.97%

Hi everyone
First question, so please be gentle.
I have 3 columns of numbers in Excel - all populated via VLookup formulae.
Do you know how I can write something to compare these to a few numbers in a row at the top of my s/sheet, and flag if less than? I just don't want to stuff up my VLook up formula
Thanks so much

Answer:Simple Excel Question

Perhaps you could use Conditional Formatting to colour them. This tutorial may help link text

4 more replies
Relevance 47.97%

Hi all,I think my describing what I want to do is going to be as tricky as the problem....I keep a simple accounts spreadsheet for house accounts.Columns A to P are for different kinds of income or expenditure.Column S is the running balance, calculated by simple addition or subtraction of the columns.All S rows below the most recently filled in display the previous running balance, ie the result of the cells formula.Can I stop the repeated display of the most recent balance in the remaining rows?Hope I am asking this question in the right place and that I have made myself clear.Many thanks,Epirb.

Answer:Simple (?) Excel Question.

you may find help here click herejohnny

6 more replies
Relevance 47.97%

I trying to make an Excel spreadsheet - a bit like a multiplication table.

Column A has 1, 2, 3, 4, 5, etc. in A1, A2, A3, A4, A5, etc. Cell C1 has the formula that whatever is in A1 is multiplied by whatever is in B1. C2 has the formula that whatever is in A2 is

multiplied by whatever is in B2, etc.

My problem is that rather than having to labouriously enter the same number in B1, B2, B3, B4, B5, etc., I would like to be able to enter a figure in for example what I call a "Master Cell",

say Cell D1 & this figure would then automatically be entered into B1, B2, B3, B4, B5, etc.

Your help in this matter would be appreciated - thank you.

Best wishes,

Tim.
 

Answer:Simple Excel Problem.

10 more replies
Relevance 47.97%
Question: Simple Excel Macro

How do you create a very simple macro to automate a repetitive step or two I'm doing in an Excel Spreadsheet?
 

Answer:Simple Excel Macro

Francine: Did I not include the instructions on how to record a macro in Word when I sent you that email? I'll resend it, if necessary. It's the same steps to do it in Excel. The only difference is that you create the toolbar button AFTER you record the macro. Basically:

Hit Tools-Macro-Record new macro, give it a name. Take the steps you "usually" take, then hit the Stop button on the Record Macro toolbar. To test it, hit Tools-Macro-Macros and run the macro. When you're ready to create a toolbar button, just hit View-Toolbars-Customize, click on the Commands tab. On the left column, scroll down and select macros. On the right, click on the smiley and drag it onto a toolbar. Edit/change the button as directed in the Word Macros document. Close the toolbars dialog. Click on your new toolbar button and it will ask you to assign a macro, double-click your macro name. Hit the button again to run the macro.

------------------
~dreamboat~
Brainbench MVP for Microsoft Word
Brainbench
 

3 more replies
Relevance 47.97%

I am sure this is a simple procedure, however I don't know how? How do you swap rows with columns? Is there some simple way to do this?

Thanks in advance
Paul B
 

Answer:Simple Excel question?

Select data. Copy. Go to new sheet or workbook. With one cell selected, hit Edit-Paste special-Transpose.

------------------
~dreamboat~
Brainbench MVP for Microsoft Word
Brainbench
 

1 more replies
Relevance 47.97%

Dear all...
One simple and quick question, I have Excel 97 SR

All I need is to sort, but everytime need to select the range before I am able to sort. Can I pre-sort so that everytime I chooses sort, the entire range will be selected.

Pls enlighten me.
 

Answer:simple sorting for Excel

6 more replies
Relevance 47.97%

Hi, I have two questions, hardest question first:

I want to order documents in Excel based on how many times the element shows up in a column. For instance, here is a simple example:

Column A
--------------
1
1
1
2
3
3

I'd like to sort that column so that 2 is first (because there is only one 2), three is second (two 3s), and 1 is last (three 1s!).

Is there a way to do this?
Second question:

If I have an excel sheet with a bunch of blank rows, is there a way to automatically remove all of the blank rows and condense everything?
Thanks in advance for any help :heart:
 

Answer:Excel question - simple?

Personally i would sort the column in accending order, then in say column C use the COUNT function to tell you how many 2's there are and how many 3's and so fourth
 

5 more replies
Relevance 47.97%
Question: Marco Help

Microsoft Excel 2007
Iíve created a table telling me how many of a certain item I have in stock. The items are in two formats, i.e. X and Y. I have two buttons saying x and y. So, when something is sent out I need to record what format it went out in. Below my table I have another table of details of the sent item, there is a column in that table I label x or y, this is done by making the cell active and pressing either the x or y buttons. However, I would like a macro that when I mark a column with x or y using the buttons it will subtract 1 off my table to save me altering it manually.
I hope this makes sense.

Thanks.
 

Answer:Marco Help

6 more replies
Relevance 47.56%

Help, my sparse hair is becoming even more endangered.We are using Excel XP. Using Autosum I get a total for A1:D1 in I1 and a total for E1:H1 in J1. Simples but, after entering values in A1,B1,C1 and D1 and getting the total in I1, a value entered in E1, F1, G1 or H1 is not only totalled in J1, but is also added onto the original total in I1. If values are entered into E1:H1 before entering values in A1:D1 everything works fine. However we do not always get the second group of values for entering before the first group are available.What is even more puzzling is that for the first 100 or so rows it all worked properly but now, whether we copy the formulae down or enter a new formula for each row we get the same problem.

Answer:Simple (?) Excel formula troubles

Don't use Autosum, it will take in all values from A1 to I1. Use =SUM(A1:D1) in I1 and =SUM(E1:H1) in J1. If I've read you correctly that is.

7 more replies
Relevance 47.56%

Hello,
I am a relative newcomer to Excel & stuggling a little.
My OS is XP Pro SP2 & Excel version is 2000 at home & 2007 at work.
I would like to establish a simple reliable method for a simple row count of any worksheet I am using.
The best I have so far works when the rows are sequentially numbered & where there are no blank cells:- use CNTL + Down Arrow; takes you to bottom of table & you can read the last row no.
There has to be an easy way for something so simple, without these limitations ,can you please help.
Rgds
Peter O
 

Answer:Simple method for Excel row count

8 more replies
Relevance 47.56%

Hi. Newbie here so please go easy.
I have an excel spreadsheet with some INDIVIDUAL cells I need to copy and paste anywhere on the spreadsheet and need a macro to do it. Can anyone help? Its for classroom assignment.

So for example. Cell B1 is clicked on once and this initiates the copy of the cell contents and colour.

Another cell is clicked on anywhere on the same sheet and this delivers the paste and continues todo this on any other cells I click on until I select (for example) B2 which has another cell entry and colour.and then the process starts again.

Can anyone help me on this? I did search for previous posts but none I could find answered this specific question.

Many Thanks
 

More replies
Relevance 47.56%

I am looking for the best way to have emails sent out periodically based on information within a simple spreadsheet.

I work for an airline, and receive a daily audit that tells me when certain passengers flying from cities X, Y, and Z meet certain criteria. For instance a simple example would be:

Passenger Smith From Boston No Luggage
Passenger Jones From Tampa Luggage
Passenger White From Tampa No Luggage
Passenger Walker From Denver Luggage
Passenger Evans From Tampa No Luggage

Each day the names, cities will change. For this example, I would like to send a standard email to each of my city managers ONLY if their city appears on the list that day AND column C = "no Luggage".

I don't want each manager to get the whole list, but only the rows that originate from their city and only those that meet the criteria for that day. Also, how do I tell excel/outlook that if the City = Boston use email address [email protected] and if City = Tampa use email address [email protected]

I'm pretty good with the basics of excel, but not with macros (which I think may be needed?)... any advice or direction would be appreciated in solving this (hopefully) fairly simple issue!
 

Answer:Solved: Simple Email From Excel?

16 more replies
Relevance 47.56%

Got a table with the binary representations across the top (see attached). What I want to do is if I enter a 1 in a cell under a certain number's column, then have that number populate that cell. If a zero is entered, I don't want anything populated. I would imagine it's a simple if/then formula, but we'll see.

tia,

v
 

Answer:Solved: simple excel question

got it.
 

1 more replies
Relevance 47.56%

I have a real simple need. Well, it's probably simple for some. I have a sheet built to track employee hire dates and eval dates. I would like to assign excel to open everyday at a time and then evaluate the cells with the eval and raise dates to see if an email needs to be sent to the supervisor. If so a simple "there are employee items coming due" email is sent to the supervisor. The super will go to the document and take care of the rest. Dta is not real. The email with the employee name isn't the one I'll be sending to. The Team Manager at the end is where the email will be going to for all on the sheet. I would appreciate the help. Running windows 7 and office 2013.
 

More replies
Relevance 47.56%

I am a complete novice to Excel, I'm using Microsoft Office Excel 2003 and when I open the Expense Statement Template, which I have to do for a coarse I'm doing, and enter a value in any of the cells, after pressing enter it adds a dollar sign, I need it to show a pound sign, I've looked everywhere but can't find how to change this. Please help. Thanks.. John.

Answer:Simple (I hope) Excel question.

Use the menu bar at the top of the screen and go to Format/Cells - select the number tab and choose Currency in the window, the select the £ sign.cc

10 more replies
Relevance 47.56%

This must be a very simply problem but I cannot figure it out...
I have created a spreadsheet to keep track my CD supplies.
This is what I am trying to do.
1. In two cells you can order the amount in boxes..
example- 50 in a box so 2 x 50 = 100
2. The next step is to place the 100 in a inventory cell.
3. Say I order 4 more boxes (200 CDs)so I now have 300 in the inventory cell.
4. In a separate cell I sell say 40 CDs so now the inventory cell should show 360.
This is my problem, if I order 50 more CDs it will show ONLY 50 in the inventory cell minus the 40 so it show only 10 CDs in inventory and not 360.
Hope that I have not lost you.. could use help.
Thanks, Bob
 

Answer:Microsoft Excel simple problems?

here's a quick and dirty

col a: #cd in boxes or # cds sold (a - negative #)
col b: multiplier
col c: subtotal (using a*b=c)
col d: inventory (using summation notation formula =SUM(C2:C21))

crude but effective

[edit: the step you missed was the subtotal column, easier than making a more difficult add this, subtract that type of formula for the inventory column]

note: easysum.txt is an excel file, change the extension from .txt to .xls after you download - virusscan etc etc (was scanned before it left, but practice safe .... computing too
 

1 more replies
Relevance 47.56%

emphasis on should. made a chart, got some random data over some random dates, for some reason excel adds the dates in between the random dates, on what it thinks is the logical pattern. Stupid program. Stupider user can't figure out why it is doing this.

For instance:
Column A has dates
7.24.05, 7.28.05, 8.22.05, 8.27.05, 8.31.05, 9.1.05, ,9.2.05, 9.7.05, and
9.9.05

But excel insists on filling in every other day from 7.30 to 8.22. I've seen this before, only in office xp, but was never annoyed enough to figure it out. Now I've found I can't, and as such, am here.

tia,

valis
 

Answer:Solved: should be a simple excel question

10 more replies
Relevance 47.56%

Ok, I've been working on this / googling for quite a bit and I am about to give up. I'm hoping this is something an excel wizard can answer in 10 seconds. Thanks in advance.

I've got an excel sheet with a column that has numbers like:

10001
10002
10003
10005
10008

etc etc etc

I want to change this to:

10001.jpg
10002.jpg
10003.jpg
10005.jpg
10008.jpg

etc etc etc

I've tried using formulas / macros and I'm getting frustrated. This shouldn't be that hard should it? Anyone that could give me a hand real quick?

Thanks!

Edit: made sure relative was on when I made my macro but it still screwed up.
 

Answer:probably really simple / stupid excel question

Code:
=CONCATENATE(A1,".jpg")
A1= cell with your number
 

2 more replies
Relevance 47.56%

Anyone know a simple way to tell me how many times duplicates occur in an excel column? If a column has:

house
car
car
boy
car
house
girl

...then I'd want as a result:

house 2
car 3
boy 1
girl 1

Thanks
 

Answer:Simple way to count occurances in Excel

Hi

The way I do this is to create a Pivot table (the list needs a header, e.g. "List") and then set "List" as the row labels and "List" as the data.

Another way if you have 2007 or higher is to copy your list to another column (say D) and de-dup the list then in the next column put in this formula

=countif($A$1:$A$10,D1)

and copy that to the end of your de-duped list.
 

1 more replies
Relevance 47.56%

I'm sure this is a simple task for you boffins out there.

In Col A, I have a list consisting of a series of number ie
24,56,23,98,34,77,01
65,98,12,17,36,99,31
etc
Unfortunately, these lists of numbers are taken from several different sources and some contain spaces ie
24,56,23,98,34, 77,01
65,98, 12,17,36, 99,31
etc
I just need a macro, which I can then assign to a toolbar button, which eliminates these spaces.
All the list is contained to Col A and the number of rows varies from, say, 18 rows up to possibly 25.000 rows.

I'd greatly appreciate any help with this please.
 

Answer:Solved: Excel - Need simple macro

6 more replies
Relevance 47.56%

hello
I have wanted to check my time sheet against my employer.
I would like to put in my in and out times and get the hours i worked.
I would like to get a total for the week.
this is where the problem get harder for me.
on my check it showes all my time payed at my base pay.
then it shows my overtime payed at day,eve, night, weekend or holidays.
i would like to set up a form so all i have to do is put in my time and it will know everthing else but my pay. I will like to put that in when we get this worked out
I hope this makes some sence. please email me if you have any questions.
[email protected] Please wight it out just the way i need to do it. if something is a unknowned like my pay tell me what ever sign or letter you put in is just that.

thanks
Joe
 

Answer:Need help with I hope some simple excel formuals

Sent you an email with a spreadsheet already set up for you.
 

2 more replies
Relevance 47.56%

Anyone know a way to create a simple user form in Excel. What I need is for about ten people to be able to fill out the form and submit their results to a database that I can hide from everyone. I saw a Template Wizare article that did this but can't get it going in Excel 2000. Is Excel even the best program to be using.

Here is the article:
Creating a Data Entry Form with the Template Wizard in Excel 2002
This article is at http://office.microsoft.com/assistance/2002/articles/xlTemplateWizardAndDatabases.aspx
 

More replies
Relevance 47.56%

I'm trying to write a formula for a spreadsheet in Excel 2010, but I'm obviously not doing it correctly because Excel just recognizes the formula as text. What I want is a formula in cell E6 that produces a value of 30 times the value of Cell C6, but only if the value of Cell D6 ? 0.
What I entered as a formula in Cell E6 is: IF(D6?C6),E6=30*C6
I suspect it needs more or fewer parens or commas or something. Can anyone straighten me out? Many thanks.
 

More replies
Relevance 47.56%

I need a simple excel macro for my work. I have tried looking it up online but I cannot get how to build one and I am in dire need of one I would love it as well if the person who gives me the macro could explain something about it.
Here is what I need. I need a macro that I can change as needed to write coins in Excel.
Example: you have A1, A2, A3, A4 as 0.25, 0.10 , 0.05, 0.01. These are of course quarters, nickels, dimes...
You have B1-B4 as the number of each type of coins that you currently have. I want a macro that when you put in B1-B4 the number of coins you have to tell you in C1-C4 how many whole rolls of coins(different coins have different rolls, quarters in 40's, nickels in 40's, pennies in 50's..etc) you have 0 to however many and in D1-D4 how many loose coins you have.
Again any help would be greatly appreciated and I would very much so contribute to y'alls site as well
 

Answer:needed simple excel macro

14 more replies
Relevance 47.56%

wife got a job as a courier, want to track miles travelled, deliveries made, etc et al ad nauseum. Only quirk in the sheet is that I want to track her mileage as well, and then only on the days that she fills up. I want this to be as simple as possible, so that all she has to do is plug in the ending mileage travelled (beginning mileage will default to the ending of the previous day), and the mpg is something I just want to track for the heck of it. We need to track the gas for tax purposes regardless, so I am going to have access to the gallons via receipts, but the kicker is that, again, I only want the cell to activate when something is entered into the gallons column.

Give me a few to work out a template and I'll attach it, but I hope that's clear enough.

thanks,

v
 

Answer:Solved: should be simple excel stuff

16 more replies
Relevance 47.56%

Hello

I'm writing (rather than recording) macros for the first time.

I need to get excel to select a cell on a specific row, within the same column as the current active cell.

I have been trying...
ActiveCell.Rows(17).Select
... but this just shifts the active cell down by 16 rows, rather than selecting the cell in row 17!

I know this should be simple but I am finding Excel VBA help files atrociously difficult to follow.

Hoping somebody can come to my rescue...

Andy
 

Answer:Surely a simple Macro in Excel?

7 more replies
Relevance 47.56%

Hello,
many thanks in advance for taking the time to have a look and any help any can offer. Basically I am trying in an excel spreadsheet to get from...
Code:

Section
Heaven Sword & Dragon Sabre
9781588991836
9781588991850
9781588991867
9781588991874
9781588992413
9781588992420
9781588992437
9781588992444
Section
Hellgirl
9780345497475
9780345504166
9780345504173
9780345504180
9780345506696
9780345508454
9780345512208
Section
etcetera...

to
Code:

Section
Heaven Sword & Dragon Sabre
Heaven Sword & Dragon Sabre
Heaven Sword & Dragon Sabre
Heaven Sword & Dragon Sabre
Heaven Sword & Dragon Sabre
Heaven Sword & Dragon Sabre
Heaven Sword & Dragon Sabre
Heaven Sword & Dragon Sabre
Heaven Sword & Dragon Sabre
Section
Hellgirl
Hellgirl
Hellgirl
Hellgirl
Hellgirl
Hellgirl
Hellgirl
Hellgirl
Section
etcetera...

I suspect this is probably not a massively difficult thing to do, but sadly it does fall just beyond the scope of my immediate excel knowledge (and what I can usually puzzle out myself from a quick bit of rooting around on the internet).

Basically I'm trying to manipulate my ecommerce data for import into something else which requires me to have an extra category variable per product. I have obviously copied the current column in my spreadsheet to retain the current information, this is an extra requirement.

It is always laid out in the Section, then the variable name I want to rep... Read more

Answer:Solved: Probably a very simple excel question...

If the values are in column A, you could use:

=IF(A2="Section","Section",IF(ISTEXT(A2),A2,B1))

in B2, then copy it down. And then copy > paste special (values) the results. Five minutes by hand, prolly.

(B1 = "Section" to start off)
 

3 more replies
Relevance 47.56%

I have a table with start dates in col 1, end date in col. 2 and difference in days in col 3.However for some reason the formula, say, =B1-A1 doesn't always work. In some lines it's OK and in others it displays #VALUE! The formatting of the various cells appears to be OK yet the symptoms persist.I'm stumped. Any solutions?

Answer:Simple dates subtraction in Excel

You will get that error if one (or both) of the dates is actually a text string, not a date. To test this, assuming that a problem date is in A1 then in a spare cell try the formula=ISNUMBER(A1)If that returns FALSE it is a 'text date'.Id that is the case then, with one column at a time, select the dates, Data > Text to Columns, click Next twice then on the third screen tick Date and select DMY then click Finish.

6 more replies
Relevance 47.56%

This should be simple, I just cant figure it out. I have an excel document that needs to be searched via column 1. The result it finds needs to be displayed on its own.

Ctrl+F will find the item, but the powers that be want it displayed without the other records around it. Any idea on how to do this? Thanks.

William
 

Answer:A simple excel search and display

To do this is to use Data, Filter, Auto Filter.

If you only want to search column1 (A), and assuming it has a header name, left click on the name and drag down so rows A1 and A2 are highlighted. Go to the above and click on Auto Filter; a box with an arrow will appear at the right of A1; click the box and if you see what you are looking for in the list just click it; otherwise select Custom, and in the right pane (on a level with Equals) type either the entire phrase you are looking for, OR if you only want to see one name (e.g. computer) amongst other variables type *computer*.

Click OK to see only the results for that phrase/name. To see everything again click the A1 arrow, press Home (or click All) and click OK.
While the results are being displayed you can press Ctrl+A to select them all and copy to a blank sheet.

johnni
 

2 more replies
Relevance 47.56%

I have an average on the product's i sell, ill loose 20% percent of the items. for an example: if i order 100 dolls 20 of it will not sell...

As much as i tried and as many people i asked i couldn't find a way to make an excel sheet to tell me the simple calculation of B2 should be 20% less than A2

I thought ill be able to find someone out there to help me.

With great appreciation.

Tzme
 

Answer:Solved: Simple Minus % - Can excel do it?

6 more replies
Relevance 47.56%

Hi all,

This is my first post. Essentially my problem is one that is no doubt relatively straight forward, however I am an absolute novice (as in no experience) in VBA. I have a multi-sheet workbook that is being used for people to enter their work times (each sheet is a different employee, with each row being a separate day). I would like (if possible) to have an email sent automatically to an end user if they haven't completed their time sheet from the day before. I have the IF function in place so that a cell will trigger either send of don't send depending on the value of the time cell at the end of the previous day "=IF(AND(B10=TODAY()-1,(F10=$H$1)),("SEND"),("DON?T"))" where B10 is today's date, and F10 is a blank time.

I have each employees email address listed on their individual sheet. Essentially I feel like I have all the necessary components together (the easy bit) I just don't know how to put it all together.

Any help would be greatly appreciated, even more so if you could explain what is actually going on!

Cheers

Stuart
 

More replies
Relevance 47.56%

It's been a while since I've used Excel and it's time to update my gas mileage sheet. I seem to recall that I could enter a date in column A and then press the right arrow and the selected cell would move to column B and so on. But instead the whole screen shifts as in panning. Any ideas?
~Peter
 

Answer:Simple Excel Question - Right arrow

9 more replies
Relevance 47.56%

Here's the problem:

A) 2 or more people using an Excel spreadsheet
and forgetting to close it, thus no one can close it / access it.

B) Excel being updated by 2 people and the changes are current.

Any simple solutions suggestions?

Thanks,
LaMont
 

Answer:Excel & simple version control

For step B, couldn't you have one nominated person to do all the input?

That way, when all the data has been input, you could send each one of them and updated file thats independant. You would retain the only spreadsheet that would be used for official purposes.

I had to do something like that many years ago for the very same reason. So I set up a system whereby the only person who could update it was on of the people that worked for me. The other people sent me all the updates and I gave them to my input person and it was then sent to the other people for verification. They were made responsible for feeding back any errors.
It worked great.

Just a thought for what its worth.
 

3 more replies
Relevance 47.56%

I have been using Excel for many years and somehow I can't figure out a simple lookup function: How do I find the column reference of the first occurrence of a value in a row? Basically, I want to display in the first cell of a row the table header (corresponding to the column) where the specified value is found.
Thanks. I'm pretty sure it should be very simple... or not?
 

Answer:Simple lookup in Excel 2003

10 more replies
Relevance 47.56%

I am creating a ss where I have hyperlinks. (A whole column is links).

I want the links to open in Avant Browser, instead of IE6. I've set Avant as the default. I've gone into my computer>tools>file types and looked, and all http, html, ect types are set to open with Avant.

What am I missing?! It's driving me bonkers. The only reason behind it is that IE6 is not compatible with the site that the links are associated with, otherwise, I wouldn't care.

Thanks,
Erin
 

Answer:Simple ? regarding excel & opening links

After looking thru Excel to an extent ive come up with 2 things.

1. Due to the fact that IE6 is Microsoft and Excel is Microsoft, something tells me that would be one heck of a workaround to have the links open in another browser.

2. Excel does however have VB Scripting, so possibly someone (wish I could write it) could write you a Macro so that when you click a link it opens it with your Avant browser instead.

Sorry I can't help anymore more than this, perhaps someone else sees something i did not.

Tek
 

1 more replies
Relevance 47.56%

hi, each time i start the PC, win98se, the screen goes red, with a message I-WORM/OPAS.I a virus was found in marco.scri have AVG running i clicked "heal" anyone tell me what it is about...and what do i do now?thanks

Answer:virus...."marco.scr" ?

If AVG has lept on the virus it's probably quaratined it, in which case AVG has ripped it up and put it in a file called $vault$.avg. If you want to check, open AVG and have a look at test results, you should see it there. It will do no further harm.Paul.

10 more replies
Relevance 47.15%

Hi Guys, looking for one with UK hols and info on rather than the ubiquitous US bumf!

Answer:Any simple Excel templates for wall calandars Pls?

If you are looking for a printable calender try here click hereorSelect the calender you want from the site, highlight it, then copy it into Excel spreadsheet. Make columns narrower and edit to suite.

10 more replies
Relevance 47.15%

Data: Characters assigned by numbers (e.g. MARKETINGS assigned as M=0, A=1, R=2 & so up to 9).Input: CharactersCondition: Apply to Input CharactersOutput Should be: Some of the number for the input characters.

Answer:Simple Program in Office Excel 2007

Post: Lacks any request for help.

8 more replies
Relevance 47.15%

Can someone help me figure out what I'm doing wrong.
I'm trying to autofill a column with a formula but it doesn't seem to be working right.

I have a column of numbers, cells A1=1, A2=1, A3=1, etc. (so the A column is all 1)
Then column B is various numbers, say... B1=1, B2=2, B3=3
These two columns are 20 rows. In cell B21 I have the total of all of column B
I want to put a formula in column D like =SUM(A1)-B21
Then I want to autofill the rest of column D with the same formula, changing (A1) with (A2) and so on as the column autofills. The problem I'm having is that it is also changing the B21, which I want to remain B21 for the entire column.

I hope this is a clear explanation of what I'm trying to do. Can someone help me figure this out. If you need more clarity, let me know. Thanks!
 

Answer:Solved: Simple Excel problem, I'm just overthinking, i'm sure...

Replace B21 with $B$21. You are using relative addressing where you need an absolute address
 

2 more replies
Relevance 47.15%

I need HELP !!!! I need a simple macro that will simply move the cursor around the spreadsheet ( right,left,up or down) without embedding the ending cell address in the macro itself !

EXAMPLE: Macro 1 - to move the cursor (up) 1 cell, to the (right) 2 cells and ( down) 1 cell. The key is, I need the macro to do this each and every time it is executed, in this pattern, no matter where it starts ( assuming it is not blocked by margin constraints )

PLEASE !!!!!!! I'm going crazy !

cheyenne
 

Answer:a simple but complex macro - 2002 excel HELP!

10 more replies
Relevance 47.15%

OK, I'm annoyed with myself, cuz I've done this a few years ago for my old company, and want to recreate it for my new one, but can't get my head around it anymore. Should be quite simple for anyone with a bit of working experience with Excel.

In it's most simple form, the table lists stock movements of sample products.
The two main columns in question are:
Serial number: simple number
Movement date: date format
(New location: Text (client's name) only important in the context of information needed, but not vital to the formula)

I want to add a column which will indicate which of the movments of EACH sample was the last one. Then I can filter out those movements which are not the last one, and know where all my individual sample products are.

Logically, I understand that it has to look up all rows with the same serial number, within that group find the record with the greatest value in movement date, and output a certain value indicating it's 'true', but I can't find a formula or combination that'll do it.

Any help would be greatly appreciated
 

Answer:Solved: Simple Excel formula doing my head in...

16 more replies
Relevance 47.15%

Hey:

I know this may seem a bit... unnecessary but maybe you don't mind helping me out anyway.

Say that ROW2 is the date 8/1/10, ROW3 is the date 8/2/10, etc., etc.

COLUMN A is the date, COLUMN B is salesperson #1, COLUMN D is salesperson #2, etc., etc.

Say that for B2, salesperson #1 sold all the units numbered 100356-100389. I want C2 to calculate the total number he sold, so basically all the numbers in that range, which is 34.

I could do the math for them all myself, but hopefully there's a function that'll do it in excel!

Thanks!
Nick
 

Answer:Solved: Excel Simple Counting Problem

I think you should try the countif function.
If you search in help or else just google for Excel COUNTIF and you'll get tips and hints
 

3 more replies
Relevance 47.15%

Hi,

I'm having a problem running a Word macro which mailmerges data from an
excel file I get sent regularly. This only started happening recently, so something has changed, and I think it's something to do with how the .xls file is saved.

The error I get is "External table is not in the expected format". It complains a bit, thinks for ages, eventually executes the macro, says the Excel file is now available to read/write, then hangs Excel.

I noticed that my macro runs fine if I open the Excel document then 'save as' the same name. Looking at file>properties within each Excel document I see the original has nothing under the general tab and the archive box is unticked. The resaved document has all the 'type', 'location', 'size' etc data as you would expect, plus the archive box is ticked.

Anyone know what's going on here then?

Cheers,

Shedlord
 

Answer:Excel properties - 'archive'? - probably a simple thing

The archive attribute is generally meanngless. It's supposed to be used for when a file has been backed up or archived, but nothing prevents an application from changing it whenever it wants. It does not affect how applications or the OS interact with the file the way the Hidden, System, and Read-only attributes do.

Most likely, the people making the Excel document aren't saving it in the same format they were. You'll notice Excel has dozens of file formats you can save to. Make sure the sender is saving the file in the correct format.
 

2 more replies
Relevance 47.15%

Hi all,

I believe this next function I'd like to have would be very simple, but I just don't know how/where to start.

I got an calendar overview in excel for the year 2010.
Now I'd like users to fill in something at a specific date with a form.
So they should select the month and daynumber and the text they fill in should be added in the cell next to this. See an example below. On the right-side of each number, there is an extra empty cell. So I.E. Here was filled in after they selected Januari 2nd Text: I.E. Here.

Can someone give me an example code?

Thanks in advance,
Willem
 

Answer:Solved: Excel calendar simple function

Don't need an answer anymore. I made it a lot easier for me, people just have to typ in the stuff on the correct place.

So this thread is now marked as 'solved'.
 

1 more replies
Relevance 47.15%

Hi
I am looking for a formula or function that allows the following:

I have a bunch of Date of Birth data. When TODAY = date of birth + 13 years 6 months then populate a new cell with the text EMAIL NOW!
So far I have managed:
=DATE(YEAR(C3) + 13, MONTH(C3) + 6, DAY(C3)+0) but i am stuck on the additional code to populate the EMAIL NOW! cell

Thanks
Martin
 

Answer:Simple date comparison in Excel 2016

In the cell you want to output the result
=if(today()=DATE(YEAR(C3) + 13, MONTH(C3) + 6, DAY(C3)+0),"email now","")
 

3 more replies
Relevance 47.15%

need a simple excel macro to create 31 sheets and name them for the dateexample:sheet 1 is named 05-1sheet 2 is named 05-2sheet 3 is named 05-3etc for the whole month to 05-31

Answer:need a simple excel macro to create 31 sheets and name them

Assuming that you are starting with a "standard" new workbook with 3 blank worksheets, this code will result in 31 sheets named as you requested...
Sub DateSheets()
'Rename Sheets 1 - 3
For sht = 1 To 3
Sheets(sht).Name = "05-" & sht
Next
'Add and Name sheets 4 - 31
For sht = 4 To 31
Sheets.Add after:=Sheets(Sheets.Count)
Sheets(Sheets.Count).Name = "05-" & sht
Next
End SubClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 47.15%

So, here's the question. I am wanting to reference information from one worksheet into another. In worksheet 1 I have 2 columns. Each cell in column 1 has an a number (100, 109, 153, etc.) and column 2 has text which matches up with the number in column 1. So, A1 might say "115" and B1 would say "This number reflects auto information". In a second worksheet, I want to write in a number into column 1, and whichever number I write I need to refer to the corresponding number in worksheet 1, column 1. I then need it to write out the text to the right of the number I just input. So if I write "115" in A35 of the second worksheet, I need the corresponding text from worksheet 1 to write out in B35, "This number reflects auto information".

Basically, all the information is in Worksheet 1, and when I write out any of the numbers in Worksheet 2 I need it to be reflected. Make sense? Thanks everyone.

+ Christian
 

Answer:Excel question, fairly simple (I hope)

Welcome to the board.

Are the sheets in the same workbook? If so, this formula in column B of the second sheet:

=INDEX(Sheet1!B:B,MATCH(A35,Sheet1!A:A,0))
 

3 more replies
Relevance 47.15%

OK, I know this must be one of the simplest formulas to ask, but what formula do I use in cell J49, to find 8% of the total of H49. My mind has gone blank.

Doh! its =SUM(H49/10)
 

Answer:Solved: Simple Excel formula needed

not sure that works

8%
=8/100

to find 8% of a value then its

value * (8/100)
 

1 more replies
Relevance 47.15%

Hi Guys,

Apologies if this is unforgivably dumb but I don't use spreadsheets much and I just can't make it work.

I'm trying to make a home finances spreadsheet, where my first column is everything that comes in, and then I have five or six categorised columns for everything that goes out, ie bills, shopping, clothes etc.

What I would like is a nice neat formula that gives me a running total. So that would be yesterday's total+anything in today-anything out today. But the problem is that I have several "out" columns and I can't make it work when only one of them has a value. I have been using:

=SUM(L3;C4)-(D4:K4)

But I'm getting a !#VALUE! error with this, and even if I type the numbers of each individual negative cell, it will only subtract the first one. I know I can do this without typing each individual cell and without putting negative values in the cells.

Please help!
 

Answer:Excel Financial Formula - Can't get it to do what I want and it should be sooo simple

Would it be possible to see a sample sheet? Obviously you don't want to share all your financial data with the world, but if you could make two or three lines of sample data that can help to explain what you're trying to accomplish.

Without that if I've understood it correctly
If L3 is the previous day's total
C4 is today's income
And D4:K4 encompasses today's expenditure

you could simply use the following in L4
=L3+C4-Sum(D4:K4)
 

2 more replies
Relevance 47.15%

Hi,
I have a spreadsheet with 2 columns: First Name, Last Name. All I need to do is have First Name Last Name together in one column.

I tried selecting both columns and then use the Merge and Centre option, but this gives message that merging into one cell will keep left most data only (First Name only).

I can't figure out this 'simple' task. Can anyone help me out?
 

Answer:Solved: Simple Excel Merging Question

try using concatenate ( & ) in a new column

= A1 & B1

You can add a space between by doing this

= A1 & " " & B1

Then select the column
do a COPY of the whole column
Now
Paste Special
Past back the text
Now you just have the names in the column and can delete the other two rows
 

3 more replies
Relevance 47.15%

Hi,

Is there a way to get excel to convert a time to a decimal? I want 6:45 to return 6.75 or 6:30 to return 6.5
If it helps, here's my situation:

I'm a waiter trying to learn excel. Thought it would be nice to use it to track my working habits and wages. I'm trying to enter tips received(C), time in(E), time out(F), and then I want to use functions to give me how many hours I worked, and what my total pay was, and my hourly.

So in (I) I've put the function =E-F to get the total hours I worked, but I can't figure out how to convert the hours to a decimal so I can use them in math functions.
Here's an example,
In at 4:30 out at 11:15. e-f returns 6:15. I want to take that and multiply it by minimum wage. but to do that I need 6:15 to be 6.25.

Thanks for any help.
 

Answer:Solved: Simple excel function question

9 more replies
Relevance 47.15%

okay, it has been almost 5 years since I was an excel VB wiz, so I have forget the most simplest of commands.

What is the command for shifting your activecell a certain amount of rows & columns.

I keep thinking it is something like

activecell.offset(1,0)

Thanks
 

Answer:Very simple Excel Visual Basic question

Not an Excel scripter myself, but an old boss ran into that issue. It had to do with Excel updating every cell after each calculation (or iteration of a calculation). Unfortunately, I don't remember how he did that. It's been too long.
 

3 more replies
Relevance 47.15%

Hi

I'm doing a list of words and their meanings in MS Excel 2003. The columns look like this:

| W | D | 2 | S |
| b | 1 | 1 | 1 |
| c | 2 | 2 | 2 |
| a | 3 | 3 | 3 |

What i'm planning to do is to arrange the Word column [W] alphabetically but in such a way as the entries in the other 3 columns (Def 1[D], Def 2 [2], Source ) will follow the word next to them. Like this:

| W | D | 2 | S |
| a | 3 | 3 | 3 |
| b | 1 | 1 | 1 |
| c | 2 | 2 | 2 |

What i'm afraid of is that if i arrange the Word column, the other columns wouldn't follow

| W | D | 2 | S |
| a | 1 | 1 | 1 |
| b | 2 | 2 | 2 |
| c | 3 | 3 | 3 |

Note: sorry if this question has been asked. tried searching the forum but was unable to find a similar question to mine
 

Answer:Simple Question on arranging columns in MS Excel

Hi fudgeydodgey, and welcome to TSG.

First make a backup copy of the Excel file as it is.

Select all four columns and then choose the Data Sort menu option. If the first row is column headers, then activate the radio button for that in the sort dialog box. Then choose to sort on the column that has the words. The data in the same row as the given word will follow along in the sort.

Note: If you only select one column and then try to sort, Excel will usually pop up a warning that data has been found in adjacent columns that will not follow the information in the selected column. You will then have the option to have Excel automatically expand the selection to include all adjacent columns with data.
 

1 more replies
Relevance 47.15%

I have the following formula that is returning the words TRUE or FALSE.=IF(AND(L6=1, R6=7),1,0)If L6 equals 1 and R6 equals 7 shouldn't this formula return 1 in the cell? I get TRUEIf L6 equals 1 and R6 equals 5 shouldn't this formula return 0 in the cell? I get FALSEIf L6 equals 0 and R6 equals either 7 or 5 shouldn't this formula return 0 in the cell? I get FALSE.It seems so simple. What am I missing?You help is really appreciated. Terry

Answer:Windows Excel 10 IF AND function broken but really simple

I'm not sure why, perhaps the way the cell is formatted(?) but it seems that Excel is converting your 1 and 0 to logical 1 and 0, therefore returning TRUE or FALSE.That does not happen when I paste your formula into my spreadsheet.You could try this, but I don't see why you would have to:=IF(AND(L6=1, R6=7),"1","0")This forces a text 1 or 0 in the cell. Depending on what you are doing with the 1 and 0, Excel may or may not consider the text value to be a number. You'll have to try it and see.If it doesn't like it, you could try this to force a number, but again, you shouldn't have to.=IF(AND(L6=1, R6=7),"1"*1,"0"*1)or=IF(AND(L6=1, R6=7),1*1,0*1) (untested, since I can reproduce the problem)I'm just starting to use 2010 on a daily basis, so I don't know if there is a setting that would force 1's and 0's to be considered logical values. I've never heard of it.Have you tried this formula in a different workbook?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

5 more replies
Relevance 47.15%

Hi, I've spent some time researching an answer to my problem but to little avail. I believe it is a relatively simple problem but I don't know much more than the basics on using excel, so I've come to this board for some help.

In any case, I have a single excel file with two data sheets in said file. I wish to use the second sheet to view text entries from cell in first sheet (which has around 75 unique sets of data with each with 40 different entries). On the second sheet I want to be able to enter the set of data I wish to view (1-75) and have the corresponding entries (1-40) fill themselves from that data set.

I thought I could have a cell in the second sheet for the data set number, and then use that cell to direct the other cells to display the correct data entry. I thought a formula such as this one would work for cell A2 of Data Sheet 2: ='Data Sheet 1'!A(2+('Data Sheet 2'!A1*40)) but now I realize that you cannot enter parenthesis within a cell name without destroying the function (I get a #NAME error).

So my question is, how does one display the text in a cell on another sheet based on the value in a cell on the same sheet?
 

Answer:Simple Excel Cell Display Question

You can try functions VLOOKUP and INDIRECT.
E.g.
=INDIRECT("'Data Sheet 1'!A" & (2+('Data Sheet 2'!A1*40)))

Jimmy
 

3 more replies
Relevance 47.15%

I swear this worked when i started this project. Can anyone spot what is wrong with this that it would generate a "general ODBC error"
Code:

Sub Checker()

Dim varConn As String, varSQL As String

varConn = "ODBC;DBQ=WORK ORDERS 2010_1.accdb;Driver={Driver do Microsoft Access (*.accdb)}"

varSQL = "SELECT * FROM TALISMAN"
'MsgBox varSQL
With ActiveSheet.QueryTables.Add(Connection:=varConn, Destination:=Range("A1"))
.CommandText = varSQL
.Name = "Query-39008"
.FieldNames = False
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlOverwriteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = False
.RefreshPeriod = 0
.PreserveColumnInfo = True
.Refresh BackgroundQuery:=False
End With

End Sub
 

Answer:Pull data from ACCDB into Excel..simple?

Spaces in your database file name perhaps?
 

3 more replies
Relevance 47.15%

I'll try to be as descriptive as possible.

Current Status:
I have an excel file with two sheets: sheet1 and sheet2.
Column "A" will have lots of data.
Some rows in column "A" (or the first cell for that row) will have the word "Directory".

Intent:
I need to search sheet2, only in column "A", for the row that contains the word "Directory" and copy that whole row onto sheet1 in the same row. Continue doing that until it completes through all of the rows.

Example Data:

(Before)
sheet2
Row Column A Column B Column C
1 blah blah blah blah blah blah
2 blah blah blah blah blah blah
3 blah blah blah blah blah blah
4 Directory cool text huh?????
5 blah blah blah blah blah blah

sheet1
Row Column A
Row Column A Column B Column C
1 blah blah blah blah blah blah
2 blah blah blah blah blah blah
3 blah blah blah blah blah blah
4 blah blah blah blah blah blah
5 blah blah blah blah blah blah

*Action: Column "A" find "Directory" Copy Row 4 to sheet1

(After)
sheet1
Row Column A
1 blah blah blah blah blah blah
2 blah blah blah blah blah blah
3 blah blah blah blah blah blah
4 Directory cool text huh?????
5 blah blah blah blah blah blah
 

Answer:Simple Excel Macro to Copy Row from one Sheet to Another

"copy that whole row onto sheet1 in the same row"

Do you mean like this?

(make sure what you already have is "safe" before you try, obviously)

Sub test()
If ActiveSheet.Name <> "Sheet2" Then Exit Sub
LastRow = Range("A" & Rows.Count).End(xlUp).Row
For Each Cell In Range("A1:A" & LastRow)
If InStr("Directory", Cell.Value) <> 0 Then
x = Cell.Row
Rows(x).Copy
Sheets("Sheet1").Cells(x, 1).Insert Shift:=xlDown
End If
Next Cell
Application.CutCopyMode = False
End Sub
 

1 more replies
Relevance 47.15%

G'day Magicians

I am an incompetent Excel macro creator and would appreciate some help.

I have a spreadsheet column with text in it
I want to move every second row two cells right and one row up
I want to delete every third row

Should be easy but I've just wasted two hours trying to do it can someone please help me tonight?

Forever grateful

Mike.
 

Answer:Solved: Simple Excel Macro Required

16 more replies
Relevance 47.15%

Have been using a simple formula (for checking my home bills /account): =E1184+F1185-G1185but at row 1186 instead of a figure it comes up with #NUMBER!Why has this happened?

Answer:Excel simple formula shows #VALUE1

If it is #VALUE! do any of those cells contain text?Try re-entering the values.

3 more replies
Relevance 47.15%

Hello,

Can someone help me, I am trying to create a macro in excel that allows me to create a copy of a worksheet, clear its contents then hyperlink it to a particular cell.
The problem is that I want it to link a different page to a different cell every time i.e. create sheet 2(3) and link to R3. create sheet 2(4) link to cell R4, but I can only make it so that it creates the copy, deletes the contents and the links cell R2 with Sheet 2(2), at the moment the coding looks like this:

Sheets("Sheet2").Select
Sheets("Sheet2").Copy Before:=Sheets(2)
Sheets("Sheet1").Select
Range("R2").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"'Sheet2 (2)'!A1"
What would I need to add or change to make it do what I want to?

Thanks Claire
 

Answer:Excel Macro Frustration, I think I'm missing something simple!

Can you post a sample workbook?

Regards,
Rollin
 

2 more replies
Relevance 47.15%

Good afternoon,
Excel 2010. Do you know a formula I can use for generating bingo numbers? I want it to randomly draw numbers from 1-89 but it can't randomly select numbers already drawn.
I hope that makes sense.
Thank you.

Answer:(probably simple) excel random number question

this formula;
=ROUNDUP(RAND()*(89-1)+1,0)
will provide the number(s) you seek, but Excel will generate a new random number each time the sheet recalculates, so I'm not sure how you'd keep track of them, on the sheet, without a macro.
The RAND() function generates a random number between 0 and 1.
Info here, for assistance;
http://www.techonthenet.com/excel/formulas/rand.php
I've incorporated the "roundup" function into what I've suggested to give whole numbers.
Hope this helps.
I'm a bit rusty with macros... see if you can manage with what's above, to be going on with.
Regards,
Simsy

6 more replies
Relevance 47.15%

I need to sum / sumif a column where I have a column number. I don't want to turn R1C1 references on for the workbook. I have thousands of formulae in the sheet and will have hundreds of this sum(column-reference) formula, so to keep things fast I don't want to translate the number into an alphabetic equivalent and use 'indirect' on the result.Is there a simple way of doing this?Thanks

Answer:Simple (?) Excel question - sum column number

Just had a go - and I cheated by using the 'insert function (fx)' facility. Because that allowed me to select a range of cells without quoting cell references, I got a formula.It looked wierd...I had a column of three entries using names - including 'fred' adjacent to a column of numbers and then used the fx to sumif the name was fred. It looked like...=SUMIF(R[-3]C[-1]:R[-1]C[-1],"fred",R[-3]C:R[-1]C)So, as you can see, the sumif will work on offsets from the result cell and give a real answer without going to the nausea of having to go back to alphanumerid cell referencing!

2 more replies
Relevance 47.15%

I have a simple spread sheet in excel 2003 that uses several drop down boxes with a value of Yes or No or some other text value. I want to reset the values in the spread sheet to No through the use of a macro. The macro can reset all values of simple input but it ignores the drop down boxes. Any suggestions?

Answer:Using a Marco to populate a Drop down box

re: "Any suggestions?"Sure...I suggest that you describe the layout of your spreadhseet and post the code that you are using so we have a better idea of what you're working with.Please read the How To referenced in my signature line before posting any data or code.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 47.15%

Hello,can someone help me to improve the VBA in the attached file? The sheet1 populates the data to sheet "investor", what I need to improve are as below:

1)Please let the sheet "investor" printed.

2)Please let the workbook run sheet1 from B3(the first investor) to the last row (the last investor) continuousely and saved in seperate "investor" sheets.

Thanks a lot!
 

Answer:Solved: VBA marco needs to improve

9 more replies
Relevance 46.74%

I am trying to find a program that will convert dimensions that are entered into Excel, into a simple graphical drawing.  The drawing needs to be to scale.  Are there any programs that will do this? where can i get this from? who can i talk to?

Answer:Creating a simple graphical drawing from Excel input

Excel has the capability to create many types of charts/graphs.  Have you looked at that?

5 more replies
Relevance 46.74%

Hi I have a very basic macro I need coded. I have an excel file with Column A,B,C,D,E,F,G Column B = last name of user Column C = first name of user Column D - institution number There are about 5000 users listed who have trained on Equipment X. I need to find which Equipment X trained users are also trained on equipment Y. Column E, F, G are the same setup as B,C,D and list out the folks who are trained on equipment Y (about 3000 users). I need a Macro go through each user and in Columna A...check if user trained on Equipment X is also trained on Equipment Y (which basically entails seeing if a particular B,C,D set of info is found in the list of 3000 users in E,F,G. Some names are idential but their instituion will be different so the macro needs to make sure it checks the complete record (if #B,#C,#D = any #E,#F,#G). If it finds the name put a 1 in the respective column A next to the name of the equipemnt X trained peron. If not put a 0. Does this make sense...any help would me MUCH appreciated!

See attached file.
 

Answer:Simple Urgent Excel Macro Help! Boss is killing me!

Sounds like a good place to use a database instead of a spreadsheet.
 

3 more replies
Relevance 46.74%

First time poster, but I've been using these forums for a while.

Background:
Column A: Source code
Column B: Object code
Column C: Total $

There are many of the same source code matched with different object codes, sometimes different occurrences of the same source and object with a unique total $ value

I am using a pivot table to put each unique source code on the row, object codes on top, and sum of totals as data. Ideally, I will see a sum of the total $ for each unique object code under that source number.

However, I only want source codes that have a '902' object code. The rows will be the source codes that have ever paid a 902 object, and then the totals of all object codes for that source.

Thanks in advance. If more clarification is required please ask.

Right now it lists all source codes and I am looking at manually filtering by unchecking all and then checking 900+ SC's in the filter box. I have a list of the unique source codes I need, is there any way to apply this to the filter?
 

Answer:Possibly simple sort/filter Excel question

Can you attach the spreadsheet for me to have a look @ ?

5ndr5
 

1 more replies
Relevance 46.74%

I want to input a data ex) apple=2, banana=3and when I type2 apple + 3 banana I want13.but I have a lot of them so simpler ways the better orzthank you and sorry

More replies