Search results

Hi I dont usually use big formulas so am a bit lost trying to find a solution to this request. I dont even know if it is doable. Any pointers to help much appreciated. If Sheet1!G2:G says "save" Then lookup the Value that row in column A , then look up Sheet2! B2:B for the same value select...

I dont always have time to open and read interesting looking threads. it would be great if I could add them to my watched list so i could go back and read them later by clicking on an icon by the header?? as I scroll through the latest posts. Thoughts on this?

Hi, Does anyone know how to get the pocasts to play in"Miro" I cant seem to upload them. Thanks, L

Hi i have some code which extracts the expenses from a list of combined income and expenses. It runs great if I manually select the correct sheet ("INCOMEXPENSESa") first. If I dont select the right sheet it creats havoc on the active sheet :) Im sure this should be simple but I cant seem to get...

Hi I an subtracting 15/9/2011 from 15/2/2014 to get number of days old. I then divide by 365 to get years and get 2.42 yrs which I then use "round up" to get 3. I then put an R in front to get R3, (=R&" "&G3 etc) ie rising 3yrs. I have done this in three steps using helper columns. Is there a...

Hi, Is it helpful to "Report" the spam posts. I come across them occassionally and "Report" them. Should this be done, or not? :confused:

Hi, I tried to hide rows containing the word Culled with this code . It seemed to go through the range but no rows were hidden, what have I done wrong. Sub HideRows() Dim cell As Range For Each cell In Range("A2:Q150") cell.EntireRow.Hidden = cell.Value = "Culled" Next cell End Sub

Hope this isnt a silly question, but is there any way of changing the time stamps on messages to my own time zone?

Ha, Ha, Thank you for the trophies. Hope I dont have to do an acceptance speech. Hope I dont become an "Excel Whinger" :oops:

Love the style, layout and readability of the new site, well done to all concerned.

Hi, how do you get back to the Forum from the "Home" page, there doesnt seem to be any links, I must be missing something?? I used my bookmarks to get back to the forum.

Hi, I have worksheet that contains a mix of income and expenses. The expenses are negative amounts, income positve. I would like to select the rows which contain a negative $ value in column F and paste these into my expenses sheet using VBA. The sheet will already be sorted with all the...

Many moons ago when learnt to type we were taught to leave two spaces after a full stop. Times have changed. When typing in excel should I be putting only one space after my full stops?

Hi I have imported several text files and saved them as worksheets in a workbook which contains other sheets as well. The new sheet names all end with .txt. I would like to copy a named range from another sheet and paste it only into the sheets named ....txt. I have some code which will paste it...

Hi, I have been using Ron de Bruins code (below)to convert multiple text files to excel sheets in a newly added workbook. What I would like to do is to be able to add the worksheets to an existing workbook if possible. Help with the code for this would be much appreciated, Thanks...

Over the years I have made various user forms which I havent used for a while and dont remember which files they are in. I am using excel 2003 on win 7 Is there any way of listing the files which contain user forms. I am going to make a new user form and would like to incorporate some of the...

Hi I am using XL 2003 and wish to copy and transpose 10 rows of data from a list on sheet 1 to the next empty row on sheet 2. Here is my code that dosnt work. Sub Sheets("TextData1").Range("A1:A10").Select Selection.Copy Sheets("TextData2").Select Selection.End(xlDown).Offset(1...