Excel Formula add data if columns match
Closed
kv
-
Sep 4, 2009 at 01:44 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 20, 2010 at 09:37 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 20, 2010 at 09:37 AM
Related:
- Excel Formula add data if columns match
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- Transfer data from one excel worksheet to another automatically - Guide
3 responses
sadgurl
Posts
697
Registration date
Thursday May 14, 2009
Status
Member
Last seen
November 24, 2010
219
Sep 4, 2009 at 02:32 PM
Sep 4, 2009 at 02:32 PM
Well I guess for the first part I should be like this
dim n as interger
for n = 0 to 2
if sheet1.cells(n,0) = Sheet2.cells(0,0) then
Sheet2.Name = "toy"
next
endif
this part take the cells A1 in sheet1 and compare it to the cells in colum a of sheet 2, if the answer is true the sheet is name as toy,
for the rest am sorry but I dont clearly see what you mean
dim n as interger
for n = 0 to 2
if sheet1.cells(n,0) = Sheet2.cells(0,0) then
Sheet2.Name = "toy"
next
endif
this part take the cells A1 in sheet1 and compare it to the cells in colum a of sheet 2, if the answer is true the sheet is name as toy,
for the rest am sorry but I dont clearly see what you mean
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 20, 2010 at 09:37 AM
Aug 20, 2010 at 09:37 AM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.
Note: your data need not be to be real data but a good representative of how data looks like
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.
Note: your data need not be to be real data but a good representative of how data looks like