Dears,
I have an excel file with Multiple Sheets. Is it possible to make the same formatting (Column, Row lengths, Font Size. complete formatting) of all the Sheets same as any particular Sheet (Sheet Name "231103")..
Actually, number of sheets are high; if i start working one by one it will...
Dear,
I have 03 files. Each file has same format.
1. A1 cell has date with formula "=Now()"
2. Each file is linked to get the data and file is auto genertaed daily.
Requirement.
1. A1 cell date to change from "=Now()" formula to date
2. Link to be disable or deleted because when the file is...
Dear,
1. Is it possible to delete the link of excel file without opening. My issue is that I have a file which has a link and I programically open it and take some data. It is giving error when it is open because the file is moved to another computer and link is not present. If I delete the...
Dears,
I need to calculate number of cells in a row based on Color. Kindly guide me how to do. It is in a row not in a column .
A7= Count cells in row 7 where Color is Yellow
Regards,
Faisal
Dear,
I have a file with 02 sheets,
1. Daily
2. R302
I need to find data from Sheet 2 based on DATE from Sheet 1 and fill the Column B & C in Sheet 1 if Reactor "A" else in Column E & F in sheet 1.
I am trying to use the following command but unfortunately i am not able to find Two criteria...
Dear,
I have a file with vba script; What is my requirement.
Instead of fixing the Cell name to assign a value use Name range and then use that name range in vb script. So, that if i add another column later. it will not fix the column but it will change automatically and assign the value.
I...
Dears,
I need to find out how i can compare two Cells having different strings to give result which is common in both;
like
A2: 05-08,16-17
B2: 00-13,16-17,22-23
Common in both cells: 16-17
How it is possible pragmatically? Kindly help
Regards,
Muhammad Faisal
Hello,
Is it possible to define Static Range of certain values inside the VB Script;
Example
Dim Rng as range
Set Rng = [0,10,20,30,40,50,60,70,80,90,100]
Means instead of setting range location from the sheet, giving fix vales
regards,
Dear,
I have certain files in a folder and i am collecting certain data from each file into a Master file. Every thing is working fine but data is not being copied DATEWISE. What i need is, script copy data from all files but Datewise not randomly.
Kindly guide,
Regards
Dear,
I am doing certain calcuations in vba script but getting error "Divide by Zero". I tried to use Worksheetfunction.Iferror but no use.
Any one can guide me how to encounter this problem?
Scenario is as;
I have two Columns A & B; Value of A is divided by value of B but when Value of B is...
Dear,
I have a file with 02 columns,
1. Time
2. Status
I need to get the time when the Status is "FALSE".
Example,
02:00:00
TRUE
03:00:00
TRUE
04:00:00
FALSE
05:00:00
FALSE
06:00:00
TRUE
07:00:00
TRUE
08:00:00
FALSE
09:00:00
FALSE
10:00:00
FALSE
11:00:00
FALSE...
Dear,
I am attaching a file which have certain readings every hour daily. I want to find out how to calculate no of hours when
1. FT1003 (Column C in SO2 Sheet) value was increasing
2. FT1003 (Column C in SO2 Sheet) value was not increasing
3. P101 (Column D in SO2 Sheet) value was "TRUE"
4...
Dear,
I have certain files in a folder with data; Each file has a certain date and hourly data. My objective is to collect all the data from all the files and merge into a "Plant Record File".
Plant Record File has datewise complete data which is copied from each file when Clicked on UPDATE...
Dear,
Is there any way to download multiple files from Google drive when i open my workbook? I found one code from internet to download single file and it works but i can not use this code for multiple files in a single workbook.
Regards,
Dear,
I need to make an excel file which have list of all the files from a specific folder with hyperlink. In addition with an update button, to update whenever a new file is added in that particular folder.
Regards,
Hello,
I have 2 files. Master & Data
BOth sheets have certain data based on daily date. What i need is,
When ever i open Master file, it checks last date data filled in master sheet, and fill the data in Master file taking from Data file upto last record.
Hope, i will get solution. Files...
Dear,
Kindly see the attached file;
Summary sheet has collection of certain data from each sheet in the worksheet.
1. When UPDATE button is clicked it updates whole data in the sheet. but i need to only add new record when new sheet is added and not to rewrite the whole data again in summary...
Dear,
I have a excel file on my google drive which is shared by my friend. I want to extract data from that file and store in local excel file at my desktop.
Kindly guide me how to do that
Regrds,