Search results

Dear, I wan to make a bar chart with below table BudgetActual SAP100.090.00 H210800.09000.00 but because the difference is high in SAP & H2 categories.... the Bar for SAP is very minimum. Is there any way to have different scales for SAP and H2 but on single graph...

Dear, I have a file with multiple sheets more than 100. I want same formatting and page size in all Means i want to print all but there are many sheets which are printing empty sheets as shown below. i need format like below Can you please help in doing this formatting for all sheets at...

Dear, I have a file with below Sheet Name:Dailywise Value in Column: AV Date in clumn: A there is another sheet name "Summary" in that sheet, for each month how to find the last non-empty cell value in Colum in AV from DailyWise Sheet where Date in Column A is matches with Date in Summary...

Hello, I have excel charts in excel which are copied to an powerpoint file. How i can update the excel charts in power point file when i open it without manual update of each chart. Is there any possibility? Regards, Faisal

Dear, I have 2 columns column b has months from jan to dec and column C has production values on monthly basis. i need to calculate weekly production based on date given in A1. Week starts from Sunday and ends in Saturday. For example consider A1 is 1st july 2024. it means the week is...

Hello I need to make a bar chart, A. B Prod1. 100. 25 Prod2. 100. 75 Critera. 1. When value in column B is grater than 90, colour should be green. 2. When value in column B is between 50- 90, colour should be Yellow. 3. When value in column B is...

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, Is there any way to send email by vb script when Excel file gets unprotected? Regards,

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...