Search results

Hi, We have arranged one training workshop and for online registration we created google form for registration. now batch of 100 participant are completed. I want to make simple ID card for all the participant using excel data. It should print multiple Card in one A4 page as per size to cut...

I have systeme generated text file which I want to convert in excel coloumn wise, I am recording the Macro for that. I want additional code for below . 1. Go to last blank cell in coloum A and type " Total" 2. Sum of column B1 till last row of B 3. Type "Report" in column C 4. auto save file in...

Hi, I have customer data base having date of birth in column H, I have applied below conditional formula to change background color in RED if date of birth match with today's date. ( only DD-MM ). I want vba code to copy all such row based on background color or based on today's birth day to...

Hi, I have customer database in "data"sheet ( will be hide for user ).and second sheet as "form" which get same data in different format from "data"sheet by using offset formula and linked with scroll bar button to get next record. user will update the 1st /2nd/3rd remark in B20/B21 & B22 in...

I have customer database with date of birth in colour F, I have added conditional format if DOB ( only dd-mmm ) match with today then entire row is in red color. I want to copy all such row in separate sheet as an when file open. in short I want separate list of customer having today birthday...

Hi, I have downloaded data from other system to excel and have physical invoice which is not serially as per downloaded data, to arrange serially data i am finding invoice no and add serial no to helper column I for sorting assending order in lot of 200. as data is huge around 20000-25000 i...

HI, I have huge Address data in single column and i want to transpose to multiple column, no of cell is not fixed for address but there is 1 blank cell between each address, pls guide. COLUMN A 21215545845 ID :: 134000119 S GOGATI SHIVAJI NAGAR DHL PIN : 400 002 21215545845 ID :: 134000119...

I have below data in 1 sheet.. CENTER NO id no student name standard Class no 1011 2122 mohan X A 1011 55455 rajesh V B 1011 5454 mad VII C 1011 45212 moh IIV D 494 5455 d'souza X A 494 7454 randson X A 494 87854 semon X A 511 21 vicky X A 511 21245 samrat V B 511 3232 santo V B 511 95646...

I have xls sheet with huge data wherein I am finding some value ( ctr F ) in column E and if value found, inputing sr. no against that value in column I, for that i have to move cursor to I column every time ( right arrow ) which is very time consuming. is there any option/macro to move cursor...

Hi, I have recorded macro wherein I want to copy cell C2 till last row of column B. in cell C2 contain " report dt 14-feb-2013 ( todays date) but after copy cell from C2 till last row, year is changing as 2013..2014...2015 so on.. Pls help code is : VB: ActiveCell.FormulaR1C1 = _...

Hi, Required help to add formula in macro to count data from B2 till last row of column B as data is not fixed. have tried to record macro but its recording cell , pls guide. code : Range("A100000").End(xlUp).Offset(1, 0).Select ActiveCell.FormulaR1C1 = "39"...

Hi, I have recorded macro which convert 8 column data in to text file ( save as Report.txt ) in folder like : 6206451560017465400000000110000002000000600400005 6206451460017465400000000110000002500000600400005 6224070760001200100000000110000000554400600400005...

Hi, I am downloading data from 2 different system in to xls and need to remove invoice no and amount which is not match with other data. attached file for your ref. https://dl.dropbox.com/u/66400357/diff.xlsx A and B data from one system and D and E data from another system, currently i...

Hi, Attached sample xls file and required output data in to next "report" sheet. report is basically unique name of company wise report with total of Amount column and count. Data will be in DATA sheet from column A to K , sample report format also given in same sheet with mapping of column...

I have worksheet having co. name wise data in to 2 columns 'Advise no' and 'Amount', I want to merge all co.name wise data in to next sheet. attached file for your ref. ( column and data r not fixed ) Pls help. https://dl.dropbox.com/u/66400357/Merge%20Column.xlsx

Hi, I have xls data file from which i want to create report just like mail merge in word in txt file template. can any one provide macro to generate report. text file should auto save with file name "report & date" into in same folder where xls file exist. attached sample file for your...

Hi, Need vlookup or if any other formula to get entire row from 2 input data which match with data and copy entire row. attached file for your ref. data input in A15 and B15 should match with data range A1:H11 and if match then required entire row copy to D15...

Hi, Is there is option/macro in excel to set cursor position. I want to input number in 2 column say in B2 ID no and in C2 Amount. if i input number in B2 and enter then cell should auto move to C2 and after entering amt in C2 cursor auto move to again B3 ... so on. Pls help B columne...

Hi, I have xls file which i want to split in to multiple files as per value change in Column A in same folder with file name in Column A. file attached for your ref. output file will split in to 6 files with file name z400001.xlsx , z400002.xlsx,z400003.xlsx,z400004.xlsx, z400005.xlsx and...

Hi Guru's I have data which i want to split into multiple files as per availabel user. if data is approx 7592 ( data and user wiil not fixed ) and avaible users are 8. i want to split data in to 8 files of 949 row each with file name mentioned in column B attached sample file for your...