VBA to fetch data from next sheet using command button

**Daniel_12** · 04-22-2013, 05:25 AM

Hi ,

Please find attached sample.

I am trying to write a VBA code where once I click the command button it should fetch data from sheet 2 and give the exact number in sheet 1.

Kindly let me know if you need any more input in understanding the problem.

Thanks,
Daniel

**:) Sixthsense :)** · 04-22-2013, 05:42 AM

Looking for VBA code alone or formula suggestion is acceptable?

**Daniel_12** · 04-22-2013, 05:45 AM

I tried formula but it is not helping, but anything is ok as long as it meets the requirement. thanks for ur help.

**:) Sixthsense :)** · 04-22-2013, 06:03 AM

In A3 Cell

Formula:

Please Login or Register  to view this content.

Drag it right...

In K3 Cell

Formula:

Please Login or Register  to view this content.

Drag it right...

The above formula's not taken the Condition & Status in consideration. Some of your header data in sheet1 cells have extra spaces, please remove it.

**Daniel_12** · 04-22-2013, 06:15 AM

If i click the command button the data should automatically get updated in the respective cells and I think that can't be done with the formula you gave. Sorry if I made you misunderstood something here.

**:) Sixthsense :)** · 04-22-2013, 06:19 AM

No problem and I am unable to understand why you need command button here

since the forumla's will get auto updated whenever any change in the source data.

**Daniel_12** · 04-22-2013, 06:25 AM

Actually in real scenario the data is so huge and in single click all the data should get updated for example the logic you gave on cell A3 and K3 as well as I have to add few more logic and everything should get update on one click of the command button thats the reason I asked for a VBA code instead of formula.

**:) Sixthsense :)** · 04-22-2013, 06:34 AM

Dani thanks for the explanation, but I am not seeing any need for going to vba solution since the example you shown me is just getting floated in that allocated columns alone and you are just getting the count and sum from it. If possible clarify me the need by showing the data, possibly me too can offer you the VBA code

**Daniel_12** · 04-22-2013, 07:15 AM

I can't share the data due to some confidential info but the sample sheet is having all the required information, kindly if possible create a VBA code for that scenario so that I can add up more on the same.

**:) Sixthsense :)** · 04-22-2013, 07:18 AM

Please never post any confidential data, we just require xyz of data to understand the logic alone. Sorry I am unable to understand the need of vba so I hope someone will take care of this thread.

**Daniel_12** · 04-22-2013, 07:24 AM

Ok thanks a lot sixth sense...I really appreciate your quick response and detailed explanations.

VBA to fetch data from next sheet using command button

LinkBack

Thread Tools

Rate This Thread

Display

VBA to fetch data from next sheet using command button

Re: VBA to fetch data from next sheet using command button

Re: VBA to fetch data from next sheet using command button

Re: VBA to fetch data from next sheet using command button

Re: VBA to fetch data from next sheet using command button

Re: VBA to fetch data from next sheet using command button

Re: VBA to fetch data from next sheet using command button

Re: VBA to fetch data from next sheet using command button

Re: VBA to fetch data from next sheet using command button

Re: VBA to fetch data from next sheet using command button

Re: VBA to fetch data from next sheet using command button

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions