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...

Smallman, Thanks.... its working fine but i want entire row with header to copy in new wb. also auto filter still active after copy in original file. Pls guide

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...

Somendra, Thanks a lot. it work!!

vrunda, have apply below formula In conditional format =AND(MONTH(TODAY())=MONTH($F7),DAY(TODAY())=DAY($F7)) Format… [Fill colour RED] If date of birth match with coloum F then entire row is in Red , i just want to auto copy all such red row to next sheet seperatly.

Smallman, sorry..its not what i required.. if remark inputed in B20 in form sheet for sr. no.3 should update the same in sheet DATA in Z4 and so on....just like vlookup.

Smallman, Have unmerge all header row on the data sheet as suggested.but my requirement is remark updated in "Form"B20,B21,B22 need to updated in Data sheet in colomn Z to AB for each different record. Pls guide.

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...

Sir, Thanks for info..but how to select row which depends on conditional format.as date are changing every day as per DOB.

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, yes, I just want any shortcut key which give auto serial no in colum I instead of inputting manually after finding value in column E.

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...

Dear lhkittle. Thanks a lot its work perfectly.

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 = _...

Yes, Perfect!! Thanks GURU.

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"...

any luck ?

Sir, code as below , count and amount Total of column "E" required in footer in Header line :64( code no for header )+date in ddmmyyyy format and at last column 600400000 in Footer line : 65 ( code no for footer )+ count of data + ( from right side )13 digit total of amount+600400000 Red...

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

Yes perfect.. Thanks a lot

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...