More Visual Basic Answers
Question Library
Ask a question about Visual Basic
Volunteer
Experts of the Month
Expert Login
Awards
About Us
Tell friends
Link to Us
Disclaimer
|
| |
|
|
| |
| | | |
About Ravindra
Expertise
visual basic application programming from design to access information, sql, engineering and commercial applications. access databases, excel.
Optional:
1)a large number of people want me to do work which takes some time and effort. Pl.note that i would like to be paid for such work.
2) if you want me to spend quality time and do special work, i expect to be paid a reasonable price for my time.
3) if you are pleased with my reply you could consider a donation of 1$.
4) you can visit my website http://ravindra.coolpage.biz (under constrn)
Experience
Past/Present clients
project work for a Norway company, and a Canadian company completed. Freelance Project work and Teaching
teaching vb
| | |
| |
You are here: Experts > Computing/Technology > Basic > Visual Basic > Excel Macros
Expert: Ravindra
Date: 10/11/2008
Subject: Excel Macros
Question
QUESTION: I have to sheets. Sheet 1 have some columns like 1,2,3,4 and rows A,B,C,D_ _
_not fixed. Can increase (Dynamic).I have sheet 2 with some values same way.
I have to match sheet 1 & 2 by values in column 1 . If they do not match i have
to write the data from sheet 1 to sheet 3 (Copy data from sheet 1 with all the
columns values 1,2,3,4)
both rows and columns are dynamic.
ANSWER: what is the question
---------- FOLLOW-UP ----------
QUESTION: i wanna make a macro for this thing.
Answer
remember that this is a free site and you are using my time. if you want any help, you should be clear,specific and explain most of it the first time.
i wanna make a macro for this thing is not a question.
i do not want to make the whole macro for you free.
also you should be careful in using words like dynamic, what does both rows and columns are dynamic mean? it means nothing to me.
and your description of the problem is erroneous, rows are not A,B,C,D they can only be numbers.
how can you match the whole sheet? there may thousands of rows, also the logic of comparing 2 existing columns and write the same data to a third sheet does not make logic to me.(it may be having practical need, i admit)
in brief, you should not ask vague questions
Add to this Answer
Ask a Question
|
|
