Hi,

I am developing a data entry tool using excel i need some help on how to block some cells which is having cell background color.

example:

I have seen similar posts on this problem, but none worked for me. I have a workbook with 5 sheets, it's part of a finance project. What I would like to do is in input all new information on the first sheet, then have the other sheets auto populate with that data. For example, on the first sheet, all data from a20:g30 should populate on sheet 2, all data from a40:g50 should populate on sheet 3, etc. is there a way to accomplish this? I am a beginner when it comes to complicated formulas and macros, so please be detailed, any help is greatly appreciated!!!

Hi Everyone,

I have written a function called CUSTOMSUM and the input value (highlighted in yellow) will be multiplied by a number depending on which item I chose from the drop-down box.

The function works in excel but I will need to refresh it everytime for the code to work.

Could someone please advise. I don't want to print the number out for each fruit so I stored it in a variable.

Thanks!!

Hello

Have a spreadsheet i want people to see on the web and give them the ability to choose the way they want to see the spreadsheet (VBA driven), but i dont want the spreadsheet in the cloud or accessible to users, proprietary spreadsheet.

What would be the best way to approach this architecture wise? Silverlight as a front end to excel services?

Thank you.

Hi,
I have several tables, each table is for a specific altitude, where torque is calculated based on a given temperature.
I need help to find a way to create 1 table that uses all the calculation from the other tables, where torque is calculated based on given temperature and altitude.
For example:
for altitude 4000 and temperature 30, torque is 93.2.
for altitude 6000 and temperature 25, torque is 90.5.
What If I want the torque for altitude 5000 and temperature 20, is there any way?

I provided a sample for better understanding.

Scenario:

2 supplier available (Supplier A and Supplier B) and both suppliers provide hotel and tour.

Hotel supply by Supplier A: Hotel 1, Hotel 2, Hotel 3
Hotel supply by Supplier B: Hotel 2, Hotel 3, Hotel 4

Flight supply by Supplier A: Flight 1, Flight 2, Flight 3
Flight supply by Supplier B: Flight 2, Flight 3, Flight 4

How to create as below in excel where, when select Supplier A in drop list, Hotel will only show Hotel 1-3 and Flight will only show Flight 1-3:

Supplier:
(Supplier A/Supplier B in drop down)

Is there a way in Excel 2010 to sort on a partial date field? I would like to be able to sort reports using just the month and year portion of a date field.
Also is there a way to filter on the same portion of the date field using the advanced filter?

Thank you.

Cati

I do not see an option to add attachments here. Maybe it will appear after I click Preview. If not I guess I can not add an attachment. I see an area attachments should display, but no way to attach anything. Do you have any other suggestions?

Hi Experts,

I want to track schedule of list of activities based on date. Following is the scenario.

Please refer to the following data,,,. Based on this scenario... I want to;

Activity End date Status

Create User manual 6/1/2013 Complete
Provide Training 6/3/2013 Complete
Maintain master data 6/10/2013 In Progress
Post transaction 7/1/2013 In Progress
Reporting 7/31/2013 Not Started

Hello,

I have attached sample spreadsheet, In the spreadsheet you can find multiple sheets, I need to consolidate all the data in final sheet.

Eg: Sheet1 to sheet5 please do not consider, From sheet KY9374 to sheet KZ1768 we need to consolidate in final sheet.

Header details are common in all the sheets, we need to copy data from sheet KY9374 with header, then sheet KU7991 data without header, then KW8660 data without header etc.,

Firstly, apologies if this has been asked before but I have been trawling the site for half an hour and haven't found a solution to the question I'm asking. Some of the questions are close but I haven't been able to apply the answers to this issue.

In a nutshell, I have two columns of data in a spreadsheet, column A are the "groups" and column B is a list of names. I would like to transpose the data, grouping by column A, as follows.

CURRENT LAYOUT

C-- Steve
A-- James
A-- Alex
B-- Sarah
D-- David
A-- Joanna
D-- Colin
A-- Brian
D-- Peter
E-- Sally

DESIRED LAYOUT

I was provided an Excel template to create a timeline for an education project. I’m told the template was initially produced by a project engineer – he created it in some other software, and then exported / or re-created it in Excel. (Unfortunately, he is not around to consult with.) The spreadsheet uses drop-down lists in the Start and End columns to select the relevant weeks in the schedule, and colored bars that move as the week range is selected. (see attached)

HI,

i m working as hr. i have created a leave file in excel. I need formula to calculate the leaves balances i.e., to deduct the leaves from opening balance and show the remaining balance in closing balance, on following conditions.

Condition 1:

If employee status (Column E) is confirmed, then employee will get PL - 15 days, CL - 8 days and sick leaves - 7 days.

if employee status is probation then PL,CL and SL is 0 days.

Once i enter the employee status the above mentioned leaves days has to credited in opening balance (column H, I, J).

Condition 2:

Hello All,

Does anybody know how to copy only single cells that are 26 rows apart in one sheet to paste over and create a summary list in another sheet?

For example in Sheet2 I have a long list of data and I only want to pick out and copy across the cells that are in G4, G30, G56....and so on.

I will then paste these in a short list in Sheet1 starting in A1,A2,A3 etc to create basically a short summary list of the values of them specific cells.

Does anyone know if there is a simple formula for this in Excel 2010?

Good Day All!,

I am going crazy with an issue and am hoping that someone can give me some advice. I just wanted to find out if it is possible to make the following formula work within VBA. Right now it is too many characters for (1) Excel Cell and the amount of formulas in my overall spreadsheet takes FOREVER to load. If it's possible and someone could explain how, I'd be greatly appreciative.

The formula:

Hello friends,

Please help me for following issue.

I have created an attendance sheet in excel having 12 sheets (for all months like Jan, Feb, etc). in each sheets, all activities like number of present day, absent day, etc are counted. Now I want to add one more sheet that should have result of all sheets (say, total present day, absent day, etc of an executive month wise and it should be added at the end i.e. total present day, absent day etc of an executive in a year)

Please suggest how to do it.

Hi I was wondering if i could get some help here with a thing I'm trying to create for my workplace. We are a school for special needs children and most of my colleagues can barely turn on a computer. yet we will soon be obliged to a digital workspace. for this we need forms for rapports documentation etc. So we've al decided on Excel for our daily reporting on the work and progress of our pupils. Ideally the Excel sheet wil have 31 tabs for a month, each tab a printable form (A4 size) for us to wrtie stuff into.

Good day all,

I have a spredsheet which makes reference to "My table" in the code below

Sub NewSheetData()

Dim rCell As Range
Dim Rng As Range
Dim MySh As String
Dim lw As Integer
Dim lr As Integer
Dim sh As Worksheet

Application.ScreenUpdating = False
Set sh = Sheets("All Vehicles")
sh.Activate
Set Rng = Range("A1:A" & Range("A65536").End(xlUp).Row)
Rng.Select

For Each rCell In Range("MyTable")
On Error Resume Next
MySh = rCell.Value
With Rng
.AutoFilter , Field:=1, Criteria1:=rCell.Value

Hi I need help in my worksheet attached...

In the first Tab (Ticket List), I need help in the SLA Failed Column.
It should work like this..

If priority 1, SLA should be within 30 min
If priority 2, SLA should be within 24 hours
If priority 3, SLA should be within 48 hours

It would say Yes with a Red highlight in the SLA Failed Column if it exceeds the following stated above according to priority

------------------------------

I also need help in generating a report, in the second tab (Report Transaction), user can type in the start date and end date.

Below is a code that I now have working, It takes the sheet "INITIATING DEVICES" and searches for column "G" if column "G" has a value of "Yes" then it will copy that row, only columns "A, B, C" to worksheet "MESSAGE CHANGES". The only problem is that it must be run via a Macro command or a virtual button and is not very good when you need it right away. I was wondering how I could make the code run automatically so that the second the "Yes" is selected from the dropdown list the user would be moved to the "MESSAGE CHANGES" page so that they could input the information.

Hi Guys,

I'm looking for some assistantance with excel. I have been attempting to set up the following but have had no luck:

Basically,

'in the first box I would to type a start date

'Second box should find or show the available info for that date range (the range of dates and info will be available to use for fomulas)

'Third box should then generate a 'a link or file path for the correct set range of data I have listed'

Now, I need some assistance as to how to set this up on excel, any ideas?

Thank you.

Not VBA (sorry, don't even know what that is!), only what will be a basic Excel formula, but I'd appreciate knowing how to do what I want as I'm an old dog learning new tricks and have only fairly recently taught myself to set up a spreadsheet in an old version of Excel (2000), and got stuck with this one. So if you wouldn't mind helping a bit of a simpleton...

How do I add two ranges of cells together and at the same time deduct another two ranges?

How to Fill blank cells with 0 to multiple worksheets at once?
Plz help.

Hi

I wish to make dynamic chart of attached file, in same sheet.something like dashboard

I'd like a macro that will delete from Worksheet 1 duplicated rows of data found on Worksheet 2. For instance, it would work like this. WorkSheet 2 contains 4 columns of several rows of data. WorkSheet 1 contain an indefinite numbers of rows made up of 6 columns of data. If any row on WS 1 (6 col's) contains any 4 col's of data found on WS 2, the entire associated row on WS 1 will be deleted regardless of sequence. Example:

Worksheet 1

A B C D E F
1 Jones, Carter, Wright, Brown, Fredricks, McGee

Hi guys;

I record a macro which contains the follwoing code:

Workbooks.Open Filename:="J:\MVS\Data\20130605\20130605-1008-je.xls"

Everyday, one folder called "YYYYMMDD" (today's date)and one file called "YYYYMMDD" (today's date)-1008-je.xls is created in our LAN. I want to make a change in the code so that the macro will pick up the new date automatically. For example, the macro will open the file J:\MVS\Data\20130606\20130606-1008-je.xls on the next day.

I appreciate your help in advance

Chris

Hi

My knowledge is just scratching the surface of what is possible with Excel so I need help please.

In each Row of a spreadsheet I have two adjacent cells in the following formats

NUMBER1{},NUMBER2{},NUMBER3{},NUMBER4{}……..NUMBERn{} where 'n' could be up to 35.(Mostly less majority less than 10)
e.g.: 2156{},976{},33{},21591{}

and
TXT1///TXT2///TXT3///TXT4…..///TXTn where 'n' is the same value in both cells.
e.g.: RED///YELLOW///GREEN///BLUE

The result I am trying to achieve should be stored in the same Row in the form:-

Hello,

On a weekly basis I will be preparing a report for my customer, now I thought of running this report through Macro. I am a beginner in Macro.

I will be getting a sheet from customer in that sheet column B will be date column and it will be sorted, later we will be retaining datas till current date and future dates complete rows need to be deleted.

Here we may or may not have the current date and we might get dates in multiples.

I am getting Runtime error 1004 in the line "ActiveCell.FormulaR1C1 = ...."
for the below mentioned code

Sub Macro17()
'
' Macro17 Macro
'

'
Windows("Test.xlsx").Activate
Sheets("Sheet7").Select

Range("A1").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
ActiveCell.FormulaR1C1 = _

I need to make my forumla's reference the cell above it, even when I insert a new row. Right now, I have cell F5 as the =SUM(F4-C5). This works fine, but the spreadsheet as a ton of rows and if I add a new row near the top, I want it to automatically formulate the ones below to match the inserted row. If I can make the formula reference the cell above always, it should work. I know this is possible but I can't figure it out!