Thank you Kenneth for your help.
sorry, I missed the pw, I attached file after removing the pw.
PDF file saved in the same folder in path, same can be seen on search after copy paste path address in the search.
when I run the macro line by line with F8, .Display not bringing opening outlook, I...
Sorry, I was sick and off for two days.
Thank you for your response
No error message is popping, just end the procedure within 4 second without any action.
already commented on On error..., still no error message.
I tried to debug the code, each time variable value I checked...
I have below code to send PDF files from the path address given, it was working perfectly.
after upgrading to office 2016, it is not working at all. any help please...
If MsgBox(" Please make sure, you want to send the email to all the...
Thanks for your reply.
it is pasting value of row 9 in entire row.
I wanted to paste value of 9 in below 16 times, then there is value in 62, that also to be copied and pasted just below 16 times.. and so on.
Hope I conveyed correctly.
I am trying to write a code to copy cell value in a range if not equal to blank and paste below16 rows from active cell,after pasting one value it should go to next value in the range and do the same.
below code is doing the first task and not going next value. sample file is...
Really great, working elegant.
I know little code, but it is bouncing to my head, create object is new to me.
is it possible to help to learn this
If Evaluate("isref('" & e & "'!a1)") Then dic(e).Copy Sheets
I have attached sample file with code, where the sheet name is mentioned in C, I wanted copy value1, value2, and value3 and paste in concerned sheet in 25th row. I tried with lot of change. not succeeded this case.
Appreciate your help
I have below code to copy the data and paste in concerned sheet, sheet name is mentioned Sheet98.Range("C12:C137"). this is perfectly working, currently it is pasting in the second row of concerned sheet, I wanted paste data 25th row of concerned sheet, I am trying to change the...
Amazing...Thank you so much for your help. much appreciated.
Yes, Data should break by column D.
currently it is copying 19 rows one by one and printing without break.. below change is required in the code
-it is to break by Column 'D'.
Total in "I34" and count in "G34" at each...
Thank you for your help..
it just copy 20 line one time, please find the below requirement already detailed in the last email.
- If field Entry Number of Sheet Data in total 19 rows or below, it should copy that rows and Print. total count should come in G34 and sum in I34. Page...
Thank you for your reply PCosta.
Please find the attachment, I have data listed in the Sheet named Data.
I wanted to bring the data in Sheet <Format> and print by field Entry Number.
In the Sheet Format can accommodate 19 rows, therefore If field Entry Number of Sheet Data in 19 rows or below...
I am stuck with something, would be really helpful if a solution.
I have data in A2:L5000 in sheet1. in column 'I' it is 'Amount' and in Column 'D' it is 'Entry number'
In sheet2 I have format set with letter head which can accommodate 19 row.
I wanted to copy each 19 rows from...
I have number trillion and million in a column and make it to the chart. the follow code pasted in the format cell custom- working fine for million and billion. Please help me how do i get it work for trillion too.
[>999999999.999]#.0,,, _-"B";[>999999.999]#.0,, "M";#,##0...
I have below custom to display B instead of billion an M and instead of million. could you tell me how to add trillion also to this
[>999999999.999]#.0,,, _-"B";[>999999.999]#.0,, "M";#,##0 _M
Thanks for this. Second link is half suitable for me. this is extracting to different workbook. i wanted to extract in different sheets in the same workbook which already available with name of filtering value. Please advice