How to create dynamic column with generates cells based on values entered on another cell

**vivin007** · 03-20-2016, 01:33 AM

Hi Guys,

I am working on my cake delivery shop excel sheet where I need to generate cake fields based on the count entered on the 'Cake Needed' field

For Reference

Cake.JPG

So If I type in say 11 in 'Cake Needed' field, 11 sequential cake 1, cake 2 .......cake 11 fields should be generated.

How to do this by usig only formulas? I dont want Macro on my sheet...

Can anyone help to solve this riddle?

**l7faa** · 03-20-2016, 04:37 AM

Does this work?

**vivin007** · 03-20-2016, 04:54 AM

That's exactly what I needed.

Thank you, Added a Reputation for you.

How to create dynamic column with generates cells based on values entered on another cell

LinkBack

Thread Tools

Rate This Thread

Display

How to create dynamic column with generates cells based on values entered on another cell

Re: How to create dynamic column with generates cells based on values entered on another c

Re: How to create dynamic column with generates cells based on values entered on another c

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Create drop down lists based on data entered in two previous cell???

[SOLVED] trying to create a dynamic range based on column A cell value...index match?

[SOLVED] Create list of Cell Data (column B) based on value in same row, dynamic column.

Create dynamic column containing ONLY unique values from another column?

paste RNG numbers

Looking for a way to create a list based off of values entered by other users

Create a Pie Chart based on Date values entered.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions