Search results

Hi, I have a data in Excel with three data fields First Name, Last Name and Email ID. I want to fill the data in one of the web portal link is https://zoom.us/webinar/register/WN_mw4vHQDEQpmm14PEnrP45w attaching excel sheet with data. can u guide how to fill excel data automatically to the web...

thanks

Hi I have data from April 2019 to Mar 2020. When i put the pivot table and put the date as group in the first it is coming as Jan Month in the first row. But i want April Month to come in the first row. Because our Quarter is (April to March). Kindly guide how to do in Pivot Table...

2010

Hi, I am getting the Email Body Message for a Enquiry (Attaching the Input in the yellow color in the excel sheet). But when i try to paste in excel the body is paster in one single cell. There date to be filled in the four fields ie Name, Email Address , Telephone Number and Message...

Hi Ataching the updated file can u help in macro for the output data

yes

hi can u provide the solution for transpose data

Hi Thanks for the macro . If i want to add extra column where to change the code I added two columns but the data is not filling properly attached the file for the reference. And also if i want to copy the file in the next sheet what is the macro code Regards shahul

thanks if any macro is there

Hi Attaching the excel sheet contains student data. I am give two things one Raw Data & Output need given in the sheet (what actual output i need) any body can help Regards Shahul

thanks sir!

Hi I am attaching the excel file it contains three data projected , achieved and target. If i put the chart it is giving only one color ie blue color. Any body guide how to differentiate with color. My requirement is the Target chart show in blue color, achieved chart in green color...

hi i am asking for the password set in general option like open the workbook

Hi I have created one excel file and set the password but unfortunately i forget the password. kindly guide how to retrieve the password through vba macros. Regards Shahul

Hi, I have a multiple excel workbooks. I want to consolidate all the workbook in to one sheet. can you provide the macro code regards shahul

Thanks a lot!!!! working fine.

Dear Team, I have the below macro code in that i have three subroutine macros ie. balance, status and refund. For selecting the rows where the data available now i use the variable and given the inputbox for resize code. With foundcell.Offset(1).Resize(xx) My requirements is if i run the below...

Hi The logic is below In the second entry Mr. Peter is Crediting Rs. 3000/- to Mr. RAM. So credit to Mr. Ram and Debit to Mr. Peter for Rs.3000/- In the third entry Mr. Peter is reverting the amount of Rs. 1000/- from Mr. Ram. So Credit to Mr. Peter and Debit t Mr. Ram for Rs.1000/-

Hi Now i add one scenario as Debit in the Transaction column. And also i have applied one more vlookup and adding the value. Kindly go to the revised attached file and provide the formula Regards Shahul

Hi Attaching the sample file with Four sheets 1) Dashboard 2) Data 3) Pivot 1 4) Pivot 4 My requirement is to pull the raw data and fill in to the dashboard sheet. It is an accounting double entry system ie debit and Credit Now for pulling the data i have to put the pivot table two times...

Hi Any body help on the above topic

Hi I am attaching the two sheets 1) Dashboard 2) Template Sample My requirement is if run the macro automatically the balance data is fetch from the template sample sheet to dashboard sheet using vlookup formula And the Success status data is fetch from the template sample sheet to...

Dear Team, I need the formula for the attached sheet. I contains two sheets one is Raw Data and output Based on the raw data i want the output using the formula which has three status like success, pending and failed. The same now i using in pivot table but every time i have to change the...

Dear Team, Attaching the sample file . Which contains three sheets 1) Dashboard 2) data 3) Pivot Table. My required macro is the Raw data to be make as pivot table. From the pivot table the same has to put as v lookup in the Dashboard file. The raw data change then the pivot and dashboard...