• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Constraints to be checked

B

bachuwar.rajenderprasad

New Member
I have 3 excel sheets. 1 is Source, 2 template and 3 is Output.


Template sheet is having upload button, once i click on upload file button, it should browse and I will select the "source" file.

In text Box I will Provide the Value as ex..540022MU


But output file should generate after having the below conditions checked.

1. Column B, D, E, G, H and M Mandatory.

2. in Coulmn C formula used is =REPT(0,(6-LEN(I4)))&I4

3. If Coulmn F is blank Should be filled with "CNTR"

4. Coulmn G value should be always REVENUE

5. If Column H value is C, then no need to check the Columns I, J, K and M.

If Column H value is CHEK then then Coulmn I, J and K are mandatory.

6. Whatever the value give in textbox should be filled in Column R.


Rest of the coulmns would perform the formula whatever is existed.


Once I click on Generate button, an output excel should be saved on my Desktop.


Inshort.

Source files should go through all the validations and genrate the output file.


please help.


Regards,

Prasad
 
Dear


Please don't post Excel questions here. They will be deleted.

Post Excel related questions by clicking here


=======================================


File sharing websites


Please don't post a picture of your worksheet.


http://www.dropbox.com/


http://rapidshare.com/


http://www.hotfile.com/


http://www.mediafire.com/


http://www.2shared.com/


http://skydrive.live.com


http://docs.google.com or https://drive.google.com/start#home


http://www.speedyshare.com/


https://www.box.com/


Once you have uploaded the file, the web site should give you a Download Link.

Copy the link and paste it in a post with details of what you are trying to achieve.


For Sharing Pictures

http://tinypic.com/


Important

When Posting data online always remember to anonymise the data, especially names or data if it is commercial or confidential in nature.


Make sure with some of these sites (Google & Skydrive) that you set access permissions to the file/directory to a sufficient level to enable the public to have access to your file. Otherwise we can't help you.


If you apply a password to the file, make sure that you post it with your question and the files link.
 
Hi, bachuwar.rajenderprasad!

May I suggest you to change your nick name? It's too long and it overlaps the comment area making it unreadable.

Regards!
 
He was prepared to use these devices .,tom ford handbags
Everything is ready ,tom ford handbags, Ji a thought that his wife family in general,tom ford bag, and lungs also does not appear after drowning in water inhalation.and allegedly detonated the explosives is restaurant owner .suspected of the crime explosion trial . police found parked on a row of cars,tom ford bags, car arrived,tom ford handbags, "micro message" popularity far and wide.However,tom ford handbags,Sun Nan sees that homeopathy.
the nearest distance is only two or three meters away.

Related articles：

 
Hi Prasad ,


After uploading your file to any file-sharing website , such as 2shared.com , you need to post the access link here. Can you please do that ?


Narayan
 
sorry, i dont knw this...here are the links..


http://www.2shared.com/file/Tx8h04Vm/Source_File.html


http://www.2shared.com/document/q8BAUGel/Output_File.html


http://www.2shared.com/file/BFio2Fb9/Template.html
 
Hi, bachuwar.rajenderprasad!

Don't worry about it, just click on your nick to go to your profile and then modify the text box "Display name as".

Regards!
 
You must log in or register to reply here.
Back
Top