Computer Support Forum

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

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

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

Relevance 100%
Preferred Solution: Excel properties - 'archive'? - probably a simple thing

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.)

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 62.73%

For some reason, out of the blue, a widow pops up, runs somekind of installation then it changes and says the feature im trying to use, is not available, and wants me to redirect it. if i click cancle, it goes away but just pops up agan after a cuple seconds.

its requesting the installation file, but i cant find it on my HardDrive. The file name is EZARC.msi.

Answer:Hp DigitalMedia Archive thing Keeps poping up.

wow i have the same problem someone plz explain how to fixed this is really anoying and i cant stop the download or delete

3 more replies
Relevance 58.22%

a friend of mine mentioned to me that some items in the taskbar properties were displaying incorrect icons - see attachment... for example, the norton icon is used for "image transfer"... i havent a clue what to suggest, so thought i'd post...

any ideas?

they mentioned that this is the same on both their desktop and laptop, and they only noticed after installing iTunes - but i too have iTunes installed and no taskbar properties problem...

thanks in advance!

*edit: nevermind previous edit, that's a non-issue!
 

Answer:a strange thing in taskbar properties...

7 more replies
Relevance 57.4%

Should Windows 7 on installation ask me for the wireless password? Because i have an Acer Aspire One D255E and i don't exactly know will it ask. It's checked for any bogeys in every nook and crannie nothing.
 

Answer:Just asking one simple thing :D

9 more replies
Relevance 56.99%

Every single time I view any file's properties (context-menu right-click -> Properties), it always immediately launches an installation of an already-installed (but disabled) application! As Betty Jo Bialosky so famously asked: Whaaat?

I'm running 64-bit Windows 7 Pro/SP1. The app it keeps trying to install is MacDrive 8, but I think that may be more incidental than anything else. I say that because I experienced the exact same thing perhaps 5-7 years ago under 32-bit XP Pro/SP3, except it tried to install something else (I can't recall what). Although MacDrive 8 is already installed, I almost never use it, and so I've disabled all the services and all other startup stuff related to MacDrive using my startup manager. So the puzzling fact that Win 7 is so desperate to install MacDrive again is truly weird, and extremely annoying!

It usually takes three attempts to cancel the unwanted installation, after which the file's property window comes up normally.

I've thoroughly scanned for malware, and found none. Also, I've some reliable registry check and repair tools: Iolo's System Mechanic's Registry Tuner, and Wise Registry Cleaner. Afterwards, no registry errors were reported at all.

What the heck is going on? What bizarre connection is there between viewing a file's properties and a forced install of anything?

Answer:Weird: Whenever I view any file properties, it tries to install thing!

Uninstall Mac Drive 8. See if that fixes the problem. If yes, install the latest version and see what happens if you still want to use it.

3 more replies
Relevance 56.99%

i downloaded some songs from limewire and after that my computer started to mess up. limewire would start and then close during loading time without giving me an error message. i tried to delete the music that i downloaded but everytime i try to open the folder i get a message "windows has encountered a problem and needs to close. sorry for the inconvience" and then i can send an error report or not. this happens everytime i try to open or delete the folder and when i tried to search for the folder using the search window it started to search and then closed suddenly giving me the same "windows has encountered a problem" message. i know its probably a limewire problem but a moderator at their forums suggested i go here for expert advice. so if anybody can help i will greatly appreciate it. and if you think its not a limwire problem can you give me some suggestions on what is happening. thx for any help from anybody.

Answer:So Much Trouble...from Such A Simple Thing

The problem with P2P file sharing is that you can often get infected, either by accident or by design, from the files you download unless you are extremely careful.
Your first plan of attack should be to thoroughly scan your hard drive with your resident Anti-virus, followed by scans with any anti-spyware applications you have installed.
Let us know the results, if you have not already done this.
Regards,
John

6 more replies
Relevance 56.17%

Hello. I get BSOD'd everyday, but it happens most of the time when I watch a Youtube video or downloading a game from Steam, or just downloading in general I suppose. The stop code 3B pops up maybe 20 times a day, sometimes I can go a day without getting a crash. Also, I do receive other BSOD stop codes such as 7E,1A. I can't remember, but I heard they are related to the same error which is something to do with a driver. They don't happen as often as 3B.
Surprisingly, when I play games on a full load I NEVER BSOD only when doing simple things such as web browsing.

I have done some things people recommend on other sites like tom's hardware. I'v tried: Memtest, SFC /scannow, updating drivers. But no luck
My RAM made 2 passes with no errors on Memtest86 which took about an hour and a half or so. I wasn't too sure how long I should run that test.

SFC /SCANNOW does not find any problems or violations.

I am pretty sure I checked all or most drivers for updates, but it always says they are up to date, unless I have missed something.
Thanks for any help! I have been haunted by BSOD 3B for a long time...

I have uploaded my ZIP file.

PC Specs:

CPU: AMD FX-4100 Zambezi Quad-Core 3.6GHz (3.8GHz Turbo)
RAM: CORSAIR XMS3 8GB (2 x 4GB) DDR3 SDRAM DDR3 1333
GPU: HIS HD Radeon 7770 GHZ Edition
HDD: Seagate Barracuda ST1000DM003 1TB 7200 RPM 64MB Cache SATA 6.0Gb/s 3.5
MOBO: GIGABYTE GA-970A-D3 AM3+ AMD 970 + SB950
PSU: Rosewill Green Series RG630-S12 630W Continuous... Read more

Answer:BSOD 3B constantly when doing simple thing.

Code:
fffff880`0a1566f0 fffffa80`07ac9070
fffff880`0a1566f8 fffff880`040851b7Unable to load image \SystemRoot\system32\drivers\aswSnx.sys, Win32 error 0n2
*** WARNING: Unable to verify timestamp for aswSnx.sys
*** ERROR: Module load completed but symbols could not be loaded for aswSnx.sys
aswSnx+0x71b7
fffff880`0a156700 fffffa80`071d7010
Driver Reference Table - aswSnx.SYS

The most recent .dmp files are corrupted, but the one from 29/08/2014 clearly points to Avast as the issue. Replace it with free MSE and monitor for further issues.

Download Microsoft Security Essentials - Microsoft Windows

5 more replies
Relevance 56.17%

I replaced an Intell pentium I cpu 75 mhz with an Intell pentium cpu 166 mhz...

nothing happens when I power up except a black screen.
this was on a NEC Ready 7022 tower type computer...

what didn't I do right?
 

Answer:I thought I did a simple thing for a friend

12 more replies
Relevance 55.76%

so an entire drive on my computer, i have only read access to. i can't delete or write files to it and not sure how this happened.

when i try to change the permissions on the drive i get an error saying the media is write protected and its pointing to a file on the drive. i can click continue but im not about to do that to every file on the drive. any ideas how to fix this?
 

Answer:Hmm, what simple thing am i missing? Permissions in Windows 7

Right-click on the drive -> Security -> Advanced -> Owner -> Edit -> Change owner to your account and check "replace owner on subcontainers and objects." This should take care of it in one go.
 

2 more replies
Relevance 54.94%

I need a program for Windows that will force my wifi card to stay locked onto a specific channel.

For the next week (at least) I will be in this hotel. The problem I run into is they have one wifi network that is bounced off of multiple AP's, all on different channels, and my wifi card can see all the AP's. So, what will happen is, my connection will be strongest on say channel 6 and it's fine, but then if another channel is stronger for a second, it will switch over to the other channel and drop connection while it does that. Then when channel 6 is strongest again it will switch back and drop connection again. This makes maintaining a constant connection very difficult, and is definitely frustrating.

I just want to tell my card to stay on channel 6, no matter what the other channels look like. Is there any software out there that can do such a simple task? Free or paid, I don't care. I just want to maintain a connection.

Answer:Can't find any Windows wifi software to do one very simple thing...

Can you just make that AP a customized connection (like a manual connection) and tell it to use channel 6, then move it to the top of the list as the preferred network.

Would that work? That way it's not connecting to whatever AP every time, it 'wants' to always use the channel 6 connection if available.

2 more replies
Relevance 54.94%

I've been asked to copy a shortcut to a website to everyone's desktops within a domain.

It's a mix of XP, Vista, and Windows 7.

I know it needs to be copied to All Users\Desktop or Public\Desktop.

What would be the best way to do this? I figure I can update the login scripts, but I'd have to play with the syntax to get it to do what I want, as I'm not sure how it'll work with the different operating systems. I'm sure there's a wildcard in there somewhere I can use.

Or should I be looking at Group Policy for it, and if so, where would I look?
 

Answer:Hopefully a simple thing: copy shortcut to all desktops in domain

psexec \\* -u domain\administrator -p password "\\server\copy.bat"

\\server\copy.bat:
Code:
set copypath="C:\Documents and Settings\All Users"
if exist not %copypath% (set copypath="C:\Users\Public")
copy \\server\file.url %copypath%\Desktop\file.url
Something like that should work.
 

11 more replies
Relevance 50.43%

How can I put identical information in the comments section of properties box (file>properties) in 35 files at the same time? Is there a way to select the files in Windows Explorer and then do this? I normally put the info in as I update each file, but it would save a lot of time if I could just do it all at once.

I put the date the file was distributed for reference purposes. That way I can, or anyone else can, just hover over the file name in Windows Explorer and see what date it was sent out on. I don't want to put it in any other part of the properties except the comments section.

I am using Microsoft Office 2003 and Windows 2000NT

Thanks for any help.
PS. I am not a programmer.
 

Answer:Properties Comment Box in Excel

Selecting multiple files and then selecting "properties" disables the editing ability, so the simple answer would be "no".

No doubt some VB programming could be done to perform it, but not by me or you by the sound of it ....

One can understand the reasoning for MS disabling the multiple edit ability, as it would be simple to mistakenly have multiple files selected and change them all in error.
 

2 more replies
Relevance 50.43%

How do I put separate lines in one cell.  I don't want them to wrap or be swayed by how wide/narrow I make that cell.  For example: name on the first line, phone number on the second, birth date on the third. No wrapping!!!

Answer:Excel Cell Properties

You can start a new line in an Excel cell by holding down the Alt key and pressing the Enter key.

3 more replies
Relevance 50.43%

OK...here goes. I am wondering if anyone knows if there is a function within excel that will capture and display within a cell the "last saved by" users name within the excel properties/statistics display.

To word it a different way...When a person goes to file/prperties/statistics there is a field displayed called "last saved by" this filed displays a user name. I am wondering if ther is a way to capture that info directly into a cell in the spreadsheet using a function, I realise that I could just use a macro but I was wondering if there was already a function...

Thanks,
Andrew
 

Answer:Excel Last Saved by in Properties

I am using Excel 2000, and searched in the help for something like this. Dreamboat should be able to tell you more, but I did find some useful tips for this type of thing.
These are the topic headers in Help:

View workbook changes made by other users

View workbook changes for a particular date, user, or range of cells

View the history of all changes to a workbook

Here are the details for the second one I posted:

View workbook changes for a particular date, user, or range of cells
On the Tools menu, point to Track Changes, and then click Highlight Changes.
Show Me

Make sure the Track changes while editing check box is selected. This check box turns on workbook sharing and the change history.
If the Track changes while editing check box is not selected, Microsoft Excel has not saved any changes for you to view.

Under Highlight which changes, select the types of changes you want to see. You must select at least one of the following:
To view changes entered since a specific date, select the When check box, click Since date in the When box, and then type a date in the When box. To view changes from the time when the change history was turned on, click All in the When box.

To view changes made by a specific user, select the Who check box, and then click a user in the Who box.

To view all changes to a specific range of cells, select the Where check box, and then enter a range reference in the Where box, or select a range on the worksheet. To view changes to the ent... Read more

3 more replies
Relevance 49.61%

Excel objects have properties one may select (e.g., move and size with cells). May one make these changes the default (permanent) rather than having to select each time used?
 

More replies
Relevance 49.61%

Hello,

We work with an excel sheet with multiple colleagues, This workbook is protected on some columns/fields and the workbook is shared.

Now we have several columns that keep changing it's cell properties. For instance:
Column: License Plate, this should have the property general, but every morning a colleague has to manually change it from date to general again, next morning the same thing.

This colleague has first removed the protection and share, next changed the column property and next put the protection and share on again. In my opinion the right procedure.

Does anyone have an idea what could be causing this?

Thanks in advance,
Wouter
 

Answer:Excel 2013 cell properties

13 more replies
Relevance 49.61%

My company just moved us from Office 2003 to Office 2007 and a few things I used to be able to do seem to be gone now. I have two questions that I hope someone can help me with:

1) To save a preview picture in Office 2007, I have to go to Prepare, Properties, Document Properties, Advanced Properties, and the Summary tab in order to Save Preview Picture. In version 2003, I had set it up to automatically ask if I want to set properties before saving a file. Instead of simple lists, I use thumbnails to make it easier to see what files are which in the folders. Now I have to go thru all those steps just to save a preview thumbnail. Is there a way to tell Office 2007 to automatically save a preview picture?

2) Is there any way to revert to the old Office 2003 look and feel? I'm going crazy trying to remember where familiar menu choices are in this new program. The ribbon is a terrible idea, as far as I'm concerned. It might help people who are new to the software but I've used every version of Word and Excel since the first iterations and I find it cumbersome and it takes up too much space. I'm using a laptop as a company computer and the ribbon eats up almost 1/4 of the screen. I found out I can minimize it and have it set up that way but it still makes me crazy that I even have to do that.

Rant over. Thanks for any help you can give me.
 

Answer:Excel 2007 Properties Summary

Hi Griduser, welcome to TSG.

1) Unfortunately, in 2007 there's no equivalent of the prompt that was in 2003. However, you can make the process a little quicker by adding the Advanced Properties icon to the Quick Access Toolbar. If you click the down arrow next to the existing icons at the top, you can go to More Commands, choose the Customize tab, change the dropdown to All Commands and then add Advanced Document Properties. If you're sure you want it for all spreadsheets, you could create a template to use with all future workbooks. To do that, you'd need to open a spreadsheet and change that setting and then save it as book.xlt in the XLSTART folder. That won't affect existing spreadsheets, though.

2) Sorry, you're stuck with the ribbon. Microsoft didn't want to provide a way for people to retain the old look and feel. However, if you scroll to the bottom of this page, you can download a workbook with new locations for the old commands. If it's any consolation, I hated the ribbon at first but I'm used to it now and it doesn't bother me. I'm still not sure I understand the impetus for the change, but it doesn't take long to assimilate.
 

1 more replies
Relevance 49.61%

is there a way to make changes to the excel default workbook such that every time i start a new workbook it will contain the following properties.

1. comment properties are formatted so that they move with the cells when insert rows or change row height. i know how to do this for each comment but was hoping that i did not have to do this all the time for every comment.
2. comments are always displayed and printed as on sheet, vs the default page setup which has none.
3. headers and footers. i would always like the header to be at it minimum and always be file name in the middle box and tab name in the right box.

thanks for anything assisting the above
 

More replies
Relevance 49.61%

Hi everyone,I am trying to create a spreadsheet to monitor cashflow but it is not as easy as I thought.Using XP pro and Excel.1st column is the date of an invoice.2nd column is the ammount.3rd column is the date paid.4th column is how long it took to be paid in days.5th column is to show invoices outstanding and how many days.This needs to be time related ie add a day every day unless it can be configured to the clock.If that is not hard enough for you then I would also like all previous paid invoices that took longer than 30 days to show in red and all outstanding invoices over 30 days to show in red.Hope someone can help, thanks.Ray

Answer:Tricky Excel spreadsheet thing

vog will be along soon to help you out.the 30 days thing will be needed to be done by conditional formating.do you have excel 2007?>

10 more replies
Relevance 49.61%

Hi

Just wondering if anyone knows what this blue thing is in the middle of the cell in Excel???

Thanx
 

Answer:Solved: Excel blue thing?

It is showing you the circular reference dependence in the formulas.

Usually this indicates a mistake on the sheet, where the result of a formula includes the formula itself, which means it is non-resolvable.
 

2 more replies
Relevance 49.2%

I would like to have my list in excel have every other row of information a separate color so that the list is easy to read. (i.e. blue row, no fill row, blue row, no fill row, blue row, no fill row, etc.) I would like to be able to sort the data in this list without the color of each row sorting with the information. Is it possible to lock the fill properties of cells so that it does not sort along with the information in that cell?
 

Answer:Excel Sorting without cell properties changing

Here's how.

Select however many rows you need (click'n'drag on the row headers).

Choose Conditional Formatting from the Format menu.

Set Condition 1 to Formula Is. In the box, enter

=MOD(ROW(),2)<>0

Click the Format button. On the Patterns tab, choose a suitable blue. Click OK. Back in the previous dialog, OK again. The formatting will not be affected by Sort.

Rgds,
Andy
 

1 more replies
Relevance 48.79%

Guys ! Can You help me ? How can I set auto time in excel ? It's to important to me . guys please help me :( .

More replies
Relevance 48.79%

Does anyone know how to use Excel macro to open the printer dialog page (the page that displays when you select print from Excel)?
 

Answer:Solved: Excel Macro Open Printer Properties

10 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%

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 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%

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%

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%

"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%

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%

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%

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 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%

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%

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%

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%
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%

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%

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%

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.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%

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%

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%

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%

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%

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%

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%

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%

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%

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%

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'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%

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%

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%

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%

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%

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%

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%

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 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%

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%

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%

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%

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%

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 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%

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.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%

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%

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%

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%

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%

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%

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%

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%

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%

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%

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%

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%

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 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%

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%

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%

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%

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%

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, 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%

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%

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