(0.016 seconds) Articles (15349) /768 Next>> Last >| Simple Paste question- please help! 1 2157 (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 to set a value in a cell whose address is held in another cell 2 1507 (4/6/2012 6:22:06 PM) ellis1 (2) Say I have A1=4 and A2="D3", can I write a macro to set D3=4, using the information in A1:A2? -- Ellis Morgan ... How can i apply formula in next ? 1 1042 (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 2003 1 1281 (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 Sheets 0 1255 (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 row 3 1342 (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? 12 1318 (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 transpose 1 1311 (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 format 0 874 (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....