I need to enter data into say A1 and have the same data entered into another location on the spread sheet.
The process is this:
1. User enters data into A1
2. User enters same data into say D51 (therefore establishing the location for the future data as the D51 location could be anywhere on the spread sheet).
3. From there the user only enters data into A2, A3, A4... etc and the macro completes D52, D53, D54....etc.
Would really appreciate some assistance.
Maybe this:
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
That is so close to what I need TMS.
Can I throw another factor in.
The D52, D53, D54 will be consistent for about 12 entries. The problem is that the offset will not be consistent, because A1, A2, A3 may then become D6, then E6, then A4. But the automatic entry must keep adding to the list.
Then a new list will be needed. So the user will enter A5 and E52 (identifying the point of reference), then user enters A6 with E53 the new automatic entry.
Difficult aren't I?
Regards
Yoepy
I'm sorry. I don't know enough (anything) about. the worksheet structure and content.
It is therefore very difficult not only to understand what you are trying to achieve and why, but then try to develop a solution in the dark to meet your needs.
The basic idea is that first cell entered becomes the base, the second cell becomes the copy location and determines the offset. Subsequent cells are then echoed using the offsets. You could probably just use the row offset and keep the column offset fixed (use the rCopy column instead of an offset.)
That would be something like (untested):How you'd go about indicating that you want to start a new list, I have no idea.Please Login or Register to view this content.
Please bear in mind that you know exactly what you are looking at and what you want to achieve and why, but nobody else does.
Interesting though it was, I'm out.
I appreciate your help.
Thank you.
You're welcome.
Note that you have the reset code. You could just attach that to a button and click on it when you want to start a new list.
Other than that, you'd need to check for some sort of key word (maybe, 'new') or a specific location to initiate a reset.
Regards, TMS
Ok, been mulling this over and here are some variations on a theme. The current one, I think does what you want. It looks for the text "new!" without the quotes to initiate a reset so a new list can start elsewhere.
Please Login or Register to view this content.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks