Simple Paste question- please help!12603 (4/8/2012 9:01:49 AM) CXIV.9c74cc8(1) Sorry all i'm brand new to excel and these seems like it should be so simple :( my data looks like this in pdf file: J02NA J18BD J1GXX J2E4E J2KDI J2KEO J2T7V J2T9W J2T9Y J2V3X BUT WHEN I COPY AND PAS...
How can i apply formula in next ?11350 (4/4/2012 12:56:54 PM) khanjee.9c206c8(1) Hi all respected fellows, I am using excel2007, i have a sheet with some formulas. Now i want this how can i add more columns (8 Columns group) with same already applied formulas before grand total summery....
Lookup problem in Excel 200311600 (4/4/2012 3:37:55 PM) abentleyg38(1)I had a formula in an Excel workbook called Payments to update the bank balance during 2011-2012: =LOOKUP(1E+100,'\\Pfadc01\company data\ADMINISTRATION\Excel\Accounts 2011-2012\Bank 11-12\[2011-2012 Bank balan...
Adding Excel Sheets01529 (4/3/2012 8:45:28 PM) Migi.9c15e08(1) Hi, ive just registered and hoping for some help please. I am making up rotas for work on excel and need to add sheets at the bottom (one for each week and so on). How do i get the sheets to become automatical...
Last used row31553 (3/30/2012 10:43:05 AM) tofimoon4.9bb6f48(1) Dear sir,with best regards,i have in my worksheet more than (10000) used rows,how can i reach the last row which is full of data directly ( by a code ) Many thanks in advance. -- tofimoon4 ...
How to open a file in another window?121566 (3/30/2012 12:49:44 PM) tom5095(21)Hi All, Before reinstalling the Ms Office 2007 I was able to open the second, third, etc. excel files simply by dragging its name to the Excel icon on the screen. So I had two or more files in separate windows...
Text to column and paste special transpose11736 (3/31/2012 2:06:45 AM) isfaruddin.sapardi(1)Hi All, I have 1 table like this item_number qty ref 00010-001 3 U34,U36,U43 00013-001 2 U16,U21 12505-001 3 U32,U33,U42 12512-001 3 U5,U6,U27 and 1 want it to become like this item_number qty ref 00010-00...
need help with conditional format01080 (3/31/2012 3:58:06 AM) Tonnyjj.9bc6c68(1) Hi, I am having problems with "conditional formatting". I use 3 columns of data and on my last column is where I apply the "conditional format". In the beginning I had it all set up and it worked perfectly....