Search results

Any luck ?

Sir, Yes, topic is the continuation of my earlier post I should have continue in that post only...sorry , only different in the report format with singly entry report and this is consolidated report. Debraj Roy's formula perfectly work in my last requirement and i have already tried to...

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

Yes, its work. Thanks a lot.

Sir, Perfect.. Many thanks!! But one more modification required. i forgot in my first post. if any co. name is blank(2 columns ) between then this blank column should ignore and next 2 column should copy in continue. in above code if blank column in sheet it stuck macro stuck with below...

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

Siiir, Damn Good.Perfect as required output ...Thanks a lot

Sir, Thanks for the details, If possible can u pls provide VBA code for each entry in sheet one creates a 16x7 block in sheet2 the reason is that i have approx 850 to 1300 record in sheet1 and for that i have to copy 16x7 set which i think very time consuming process. Pls help.

Sir, Greee8...Thanks a lot. can u plsss explain how u done this just for my knowldege & learning. have check conditional formating but don't understand how letter format copy with data from sheet1.

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

Luke M, Thanks a lot, its work, was wrongly past code in regular vb code.

Luke M, I have just paste your code in VB Module and input number in b2 after enter cursor should move to c2 which not working as required. its just move down in b3.

SirJB7, Protection is not suitable, I just want to data entry using only numeric keypad without using arrow key ( right + down ) if i input in b2 then cursor auto move to c2 then after inputing num in c2 cursor again move to b3 so on..

Luke M / Greg.Begin, Sorry.. its not working.

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

Yes, its work, you r simply the gree88888.

Sir, Need help again, i have fixed no of file name as 8 and subsequently set range in macro, but if i want to creat less than 8 files with 0 value in "no of row" coloumn, macro stuck at below line "Range(rngData.Rows(I + 1), rngData.Rows(I + K)).Copy" if i delete row A4 then i need every...

Yes, uploaded sucessfully. Thanks Guru.

Sir, Thanks, one more help required, while uploading the output file in my core system showing some error. after consult with out IT engg. output file extension should be as .txt instead of .xlsx. Pls guide.

Sir, if i want to change path to save files, where should inclued it in macro. i want to save files in c:data folder.

Sir, Gre8888.. its work perfectly. Thanks a lot

Sir, currently i am doing manualy calculation , no of records (7592) / users (8) = 949 rows for first file with file name A1 and so on... for example A1:G949 will be in first file then A950:G1898 will be in second file with file name A2

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