Extract data from other spreadsheets in the same document
Closed
luigi206
Posts
2
Registration date
Wednesday 1 May 2013
Status
Member
Last seen
2 May 2013
-
1 May 2013 à 12:47
luigi206 Posts 2 Registration date Wednesday 1 May 2013 Status Member Last seen 2 May 2013 - 2 May 2013 à 18:27
luigi206 Posts 2 Registration date Wednesday 1 May 2013 Status Member Last seen 2 May 2013 - 2 May 2013 à 18:27
Related:
- Extract data from other spreadsheets in the same document
- Extract audio from video vlc - Guide
- Tmobile data check - Guide
- Notepad++ document list panel - Guide
- Data transmission cable - Guide
- How to watermark word document all pages - Guide
2 responses
sgmpatnaik
Posts
52
Registration date
Tuesday 2 April 2013
Status
Member
Last seen
27 November 2013
45
2 May 2013 à 03:17
2 May 2013 à 03:17
Hi
Is it possible to upload a sample file
Thanks
Patnaik
Is it possible to upload a sample file
Thanks
Patnaik
luigi206
Posts
2
Registration date
Wednesday 1 May 2013
Status
Member
Last seen
2 May 2013
2 May 2013 à 18:27
2 May 2013 à 18:27
I want to perform the following operation:
=IF('Veh304'!$C$51=0,"No action required",IF('Veh304'!$C$52=1,"Convert to CNG","Replace with CNG"))
in 'Veh304' , 304 is the number that I want to use as a variable. The macro that I am trying to do is change the number 304 that is a number that I have in the master sheet and replace it with the other numbers that are located in the same column. Also 'Veh304' is the name of the sheet where the data that I am trying to analyze is located.
Thanks
=IF('Veh304'!$C$51=0,"No action required",IF('Veh304'!$C$52=1,"Convert to CNG","Replace with CNG"))
in 'Veh304' , 304 is the number that I want to use as a variable. The macro that I am trying to do is change the number 304 that is a number that I have in the master sheet and replace it with the other numbers that are located in the same column. Also 'Veh304' is the name of the sheet where the data that I am trying to analyze is located.
Thanks
