EXCEL FORMULA CHANGE
Current time: 05-22-2018, 02:51 PM
Users browsing this thread: 1 Guest(s)
Author: RANA WASEEM
Last Post: kirankumarklk
Replies 2
Views 4124

EXCEL FORMULA CHANGE
#1
EXECL FORMULA CHANGE
[Image: 36855461157603729332_thumb.jpg]
[Image: info.png]
Have you ever got into a situation where you had, lets say 100 excel files, and after designing those excel sheets
you said to yourself, "Oh No!, I made a mistake, I want to change H8 cell formula"
What you will do then?
Here is a soultion.

I have designed this excel sheet, because I once was trapped like this...
In my sheet you can just select the destination folder and tell it which cell to change....it will do it in 2 mins.





1-Clear the contents of Column A from Row No. 2 to onwards.

2-Press "GET FILE NAMES" and choose the folder.

3-Enter Row and Column numbers of cells in which you want to have some changes in target excel file.

4-Enter Formula against each change.

5-Press "CHANGE ALL FIIES"

***WARNING.....the is written only to change cells of FIRST SHEET OF DESTINATION EXCEL FILE.....WARNING***


NOTE TO VISUAL BASIC INTERESTED GUYZ!

This coding is only applicable if you want to change some formula.... but you can modify my code to make it do anything you want in EXCEL....enjoy



[Image: Download.png]

***************************************
Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:

http://forum.civilea.com/thread-27464.html
***************************************


[Image: password.png]

***************************************
Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:

http://forum.civilea.com/thread-27464.html
***************************************

WS
[-] The following 14 users say Thank You to RANA WASEEM for this post:
  • seb3k, sasan7351, jacky899, hmwere, suryabharat, 3fan, utan, ibg0203, araza023, dede, danny045, Umer.Aleem, ranger, mohcivil
Reply
#2
[Image: mirror.png]

***************************************
Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:

http://forum.civilea.com/thread-27464.html
***************************************

[-] The following 4 users say Thank You to 3fan for this post:
  • utan, ibg0203, RANA WASEEM, Dell_Brett
Reply
#3


***************************************
Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:

http://forum.civilea.com/thread-27464.html
***************************************

[-] The following 5 users say Thank You to kirankumarklk for this post:
  • RANA WASEEM, Jackass, Dell_Brett, ibg0203, mohcivil
Reply




Users browsing this thread: 1 Guest(s)