making up data

Hi, I'm looking for help making up data for my table I've created 225 rows and realise it would take too long to get to 30+k so luckily I know how to ask Google and hey presto there is a site called excel forum, let hope someone can help. I need to make data appear based on parameters so varying values like start and end dates as well as sums that fit into my parameter. I'm giving up for the day but tomorrow I would love to not have to get back at it with making up data.

Looking forward to your replies, many thanks.

I by that you mean copy and paste this is not possible as I need the dates and amount in £ to differ

Originally Posted by iaak1983

I by that you mean copy and paste this is not possible as I need the dates and amount in £ to differ

meant "if"

Did you look at the file that is attached?

Basically, a continuation of rows with the daily number of start day entries growing, the duration being minimum 14-day to max two years, £ amount minimum 50 max 2500,
the rest is a calculation of percentage which does itself I need have entries beginning for three years so would work out at 10s of thousands of row. Which could mean
on the last day of year three there could be well over 100 entries.

No bother if you cannot read minds.

365 mso 64 bit is all i can find

It looks right yeah but I'm wondering if you know for a tutorial or to guide me to do it, just looking over the work it's great but the amounts need to vary more including many more low amounts for example 40% of amounts would be 50-500£, 30% 500-1750, 30% 1750-2500£. And the start dates would be chronological with acendins id numbers in cronolocical order also. however I'm asking for ways I can do this don't want the work done for me as I would like to learn

asking google about creating data for excel spreadsheets just brings me to many instructions on how to input data or create tables not been able to find anything on materialising data on set perameters.

Much appreciate it tho

Originally Posted by iaak1983

365 mso 64 bit is all i can find

Originally Posted by AliGW

Please update your forum profile, as requested.

Did I see the attachment? Yes, I did, and I looked at it before I responded. It means absolutely nothing to me. Hopefully someone else will be able to work out what you want.

thank you for looking, what do you want me to do to my profile i have not had a request

Originally Posted by iaak1983

365 mso 64 bit is all i can find

Originally Posted by Glenn Kennedy

Iteration 2. The values should be closer to what you want. Are they?

Don't worry about the date yet.

Glenn, it's great that you are wanting to spend your time on this with me but I really am after learning how to do it myself that's all. I will have much more work to do down the line with this hopefully. I m a student and don't have the means to pay anyone for work just so you know. I know you said dont worry about the date however my data will involve start dates within a three year period so the firs start date and the last start date cannot be more than three years apart. The values are great looking btw

Do you know what search term i should be using to look up instructions on how to formulate large amounts of data like this?

Thanks again,

Originally Posted by iaak1983

365 mso 64 bit is all i can find

Originally Posted by Glenn Kennedy

I see you have now gone offline.

i will now finish the process and HOPE it's all OK.

1. delete the blank rows above the data (makes selecting the data to be sorted easier).

2. select columnf F, G & H.

3. Copy/Paste VALUES This overwrites the volatile formulae and fixes the values.

4. With columns F, G & H selected...

5. Data/Sort/Sort by column/start date

6. Job done.

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It would also be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

WOW, this is awesome thanks very much for the formulas too it has given me some further insight into what I'm doing. I'm trying to get some ideas of what I could generate with a platform I have in mind and this is the first step I have some insight into making it into charts to the represent different things will be back later on in the week once I most certainly hit a brick wall but for now very much appreciate your support here.