Feasibility Study

[Moosgraves]

Hi,

I was about to embark into the crazy world of VBA programming for Excel but wanted to conduct a feasibility study first to make sure that what I wanted to do was even possible...

Can I use VBA programming for a macro in Excel to perform all or some of the actions below?

1. Have a master spreadsheet pull information directly from a data set on another spreadsheet
2. Have the master spreadsheet automatically adjust to allow for the length of the new data set (i.e., the number of rows and spacing between rows/columns of other data etc.)
3. Have two data sets form a third data set which combines all the information into a single column
4. Have rows of duplicated data erased automatically

If this is possible to do, how difficult would this be to write?

Thank you.

--Andrew

 

[schielrn]

Welcome to the Board!

Yes all of those would be capable of being done in VBA. Number 1 should be pretty easy and you can search the board for pulling data into a master sheet. Number 2 is very easy if you just want it to go into the next blank row, but is pretty simple to also skip rows. Number 3 should be pretty easy also, just search the board for combining data in one column using VBA. Number 4 there is also a lot of literature out on the board and can be done in many of ways.

Hope that helps.

 

[xld]

It is simple if you know what you are doing. If you don't, the skilling up might make it seem tortuous.