Hi dear members.
I want to make editable only yellow marked areas. Can anyone help me with this?
Thanks in advance!

Hi,

I am currently using the following VBA in my spreadsheet:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If ActiveCell.Interior.Color = RGB(128, 128, 128) Then
' Has Line, Select Next Cell
ActiveCell.Offset(1, 0).Range("A1").Select
End If

End Sub

I am trying to count non blank cells across multiple columns for different industry codes. Please see attached. I am trying to count for industry code 1 how many call 1, call 2, call 3 etc. occurred and then repeat for industry code 2, 3 etc.

I have tried lots of variations of the COUNTIFS function but here is one that I thought should work:

=COUNTIFS(A2:A30,1,C2:G30,"<>")

I am using Excel 2010.

Regards

Paul

I'm using a form in Excel that gets reset every time and re-used over and over again. It's a Special Order Form, and I already figured out how to get an ascending order number generator to work in it to generate a Special Order Number. The cell the number generation occurs in is "D2". There are many different fields on this order form that I would like to get transferred to the 2nd sheet which I've named "TRACKING", to be used for order tracking purposes.

sir actually am having .xlsm file which is with tamil content,but when am opening it in ms excel2007,it is displaying as something in english like gfsd; likewise instead of tamil.how to resolve it..please help me

I wonder if someone can suggest a way in excel to analyse weather data please.

I have a weather station which records many perameters every five minutes, into an excel spreadsheet. For the month of August there are 5,660 lines and 23 columns. Each day is around 285 lines. Each 5 minute record is a single line. I want if I can to produce a bell curve of temperature.

The temperature values on any day may be from 19.9 to 33.5 (degrees) in a single column.

I have a set of data which looks like this:

Property Name 1 | Attribute type 1 | Attribute 1
Property Name 1 | Attribute type 2 | Attribute 2
Property Name 1 | Attribute type 3 | Attribute 3
Property Name 1 | Attribute type 4 | Attribute 4

Property Name 2 | Attribute type 2 | Attribute 2
Property Name 2 | Attribute type 4 | Attribute 4
Property Name 2 | Attribute type 1 | Attribute 1
Property Name 2 | Attribute type 5 | Attribute 5
Property Name 2 | Attribute type 6 | Attribute 6

Dear all,
i would like to request your help in this issue:

I have an excell sheet consiset of 4 column ( column A has text , column B has anumbers )

i need to do:
- for example i need to count similar text ( start )in ( A ) but only for value (1) from ( B) and put the total in D2

if B = 1
{
if A =" START "
{
D2 = NUMBER OF repeated cell by START in column A

}
}

how can i do that in sheet

Thanks in advance
Maher

hi i am new to this forum i have a litle problem to ask for solution i have this macro to search for models from this site but returns to me all the page of the product my question is there something to add in this macro to search a certain div class in this page to return me only the price or something like that?
Thanx for your time

Sub URL_Get_Query()
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://www.mediamarkt.gr/webapp/wcs/stores/servlet/MultiChannelSearch?storeId=99452&langId=-18&searchProfile=onlineshop&searchParams=&path=&query=[""search""]", _

I have a 600 page excel document. When I copy and paste a page into the document, the cells on the very last pages of the document scrunch up. I need to be able to copy and paste pages within my document without the last cells compressing. Can anyone offer some advice?

Greetings,

I have a pivot table setup in Excel 2003. It has 3 Page fields - Month, Week and Date.

What i was trying to accomplish is - if at all the user changes the date using the Date field, the pivot should refresh, else no action.

I have tried Worksheet_PivotTableUpdate & Worksheet_Change but didnt go far.

The following is the code i tried after researching but it wont work...

Select Code copy to clipboard
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, PivotTables("PivotTable2").PageRange.Columns(2)) Is Nothing Then
Exit Sub
Else

Hi,
I have 2 lists, both have a common unique identifier (i.e name). The lists are not identical. List 1 has extra names, and List 2 has a column (column 3) with data (i.e. 5 days) that corresponds to the names, tHis column is not in List 1.

I want to pull the data from column 3 in List 2, in to a new column in List 1, so that it goes into the correct rows acording to its unique identifier. Is this possible?

Can I do this with out sorting both lists first?

Any help is greatly appreciated!

Hello,

I have a worksheet called "Fulltable" - I am want to copy any rows if there is a colored cell RGB(255, 255, 0) in that row, and I want to paste it to a different table "Loaded" into the next available row.

The number of total rows in the "fulltable" will vary

Is there an easy vba way to do this?

Thanks!

Hello Everyone,

Just curious if there is a way to copy from any open workbook to a new workbook? In other words...I'd like to have the ability to open any workbook of choice and run a macro from my personal quick access toolbar that copies data and paste values into another workbook without having to write the code to a specific workbook each time. Any ideas?

I have the code written to open a new workbook and save with a new name, but I'm stumped on the copy/paste portion of the code. Any help would be appreciated.

Thank you in advance!

When I reference another cell with =Y392 for example.

If there is no value in Y392 it fills the cell with 0.

I have other sheets that I've used this referencing in and that doesn't happen the cell remains blank.

Here's a snapshot.

Hello,
I am using a user form I created to copy CSV files to a macro enabled workbook. The user picks from a drop down list of about 7 tabs and the form appends the data to that tab. That works fine. However, I have 3 columns I need to change to number and add leading zeros. For example, 3 becomes 00003. No matter what code I try, I cannot get this to work and I've tried a large number. The columns in question are B, D, and F. Right now, I'm just trying to get B to convert. This is Excel 2010. Does anyone have any suggestions because I'm pulling my hair out over here?!?

Jeff

I am trying to auto fill the cell references 'S8' from each of my workbook sheets onto a final summary.
I have tried using the INDIRECT function but am getting a 'REF' error each time. The first sheet is called '01-07 Sep 2014'
Any suggestions would be great.
thanks
Leigh

Hi,
I must confess early on, whilst used to Excel, I only use it for basic sums and sorting etc, so not in any depth.

I recently became self employed, and after using a few different software packages, decided for now to use Excel itself.
This obviously lends itself well, but at the same time I need to customise a spreadsheet for my accounts, and another for Invoicing.

I am after some help with these - if possible.?

Accounts

Hi

I am absolutely new to VBA and trying to create a macro for work. We get daily files with almost the same headers that needs to be consolidated at the end of every month. The headers on the files are usually the same, except at times an extra column may be added at the beginning.
I need a macro to do the following-
Prompt to select the desired files.

Greetings to everyone

i m stuck into some issue ImageImage

i hav 2 month & year from ("AE2" to "AI2") & ("AE7" to "AI7")

in front of month Jan with Year 2014 (B3 & B4) i have Dyas from "D3 to AH3" and Dates "D4 to AH4" and from "D5 to AH5" it is filled with H/L, C/L, P, M/L etc. all these ("D3 to AH3, "D4 to AH4" & "D5 to AH5") are in horizontal format and same with case of month Feb with Year 2014 ("AE7" to "AI7").

the problem i m facing i want these all horizontal format data (AE2 to AI2 & D3 to AH3 & D4 to AH4 & D5 to AH5) in vertical format

Hi, I am looking to build a sum formula at the bottom of a column that has a constant starting cell (row 3), but the end of the column of numbers can vary. I want to build a sum formula at the bottom of this column, that can account for a varying number of rows.

I am in stock market and i wish to POST comment on web using VBA code in excel.

my comment is "Buy at Current price Target 690 SL 645".

i visit this link to upload comments
http://zarabol.rediff.com/Bharat-Pet...on-Ltd/7083642

i have URL list of all the stock in my excel sheet.

there are many stocks like
state bank of india
lupin
bata
tcs
and many more

i have link of every stock in excel.

currently i do copy paste which is very time consuming.

my login id is kodaksecurities Pass : 123456

Hello!

I have 7 sheets in a workbook that I need to save as separate files. I can do it either as HTML or PDF but I cannot seem to get coding to work. I am new to VBA. I have searched and checked with some VBA trained people and no one can seem to get a code that works.

I set up cell A1 on each sheet to be the file name, minus the file extension. As an example - the sheet named "Admin" in cell A1 = "Admin8202014" this way I can have the name and date in the file name for each sheet. I have the print area set up for each of the 7 sheets.

Can anyone help with this? Is this even possible?

I have a worksheet that has names and addresses and then one column has a # sign (this signifies end of a bundle). A coworker set up a foxpro program to pull out the bundles of two. He no longer works for my company i have no way of contacting him and i know nothing about foxpro. so i need to do this in excell.
ive attached a sample. What i need to do is cut rows based on value in BRK_LVL1. I.E in the attached sample I would not cut rows 2,3,4 but would cut rows 5 and 6.

Dear All,
I have a thousand of workbook, Stored in Folder/Sub-folder.
All workbook contains sheet LayOut. Layout have 4 text box as
Text Box 88, Text Box 100, Text Box 104.Text Box 112.

I want to copy Text Box 88, Text Box 100, Text Box 104.Text Box 112 from
all LayOut sheet from that folder.

Please help me.

Hello,

I am trying to create a schedule for my team. What I want it to do is count the numbered amount of tests due in column R if the column is blank. But if the column equals either 'pass, fail or deferred' as the text then I want it to subtract it from the total due.

What formula could I use for that?

It seems like =countblank should work, since i only want the count of cells that are empty and then when 'pass, fail or deferred' is entered it would then subtract those from the total. However, when i enter the =countblank formula, it says "FALSE" instead of a number.

I am trying to copy an Excel 2010 template from one workbook file to another. I want to copy the content, formatting and column widths. No matter what I try when pasting the contents I can't get it to copy over with all of the original content and formatting. The destination workbook is in differnt places in the workbooks I'm using, but it has the correct number of columns in every case. Included in the file are boxes that show a check mark when clicked and for some reason the boxes get cut off/disappear or move when copying over. Any thoughts on this?

Hello there i have a.spreadsheet with a order date in one cell, i would like that cell to change colour when the current date has passed the order date by 5 days, i have tried several ways to do this but i am missing something and would like help from the forum
thanks you in advance

I have 2 sheets in same excel.( i have also attached sample file for data) .
Please help its urgent.

Sheet 1:
A B C D E F
HR 2015 Q1 Database Planned 176
CRM 2014 Q4 Major Product Planned 125
HCM 2015 Q1 Database Planned 113

Sheet 2:
A B C D E
Doc 2015 Y 176 -----

simple requirement is to search column A in sheet 1 based on Column D in sheet 2. and write it in Column E.

The answer should be
A B C D E
Doc 2015 Y 176 HR