Excel Macro for updating different columns

**Garshan300** · 08-17-2015, 09:17 AM

Hi all,

I have very Basic knowledge on Macros so any help would be great.

Basically i have a project in work where i need to collect information from each person and update a large table with this information.

the table that needs to be updated has 15+ columns but i will be only updating specific few from the table, they are not beside each other.

i have tried and made a macro that works but only if they are beside each other.

can any one help even if there a Video i can watch and teach myself how to do it that would be great.

the same fields will be for all inputs

thanks
G

**Doc.AElstein** · 08-17-2015, 11:22 AM

Originally Posted by Garshan300

.......
can any one help even if there a Video i can watch and teach myself how to do it that would be great.....G

I do not know of a video. But your requirement is very common. And lots of solutions for similar requirements are in Threads here. Try searching under things like, Consolidating worksheets... sheets to one sheet etc.. etc..
. it also a common sort of thread type that I answer, so click in my name up there in the left when you are logged in and check out some of my Threads of that nature..In particular you will see that my codes easily allow you to pick out the columns you want.

...
If you then still need specific help then please try to give somehow
Good before and after “ Pictures “ as well as your explanations so I or anyone else can see exactly what you want..

. The Before or Befores, should look just as it / they does before running of any macro.
.
. The After or Afters, should be hand filled by you so that it they / looks exactly as you want it to After running of any macro, based on the actual sample data in the Before / or Befores
. Make sure there is just enough data to demonstrate your need. Remember to desensitize the data if necessary, but use the typical Format type and choose your data carefully so that it can be used to test all possible scenarios.
...
To give these "Picture" - a few ways...

. 1 ) use the Forum Tools in my signature to produce screen shots we can copy to a spreadsheet ( NO IMAGES ! )
. 2 ) Post Files
. 2 a) To Attach a sample workbook:
View Pic
http://www.excelforum.com/members/da...ch-a-file.html
http://tinyurl.com/oenwprw
. 2 b) Send over a file sharing site, such as this free thing
Box Net,
https://www.box.com/
http://tinyurl.com/7chr7u8
. Remember to select Share and give the link / links they give.
. 3 c) Only as a last resort, P.M ( private Message ) . me and i will reply with my Email Addressee so you can send me a file
** To PM me, click on my name in the left hand margin when you are logged in, the rest should be obvious.

Alan