automatic data entry

[robert.begley1]

Hi guys,
can anyone help me
I have a spreadsheet with four sheets, jan feb march and log
I need the forth sheet to automatically enter data with no gaps in rows as data is entered into the first three.
I have attached a sample copy
many thanks if you manage to
a) understand what I need
b) come up with a solution
c) just for taking the time to look

cheers
Rob

[niko79542]

Hi,

Is there a particular order you want the records?

Niko

---------- Post added at 02:18 PM ---------- Previous post was at 01:39 PM ----------

Please Login or Register  to view this content.

[robert.begley1]

Hi Niko,
it would be great if the entries on sheet four magically went into date order, a final touch but not imperative.
thank you for your help, I have the kids to put to bed and read stories, but will try your macs later.
thank you for your help
cheers
Rob

---------- Post added at 07:38 PM ---------- Previous post was at 07:25 PM ----------

Hi Niko,
couldn't wait, its magic, just one thing is there a way this macro will run automatically so that I don't have to run it each time to update sheet four.
I don't know some people are never satisfied....lol
thank you again
cheers
Rob

[niko79542]

I'm a newbie just like you. I have your answer although there is surely a simpler way to do this.

Add this code to each of the three worksheet objects. (e.g. Sheet1(april), Sheet2(may), Sheet3(june))

I would have thought you could just add this to the Workbook object, but I guess not.

So yeah, just copy paste this code into those three sheets. Adios!

deleteme.jpg

Please Login or Register  to view this content.

[royUK]

You haven't thought out the design so need to resort to VBA.

One sheet with all the data in could then use a PivotTable to summarise by Months

[robert.begley1]

Hi Roy,
I know where you are coming from, but this example of the spread sheet is only part of a full sheet, there are several headings of various items on each months sheet.
each heading has different values to be taken care of so all data cannot be entered under same column heading. I have not explained this too we'll, but there is a reason for not using pivot tables in this instance.
I value your point though.
cheers
Rob

[niko79542]

Rob, can this be resolved?