Recent content by dingdang

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