Search results

Hi guys, I have many thousands of rows of data and I was wondering is it possible to create a macro or a piece of vba code to insert a blank row everytime the value in a cell is less than zero, the blank row should be above the less than zero cell. This was the best I could come up with but...

Luke M y0u hero you've saved me so much time, thank you so much! :D

Hi guys, I have a cloumn of data and I wish to insert blank cells between each enrty in the column. Is there an easy / fast way to do this? I recorded a macro with relavtive referances to insert 4 cels under the selected cells and gave it a keyboard shortcut but this is still time consuming as...

That works perfectly! Thanks a million Hui. :)

Thanks so much for your help guys! SirJB7 that changed the date from 2011 to 2001 and did not change the time. Faseeh that works but 29:03 is not a time, they are 24 hour clock times so it would need to convert 21:00 to 05:00. Hui, That almost worked perfectly but it changes 02-12-11 21:05...

Thanks mrzoogle, unfortunately I couldn't get that to work, it just returns 00:00 for each cell. Any ideas? I tried =HOUR(G2)+8 , =HOUR(B2)+8, =HOUR(B2+8), and just =B2+8 none of them worked. thanks in advance for any help with this. :)

Thanks a million Hui, never would have figured that out myself!:) What about the times being wrong, is there a quick way to add 8 hours to all of them as they are 8 hours slow. Thanks again!

Hi chandooers, I have what I'm sure is a simple problem but I've no idea how to solve it. I have a coumn of dates & times and I want to seperate them so the dates are in one column and the times are in the next column. Also the times are all 8 hours fast so they need to be adjusted, how do...

Thank you so much! That works perfectly! You ledgend! :D

Thanks Hui! Well it accepts the name for the range now but I'm still having difficulty graphing the range. I created a name for the range in column A using the same method, as the chart is a graph of A against E and both ranges must be dynamic. I called the range for column A, Timestream...

http://i1101.photobucket.com/albums/g434/deco_r/screenshot.jpg screenshot of what I'm talking about if it helps!

Thanks Narayan! Still failing epicly at this unfortunately! :( on "formatted data" sheet, select column E, click define name, Name: sample.xlsm!acceptstream Scope: Workbook Refers to: =OFFSET('Formated Data'!$E$5,,,COUNT('Formated Data'!$E:$E)) click ok see error message saying "The name...

Hi Montrey! Thanks so much for helping me out with this, I still not getting it tho, I'm a total excel noob so pleae forgive my stupidity but where do I put the name of the named range? I selected column E in the formated data sheet, clicked define name, in refers to box copied in...

bump! :)

Thanks Hui, The 1st sheet called "Networking_Log_04-04-12_13_41" in the workbook I uploaded here I think, this sheet is the data input sheet, the new data will be pasted into this sheet every week and the idea is that the graphs and sheet of formatted data will adjust accordingly. This is...

bump :)

Sorry about that, sorry if I was unclear, I'm trying to do is convert the raw data seen on sheet one into the graphs and formatted data seen in sheets 2 and 3. I need to automate this process via a macro, vba code or similar so that I can open the worksheet once a week paste in the raw data and...

https://rapidshare.com/files/3105214021/sample.xlsm Thats the worksheet I'm dealing with, I start with the raw data on the 1st sheet and I need to create a macro to format the data into the form seen on the 3rd sheet "formated data" and then to create graphs from this data as shown on the nd...

I have an excel spread sheet from which I must create graphs (XY scatter plots in this case) I wish to create a macro to create the graphs as the data changes weekly and graphs of each set of data must be created. Creating a macro to do this rather than having to manualy graph the data each...