Auditors

[specialsimon 0]

I'm trying to finish a spreadsheet that will save countless man hours in completing forms. What I need to happen is when button is pressed on Sheet 1 it takes information row by row on Sheet 1 and populate fields on Sheet 2 until all the rows on Sheet 1 have been processed. I think it might need a script or macros to do it. I have specced it very well but don't have the technical ability to finsh it off. I reckon it would take someone who knows what they are doing an hour max to do the job and I am happy to pay a small sum if anyone can do it.

Thought I would ask here before I head over to Freelancers.com

[Burnie 2,084]

Do you have Microsoft Access as from what you seem to be describing might be better served using Access query functions.

Of course you would have to re-create your output form in Access

Edited November 23, 2012 by Burnie

[specialsimon 0]

I agree normally I wouldn't use Excel but where the file will be used I'm limited by slightly outdated computers with slightly outdated software. It needs to work in Excel 2003.

[medic1 0]

I'm trying to finish a spreadsheet that will save countless man hours in completing forms. What I need to happen is when button is pressed on Sheet 1 it takes information row by row on Sheet 1 and populate fields on Sheet 2 until all the rows on Sheet 1 have been processed. I think it might need a script or macros to do it. I have specced it very well but don't have the technical ability to finsh it off. I reckon it would take someone who knows what they are doing an hour max to do the job and I am happy to pay a small sum if anyone can do it.

Thought I would ask here before I head over to Freelancers.com

i think you mean auto fill

hold ctrl and click on the worksheets you want to share data.

then under the home tab press fill under editing and then across worksheets

that should do the job you are describing

[Burnie 2,084]

Abstract usage of mail merge?

[Administrative Account 7]

Can you explain this a little better? To me at least it's really not clear what it is you are trying to achieve.

You can duplicate pages/sheets once you have completed one to your satisfaction to save setting it all out all over again, if that's what you're getting at?

[Buck + 293]

SpecialSimon - Can you post a non-sensitive version of you full spec up on here so we can give you a better answer? I can think of a few different things you mean, and so can the other posters by the looks of things. Whatever way it is, it sounds fairly easy for a techie.

[specialsimon 0]

If people PM me their email I will send it over. Nothing sensitive/restricted (or interesting) in it.

[SCBravo 8]

If you have any coding knowledge it'll be relatively straightforward to do as a macro using VBA.

As pseudocode:

Select Range

Loop Until Range.End

Select Range (Sheet1.Column A)

Copy (Sheet2.Column A)

End

If I get the chance I'll try and find an example online.

[specialsimon 0]

This is sorted now. Credit to Buck for being an all round awesome guy.

[cmdkeen 0]

If you have any coding knowledge it'll be relatively straightforward to do as a macro using VBA.

As pseudocode:

Select Range

Loop Until Range.End

Select Range (Sheet1.Column A)

Copy (Sheet2.Column A)

End

If I get the chance I'll try and find an example online.

From my dim and distant days of playing with VBA you don't even need to loop, in just the same way that you can use keys to jump to the end of the current block of cells with data in you can do that programmatically as well.

This sounds like exactly the kind of thing that shouldn't be being done in Excel if its going to be used widely mind you...