Posts by ifathy

Hi,

I have a sheet and need to do the following:

If cell R3=Flase i need to hide row 79
If cell S3=Flase i need to hide row 80

and so on

Any help?

Thanks

Re: Create price list and select options

Thanks a lot, what if i just need the total to be shown in a specific cell, lets say J20

Hi,

I have an Options price list as attached, i need to select the options that i need in Column A, then it calculate automatically the prices in Column J relevant to selected options in a desired cell.
And if possible to hide un-selected items

Thanks,
Islam

Re: Compare a Trend of data

Hi,

anybody can help?

Re: Compare a Trend of data

Hi,

Thanks for your reply, please find attached data

Hi,

I have a huge database of our sales to customers for the last 7 years classified by "Year" in Columns and "Customer" in Rows.
I need something to look on the sales trend, for example:

- Customers who stopped buying for the last 2 years
- Customer sales that was dropped by more 50% for the last 2 years

I am thinking of something to compare 2010 sales with 2011, then 2011 with 2012 and so on !!

Is it possible?

Thanks,
Islam

Re: Assign a List of numbers to a List of names

Please need to ask more question, what if i need to use Column B instead of Column A, i mean if i need to put the customer name and it fill Column A and C automatically
I tried to play with it myself but didn't work

Thanks

Re: Assign a List of numbers to a List of names

Great, got it
really appreciated

Re: Assign a List of numbers to a List of names

Thanks again, it works perfectly

One last question, what if i need to add more columns lets say column D and E? what should i change

Re: Assign a List of numbers to a List of names

You are my hero

what if i need to use the same data in another sheet (Sheet2 for example)?

Re: Assign a List of numbers to a List of names

Thanks a lot,

This is what i did, i copied the code to Sheet1, but when i start entering the data it is shifted by 1 row, as follows
- If i enter 5005 (Cell A2) in cell A1075 it automatically enter "Customer name" (Cell B1 not B2) in B1075 and "Segment" (Cell C1 not C2) in C1075

I believe something need to be adjusted ?
and what if i need to use the same data in Sheet2 for example?

Re: Assign a List of numbers to a List of names

Thanks for the prompt reply.

Yes this is what exactly what i am looking for. If you please explain how to do it in details i will appreciate that.

Thanks

Re: Assign a List of numbers to a List of names

Please find attached file

Hi,

I have a long list of customers (above 1000), includes 3 columns

- Customer name
- Customer Number
- Segment

I need to associate each number to the relevant customer name and Segment, so when i add a new entry by Customer name that it automatically add the Name and the Segment.

Thanks,
Islam