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